What is acid properties?
What is forward - only cursors / read only cursor?
Describe about first three Normal forms.
What is indexing a document?
How can you stop stored procedures from recompiling?
What should be the fill factor for indexes created on tables? : sql server database administration
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What are the characteristics of modern DBMS?
How to determine the service pack currently installed on SQL Server?
how would you troubleshoot blocking? : Sql server database administration
how can do you the system monitoring?
What is difference between inner join and full join?
What is change tracking in sql server?