nerdexam
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

1Z0-141 question #57 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)
  • A
    2% (1)
  • C
    83% (55)
  • D
    9% (6)
  • E
    5% (3)
  • F
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-141 Practice