MSSQL DATABASE INTERVIEW QUESTIONS

What is a foreign key in MSSQL?

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

What are the benefits of using foreign keys in MSSQL?

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

How do you handle cascading actions with foreign keys in MSSQL?

What is the difference between a primary key and a foreign key in MSSQL?

How do you create a composite foreign key in MSSQL?

How do you check for foreign key constraints in MSSQL?

How do you troubleshoot foreign key violations in MSSQL?

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