Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
Section 1
1. A table can have more than one UNIQUE key constraint. True or False?Mark for Review
(1) Points
True (*)
False
2. A column defined as NOT NULL can have a DEFAULT value of NULL. True or False?Mark for Review
(1) Points
True
False (*)
3. Which of the following is not a valid Oracle constraint type?Mark for Review
(1) Points
UNIQUE KEY
NOT NULL
EXTERNAL KEY (*)
PRIMARY KEY
4. If the employees table has a UNIQUE constraint on the DEPARTMENT_ID column, we can only have one employee per department. True or False?Mark for Review
(1) Points
True (*)
False
5. A unique key constraint can only be defined on a not null column. True or False?Mark for Review
(1) Points
True
False (*)
6. A table must have at least one not null constraint and one unique constraint. True or False?Mark for Review
(1) Points
True
False (*)