⟩ Which system tables contain information on privileges granted and privileges obtained?
USER_TAB_PRIVS_MADE,
USER_TAB_PRIVS_RECD
USER_TAB_PRIVS_MADE,
USER_TAB_PRIVS_RECD
Tell us what different steps will a SQL Server Developer takes to secure SQL Server?
Tell us how can you control the amount of free space in your index pages?
Tell us what are the different Topologies in which Replication can be configured?
Tell me what are the different Authentication modes in SQL Server and how can you change authentication mode?
Tell us what is the difference between the 2 operating modes of Database Mirroring?
Tell me what are the commands used in DCL?
Do you know what ODBC is?
Tell us what are the different types of database compression introduced in SQL Server 2008?
Tell us what is a correlated sub-query?
Please explain what is meant by Active – Passive and Active – Active clustering setup?