Oracle Exam 1Z0-151 Topic 1 Question 17 Discussion

Actual exam question for Oracle's 1Z0-151 exam

Question #: 17
Topic #: 1

There are certain errors that are specific to the Salary item on the Employees form. You want to trap these errors only when the user navigates from the Salary item.

You have a form-level On-Error trigger that traps errors that apply to the form in general, but yon additionally code an item-level On-Error trigger for the Salary item.

When testing the form, you find that the general errors are not trapped when you navigate from the Salary item. What can you do to correct this problem?

ACall the form level On-Error trigger from the item-level On-Error trigger.

BCall the item-level On-Error trigger from the form-level On-Error trigger.

CChange the Execution Hierarchy property for the item-level On-Error trigger.

DChange the Execution Hierarchy property for the form-level On-Error trigger.

EMove all the code to a PL/SQL program unit and call it from both the form level and item level On-Error triggers.

Show Suggested Answer

Suggested Answer: C

when you have a WHEN-NEW-ITEM-INSTANCE : if you create a trigger on item, block and form-level, then only the ITEM-Level will start. If you use the exec-hierarchy Override. If all trigger use After, then the FORM, BLOCK and ITEM starts in that sequence. If all trigger use Before, then the ITEM, BLOCK and FORM starts in that sequence. the execution-hierarchy on FORM-Level is ignored, because there is no higher level than FORM

by Leonida at May 09, 2022, 08:12 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-151 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!