Which of the following statements is true regarding the UNDO_POLICY=REQUIRED option?

technology programming languages

  1. It must be used with the REQUIRED integrity constraint.

  2. It ignores the specified integrity constraints if any of the rows that you want to insert or update do not meet the constraint criteria.

  3. It restores your table to its original state if any of the rows that you try to insert or update do not meet the specified integrity constraint criteria.

  4. It allows rows that meet the specified integrity constraint criteria to be inserted or updated, but rejects rows that do not meet the integrity constraint criteria.

Show answer
Correct Option: C

Find more quizzes: