⟩ What is use of CASCADE CONSTRAINTS?
When this clause is used with the DROP command, a parent table can be dropped even when a child table exists.
When this clause is used with the DROP command, a parent table can be dropped even when a child table exists.
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?
Tell us what types of databases do you work with?