If we delete pack Spec what will be the status of pack Body ?
Explain what is public role in sql server?
What are the properties of the relational tables?
What does it mean to normalize a database and why would you do it?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
Explain what is meant by replication of database?
Explain some stored procedure creating best practices or guidelines?
Why the trigger fires multiple times in single login?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
When would you prefer to have a minimum number of indexes?
How to recompile stored procedure at run time?
What is a transaction and why is it important?
Do you know what are various aggregate functions that are available?
What is the impact on other user sessions when creating indexes?