MS SQL Interview Questions

Have you ever prepared any project on SQL? Name the projects and specifications?
Define SQL server architecture?
Which are user defined data types? What is the use of these? How such data types are different from system defined data types?
State the difference between unique key and primary key?
How will you implement many to many, one- to- many- and one-to-one relationship while you are preparing a table? Explain the use of each relationship?
Describe: candidate key, alternate key and composite key?
Explain the isolation tables? How many types of isolation tables?
What is the active/ passive and active / active cluster? How these configurations are different from each other?
Define lock escalation? What can be the maximum size of a row and a column?
What commands are used in the creation of a table? State the difference between “CREATE TABLE” and “ALTER TABLE”?
Define normalization and use of normalization? Is it possible to edit and delete specific row and column afterwards?