What is sql language?
What is optimistic concurrency?
What is Replication?
How can we improve performance by using SQL Server profiler?
Explain “not null constraint” in sql server?
How can I check if a view exists in a sql server database?
What are trace files?
What is isnull() operator?
Explain timestamp datatype?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is a schema in ms sql server 2005?
What is an sql server agent?
What are the two authentication modes in sql server?
Define model database?