Test: Quiz: Defining Not Null and Unique Constraints

Test: Quiz: Defining Not Null and Unique Constraints

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 1
(Answer all questions in this section)

1. A unique key constraint can only be defined on a not null column. True or False? Mark for Review
(1) Points


True


False (*)



Correct


2. A table must have at least one not null constraint and one unique constraint. True or False? Mark for Review
(1) Points


True


False (*)



Correct


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



Correct


4. A table can have more than one UNIQUE key constraint. True or False? Mark for Review
(1) Points


True (*)


False



Correct


5. A column defined as NOT NULL can have a DEFAULT value of NULL. True or False? Mark for Review
(1) Points


True


False (*)



Correct


6. 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



Correct