Oracle
1Z0-141 · Question #118
1Z0-141 Question #118: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-141 to reveal the answer and full explanation for question #118. The question stem and answer options stay visible for context.
Question
The Orders form is required to initialize differently for different users. A database procedure (GET_ROLE_NAME) is used to determine which database roles are enabled for the user logging on to the form. If the user has the STORE_CLERK role enabled, certain buttons are disabled and the focus is sent to the Customer_Id text item. If the user has the ADMIN_MGR role enabled, all buttons are available and the focus is sent to the Date_Ordered text item. You have written a procedure (SET_BUTTONS) to set the appropriate button properties. The functionality is achieved with this code: IF get_role_name(USER) = 'STORE_CLERK' THEN set_buttons('STORE_CLERK'); GO_ITEM('ORDERS.Customer_id'); ELSE set_buttons('ADMIN_MGR'); GO_ITEM('ORDERS.Date_Ordered'); END IF; What is the best trigger to execute this code?
Options
- APre-Form at form level
- BWhen-Validate-Item at form level
- CWhen-New-Form-Instance at form level
- DWhen-Button-Pressed on any of the enabled buttons
- EPre-Block on the first navigable block in the form
- FWhen-New-Item-Instance on the Date_Ordered text item
Unlock 1Z0-141 to see the answer
You've previewed enough free 1Z0-141 questions. Unlock 1Z0-141 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.