RelationalDBDesign RelationalDBDesign


Managing Constraints   «Prev  Next»

Implementing and Modifying Constraints - Quiz

Select the best answer or answers for each question.
 

1. If you are adding a constraint to an existing table and you include the keywords ENABLE NOVALIDATE, which of the following will occur?
Please select all the correct answers.
  A. No errors for the constraint will ever be returned.
  B. No errors for the constraint will be returned for existing data.
  C. Errors for the constraint for existing data will be returned.
  D. Errors for data entered or modified after the constraint is added will be returned.

2. You are adding a FOREIGN KEY constraint to a table. In practice, your users may be adding a row to the parent table which contains the referenced value at the same time they are adding a row to the child table with the foreign key column. You should include which keyword with your constraint definition?
Please select the best answer.
  A. NOVALIDATE
  B. EXCEPTIONS INTO
  C. DISABLED
  D. DEFERRABLE

3. Which column will not necessarily contain a value for every row in the USER_CONSTRAINTS data dictionary view?
Please select the best answer.
  A. DEFERRED
  B. DELETE_RULE
  C. STATUS
  D. CONSTRAINT_TYPE