MSSQL DATABASE INTERVIEW QUESTIONS

What is a primary key in MSSQL?

How do you define a primary key when creating a new table in MSSQL?

Can a primary key consist of multiple columns in MSSQL? Provide an example?

How do you add a primary key to an existing table in MSSQL?

What are the benefits of having a primary key in an MSSQL database?

How do you drop a primary key from a table in MSSQL?

How do primary keys interact with foreign keys in MSSQL?

How do you handle duplicate values when setting a primary key in MSSQL?

How does indexing work with primary keys in MSSQL?

Explain a scenario where defining a primary key is crucial for database design in MSSQL and describe how you would implement it?