Multiple choice technology programming languages

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

  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.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The UNDO_POLICY=REQUIRED option in SAS SQL ensures that if any rows in an INSERT or UPDATE operation fail to meet the specified integrity constraint criteria, the entire operation is rolled back and the table is restored to its original state before the operation began. This provides transactional integrity by preventing partial updates. Option C correctly describes this behavior.

Keep practicing — related questions