MSSQL DATABASE INTERVIEW QUESTIONS

What is a business key in the context of MSSQL?

What is a natural key in MSSQL, and how does it differ from a surrogate key?

What is a candidate key in MSSQL?

How do you choose a business key for a table in MSSQL?

Can you provide an example of a table with a natural key in MSSQL and explain why it is considered a natural key?

How do you define multiple candidate keys in an MSSQL table?

What are the advantages and disadvantages of using natural keys in MSSQL?

How do you handle composite candidate keys in MSSQL?

How do you choose between a business key and a surrogate key in MSSQL?

Explain a scenario where using a candidate key is crucial for database design in MSSQL and describe how you would implement it.