When designing a database table, how do you avoi

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

(Continued from previous question...)

2. When designing a database table, how do you avoid missing column values for non-primary key columns?

2. When designing a database table, how do you avoid missing column values for non-primary key columns?
1. Use UNIQUE constraints
2. Use PRIMARY KEY constraints
3. Use DEFAULT and NOT NULL constraints
4. Use FOREIGN KEY constraints
5. Use SET constraints

(Continued on next question...)

Other Job Interview Questions

• Which of the following is the syntax for creating an Index?
• Which of the following commands is used to change the structure of table?
• Which one of the following must be specified in every DELETE statement?
• Which one of the following must be specified in every DELETE statement?
• Which of the following constraints can be used to enforce the uniqueness of rows in a table?
• Which of the following commands is used to change the structure of table?
• Which of the following statements about SQL Server comments is false?
• Which of the following has the highest order of precedence?
• When designing a database table, how do you avoid missing column values for non-primary key columns?
• Which of the following constraints can be used to enforce the uniqueness of rows in a table?
• More...