what are defaults? : Sql server database administration
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
what is normalization? : Sql server database administration
what is Archive old data?
What is store procedure? When do you use?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Do you know exporting and importing utility?
What are the options which must be set to allow the usage of optimistic models?
diffrence between function and procedure
Mention the different types of replication in sql server.
What is a self join in sql server?
What is inline variable assignment?