Define primary key?

1202

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?

1102

What are entities and relationships?

1030

What xml support does the sql server extend?

1060

What is pessimistic concurrency?

1028

How to change the ownership of a schema in ms sql server?

1268

Why is the need for data conversion transformations?

1113

Tell me what is the significance of null value and why should we avoid permitting null values?

1045

What is raid and what are different types of raid levels?

1200

In which format does an image save in SQL Server database ?

1060

What are security principals used in sql server 2005?

1041

Define Wed Edition in SQL Azure?

102

When do you think a developer should use sql server-based cursors?

1107

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1064

What are the underflow and overflow behaviors on float literals?

1172