MSSQL DATABASE INTERVIEW QUESTIONS

What is a database table in MSSQL?

How do you create a new table in MSSQL?

What is the purpose of the PRIMARY KEY constraint in a table in MSSQL?

How do you add a new column to an existing table in MSSQL?

How do you rename an existing table in MSSQL?

How do you delete a table in MSSQL?

How do you enforce data integrity using foreign key constraints in MSSQL?

How do you create an indexed view to improve query performance in MSSQL?

How do you handle partitioning of large tables in MSSQL?

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