MSSQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the CREATE TABLE statement in MSSQL?

How do you specify a primary key in a CREATE TABLE statement in MSSQL?

How do you create a table with default values for columns in MSSQL?

How do you define a foreign key in a CREATE TABLE statement in MSSQL?

How do you create a table with a composite primary key in MSSQL?

How do you create a table with a unique constraint in MSSQL?

How do you create a table with an identity column in MSSQL?

How do you create a table with check constraints in MSSQL?

How do you create a partitioned table in MSSQL?

Explain a scenario where creating a table with constraints is crucial for a business application in MSSQL and describe how you would implement it.