What is checkpoint in sql server?
In which files does sql server actually store data?
What is 3nf normalization?
Do you know the different ddl commands in sql?
How sql server executes a statement with nested subqueries?
Tell me the phases a transaction has to undergo?
mention different types of relationships in the dbms?
how many clustered indexes can be created on a table? : Sql server database administration
What are the types of user defined functions in sql server?
1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"
How to rebuild the master database?
What is factless fact table? : sql server analysis services, ssas
What is difference between index seek vs. Index scan?