Oracle
1Z0-141 · Question #57
View the Exhibit. You are developing an Order Entry form. The When-New-Form-Instance trigger executes a query on the only block in the form. Instead of the alert shown in the exhibit, when the query…
The correct answer is C. Place this code in a form-level On-Error trigger. See the full explanation below for the reasoning.
Question
View the Exhibit. You are developing an Order Entry form. The When-New-Form-Instance trigger executes a query on the only block in the form. Instead of the alert shown in the exhibit, when the query cannot be performed you want to display to the user a message with the actual database error that is received. What can you do to implement this?
Exhibit
Options
- AIn the When-New-Form-Instance trigger, insert this code after the EXECUTE_QUERY built-in:
- BIn the When-New-Form-Instance trigger, insert this code after the EXECUTE_QUERY built-in:
- CPlace this code in a form-level On-Error trigger:
- DPlace this code in a form-level On-Error trigger:
- EAdd this exception handler to the When-New-Form-Instance trigger:
- FAdd this exception handler to the When-New-Form-Instance trigger:
How the community answered
(66 responses)- A2% (1)
- C83% (55)
- D9% (6)
- E5% (3)
- F2% (1)
Community Discussion
No community discussion yet for this question.
