What does Constraint refer to in MS SQL Server?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What does Constraint refer to in MS SQL Server?

Constraint in MS SQL Server refers to a rule associated to a column to enforce certain validation condition on that column.
For example, a UNIQUE constraint enforces a column to have unique values.

(Continued on next question...)

Other Job Interview Questions

• What is the use of *.ndf files in MS SQL Server?
• What is the use of *.ndf files in MS SQL Server?
• What is the T-SQL command to create a new login in MS SQL Server?
• What is a Stored Procedure in MS SQL Server?
• On MS SQL Server management tool, how would you find what actions you can perform for a particular object?
• What is the meaning of the following T-SQL command: SELECT TOP 10 * FROM user WHERE last_name = 'Johnson'
• What is setup.iss file used for during MS SQL Server installation?
• What is the meaning of the following T-SQL command: SELECT TOP 10 * FROM user WHERE last_name = 'Johnson'
• What is a Torn Page in MS SQL Server?
• Is T-SQL language syntax case-sensitive?
• More...