What is relationship? What number of sorts of relationship are there?
What are the aggregate and scalar functions?
How m-m relationships are implemented?
How would you choose between a clustered and a non-clustered index?
Describe and explain about SQL native client?
Tell me what do you understand by a view? What does the with check option clause for a view do?
What is data modeling and Reterminal integrity?
what operator performs pattern matching?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What are the types of indexing?
role of sql sever 2005 in database rather than any other database
Does a server store data?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?