What are the types of resultset?
A trigger can reference objects outside the current database? State true or false.
can an order by clause be used in a creation of a view?
Does transparent data encryption provide encryption when transmitting data across the network?
What command would you use to create an index?
What are the advantages to use stored procedures?
Define msdb database?
Tell me what is use of except clause? How it differs from not in clause?
What is difference between index seek vs. Index scan?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
Can we update data in a view?
Difference between 2NF &3NF ?
How do you set a trace flag in sql server?
What is a document index?
What are the types of subscriptions in SQL Server replication?