Oracle
1Z0-151 · Question #50
1Z0-151 Question #50: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-151 to reveal the answer and full explanation for question #50. The question stem and answer options stay visible for context.
Question
View the Exhibit. To test how the Orders application works with database triggers, you add to the Orders table the following database trigger that fires before the update of Customer_Id: BEGIN If :old.customer_id != : new.customer_id then RAISE_APPLICATION_ERROR (-20101, 'Database trigger says no!'); end if; END; You run the Orders form, change the customer ID, and click Save. You receive the error message "FRM-40509: Oracle error: unable to UPDATE record." You select Help > Display Error, and the Database Error dialog box that is shown in the Exhibit appears. Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead of the FRM- error message?
Exhibit
Options
- AIF ERROR_CODE = 40509 THEN
- BIF ERROR_CODE = 40509 THEN
- CIF ERROR_CODE = 06512 THEN
- DIF ERROR_CODE = 06512 THEN
- EIF ERROR-CODE = 20101 THEN
- FIF ERROR_CODE = 20101 THEN
Unlock 1Z0-151 to see the answer
You've previewed enough free 1Z0-151 questions. Unlock 1Z0-151 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.