Explain collation?
Explain identity in sql server?
what is a cursor and what is its use?
What security features are available for stored procedure?
What are sp_configure commands and set commands?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What is normalization process?
What is field in algebra?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What is the data type of time?
Explain the new features of SQL server 2000?
What are exact numeric data types in ms sql server?
if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition