nerdexam
Oracle

1Z0-151 · Question #86

You put some code in a Post_Update trigger and raise the FORM_TRIGGER_FAILURE under certain conditions. Does a rollback take place if the trigger falls?

The correct answer is B. No. It is too late to perform a rollback at this stage because the update has already been applied. The record has already been updated. Note: FORM_FAILURE Returns a value that indicates the outcome of the action most recently performed during the current Runform session. Use FORM_FAILURE to test the outcome of a built璱n to determine further processing within any trigger. To…

Triggers

Question

You put some code in a Post_Update trigger and raise the FORM_TRIGGER_FAILURE under certain conditions. Does a rollback take place if the trigger falls?

Options

  • AYes. Although the update has been applied to the database, the old column values are retained as
  • BNo. It is too late to perform a rollback at this stage because the update has already been applied.
  • CThe value have already been applied, so you must programmatically save the old values in the global

How the community answered

(33 responses)
  • A
    6% (2)
  • B
    82% (27)
  • C
    12% (4)

Explanation

The record has already been updated. Note: FORM_FAILURE Returns a value that indicates the outcome of the action most recently performed during the current Runform session. Use FORM_FAILURE to test the outcome of a built璱n to determine further processing within any trigger. To get the correct results, you must perform the test immediately after the action executes. That is, another action should not occur prior to the test.

Topics

#Post-Update trigger#FORM_TRIGGER_FAILURE#rollback#transaction timing

Community Discussion

No community discussion yet for this question.

Full 1Z0-151 Practice