Which of the following constraints can be used t

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

(Continued from previous question...)

7. Which of the following constraints can be used to enforce the uniqueness of rows in a table?

7. Which of the following constraints can be used to enforce the uniqueness of rows in a table?
1. DEFAULT and NOT NULL constraints
2. FOREIGN KEY constraints
3. PRIMARY KEY and UNIQUE constraints
4. IDENTITY columns
5. CHECK constraints

(Continued on next question...)

Other Job Interview Questions

• Which one of the following must be specified in every DELETE statement?
• Which of the following is the syntax for creating an Index?
• Consider the following transaction code
• Which of the following is the syntax for creating an Index?
• When designing a database table, how do you avoid missing column values for non-primary key columns?
• When designing a database table, how do you avoid missing column values for non-primary key columns?
• Which of the following has the highest order of precedence?
• The IF UPDATE (column_name) parameter in a trigger definition will return TRUE in case of an INSERT statement being executed on the triggered table
• Which of the following is the syntax for creating an Index?
• Which of the following is the syntax for creating an Index?
• More...