Can you force a query to use a specific index?
explain different types of constraints? : Sql server database administration
What are the different type of replication in sql server?
Define msdb database?
Explain log shipping?
Can we use where and having clause together?
What is clustered vs nonclustered index?
Do you know what is normalization of database? What are its benefits?
How to recreate an existing index in ms sql server?
What are the elements of dbms?
If a stored procedure is taking a table data type, how it looks?
What do you understand by recursive stored procedure?
do you know how to configure db2 side of the application? : Sql server database administration
Explain log shipping and mention its advantages.
Explain sql server service broker?