MSSQL DATABASE INTERVIEW QUESTIONS

What is a DEFAULT constraint in MSSQL, and why is it used?

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

How do you specify a DEFAULT constraint for an existing column in MSSQL?

How do you remove a DEFAULT constraint from a column in MSSQL?

How do you check the default value of a column in MSSQL?

How do you provide a DEFAULT constraint for a column with a NULL value in MSSQL?

How do you use expressions as default values in MSSQL DEFAULT constraints?

How do you handle conflicts between DEFAULT constraints and INSERT statements in MSSQL?

How do you enforce business rules using DEFAULT constraints in MSSQL?

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