Oracle
1Z0-151 · Question #64
1Z0-151 Question #64: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-151 to reveal the answer and full explanation for question #64. The question stem and answer options stay visible for context.
Question
Customers log in to your Orders application by using their customer ID, which is saved as a global variable. When the Orders form first comes up, you want it to be populated with the customer's orders, and you do not want customers to be able to query for another customer's orders. You code the following triggers: When-New Form instance on the Orders form: GO_BLOCK('orders'); EXECUTE_QUERY; You also have a button in the Control block labeled Query Orders with a When-Button Pressed trigger that has the same code as the When New-Form instance trigger. To test the form, you run it and log in a Customer 104. When you click Query Orders, all orders are shown, not just those for Customer 104. What is the best way to correct this issue to ensure that the customer can never query another customer's orders?
Options
- ADelete the Key-Exeqry trigger and add the its first line after the call to GO_BLOCK in the When-
- BChange the last line of the When-Button-Pressed code to:
- CDelete the Key-Exqry trigger and put its code in an On-Select trigger.
- DDelete the Key-Exqry trigger and put its code in a Pre-Query trigger.
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.