Oracle
1Z0-151 · Question #44
1Z0-151 Question #44: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-151 to reveal the answer and full explanation for question #44. The question stem and answer options stay visible for context.
Question
View the Exhibit. The Departments form has form level triggers defined as shown in the Exhibit. You have enabled array DML for the Departments block by setting its DML array size to 5 and setting the Primary Key property of Department id to Yes. You set runtime preferences for Forms Builder to use array processing. You want to test that array processing is actually occurring, so, as shown in the Exhibit, the On- Update, On-Delete, and on insert triggers have code that: 1. Displays a message to indicate which trigger is firing for which record? 2. Does the thing (either updates, deletes, or inserts) The other triggers simply display a message, indicating the trigger that is firing. You run the form from Forms Builder, but from the messages, you can tell that array processing is not occurring. What should you change so that array DML gets implemented?
Exhibit
Options
- ADelete the "On-" triggers; these triggers remove default processing, including array processing.
- BSet the DML array size to a value of 10 or greater; for array sizes loss than 10, array processing Is
- CUse the SYNCHRONIZE built-in after the MESSAGE built-in; otherwise, the message are not displayed
- DSet the Enforce Primary Key property of the Department block to Yes; it is not enough to just set the
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.