What is a periodical index?
What are the features of Embedded SQL
Explain various On-Delete options in a DB table. Which is the default option?
Do you know what is a trace frag? Where do we use it?
what is an extended stored procedure? : Sql server database administration
what is a deadlock? : Sql server database administration
What is a view and what are its advantages?
Does an index slow down updates on indexed columns?
Define normalisation?
How can you check the version of sql server?
Explain “row_number()” in sql server with an example?
What do you understand by mirroring?
query processing
What is sql or structured query language?
What is the concept of optimization?