If the user clicks cancel the cursor will remain in

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: to the next navigable item in the form. B. The LOV will appear. If the user clicks Cancel, the cursor will remain in the Job_ID item and an error message will appear. C. The LOV will not appear. The Job_ID item will be assigned the value IT_PROG. The cursor will move to the next navigable item in the form. D. The LOV will not appear. The Job_ID item will be assigned the value Programmer. The cursor will move to the next navigable item in the form. E. The LOV will not appear. The cursor will remain in the Job_ID item and an error message will display. Answer: C QUESTION 36: The validation unit for the Orders form is set to Item. This master-detail form contains an Order block and a multirecord Order Items block. Why might you want to create a When-Validate-Record trigger on the Orders block in this form? A. To check that all required items in the Orders block have values. B. To check that all required items in the Order Items block have values. C. To check that the shipping data for is not earlier than the order date. D. To perform some logic whenever a user navigates to a different record in the queried block. Answer: C Actualtests.com - The Power of Knowing 1Z0-141 QUESTION 37: Exhibit: Examine the PL/SQL code. The code uses the valmess package. To resolve compiler or run-time errors, what changes should you make to the trigger code? A. No changes are required. B. Delete the BEGIN and END keywords. C. Define an EXCEPTION section to handle exceptions. D. Define all Forms Builder variables with the format: :block_name.item_name. E. Define a DECLARE section to declare PL/SQL variables. Answer: D QUESTION 38: Exhibit: You are implementing a search function for employees that relies on the fact that the PREVIOUS_RECORD built-in fails when the cursor is in the first record. The code for the Search button is shown in the exhibit is: IF :control.search_text IS NOT NULL THEN GO_BLOCK('Employees'); Actualtests.com - The Power of Knowing 1Z0-141 LAST_RECORD; WHILE :employees.last_name != :control.search_text LOOP PREVIOUS_RECORD IF NOT FORM_SUCCESS then MESSAGE('Employees not found'); RAISE FORM_TRIGGER_FAILURE; END I...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online