How can you tell if a database object is invalid?
What are the steps to insert a table?
What command must you use to include the not null constraint after a table has already been created?
What is a trigger?
Explain the truncate command? : SQL Server Architecture
what is the sql equivaent of the dataset relation object ?
Explain alternate key, candidate key and composite key in sql server?
what is bit data type? and what are the information that can be stored inside a bit column?
What are transactions in sql?
How many types of system privileges are there, Can we add or delete privileges?
What are SQL Jobs, please mention the use of it and how to create them.
What is the difference between distinct clause and group by clause?
what are the joins,primary key,foriegn key, candidate key, super key and expain them?