Oracle
1Z0-151 · Question #90
1Z0-151 Question #90: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-151 to reveal the answer and full explanation for question #90. The question stem and answer options stay visible for context.
Question
View the Exhibit. You have placed the following code in a Post insert trigger on the Orders block: SELECT orders_seq.NEXTVAL INTO :orders.order_id FORM SYS.dual; You have also set Item properties for the Order_Id Item in the form so that users cannot directly enter an Order ID. As the SUMMIT user, you run the form to test it. You are able to insert a record in the block, but when you click Save, you have a database error as shown in the Exhibit. What is the probable cause of this error?
Exhibit
Options
- AThe code should be in Pre_insert trigger instead
- BThe code should be in a database trigger instead
- CYou should change the code to select the sequence number from SUMMIT.dual instead.
- DYou should create the sequence in the database, because the runtime error is an indication that is
- EYou should assign a temporary value to the Order_Id item before saving the form.
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.