What can you do to implement this a in the when new

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: t can you do to implement this? A. In the When-New-Form-Instance trigger, insert this code after the EXECUTE_QUERY built in: IF NOT FORM _SUCCESS THEN message(DBMS_ERROR_TEXT); END IF; B. In the When-New-Form-Instance trigger, insert this code after the EXECUTE_QUERY built in: IF NOT FORM_SUCCESS THEN message(SQLERRM); END IF; C. Place this code in a form-level On-Error trigger: IF ERROR_CODE = 40505 THEN message(DBMS_ERROR_TEXT); END IF; D. Place this code in a form-level On-Error trigger: IF ERROR_CODE = 40505 THEN message(SQLERRM); END IF; E. Add this exception handler to the When-New-Form-Instance trigger: EXCEPTION WHEN ERROR_CODE = 40505 THEN MESSAGE(DBMS_ERROR_TEXT); F. Add this exception handler to the When-New-Form-Instance trigger: EXCEPTION WHEN ERROR_CODE = 40505 THEN MESSAGE(SQLERRM); Answer: C QUESTION 9: Exhibit: Actualtests.com - The Power of Knowing 1Z0-141 Which of the items depicted in the Menu Editor (shown in the exhibit) must contain PL/SQL code? A. Exit and Save only. B. File, Edit, and Customers only. C. All items shown in the Menu Editor should contain PL/SQL code. D. Exit, Save, Customers Report, Open Customers, and Call Customers only. E. Exit, Save, Cut, Copy, Paste, Customers Form, Customers Report, Open Customers, and Call Customers only. Answer: D QUESTION 10: To centralize some of your processing, you decide to write PL/SQL library modules that contain procedures that can be called from the triggers or menu items. You want the message "Credit limit exceeded" to be displayed when the values in the order_total and credit_limit fields in the Orders form meet certain criteria. Which code do you use? A. IF :order_total > 10000 AND :credit_limit < 10000 THEN MESSAGE('Credit limit exceeded'); END IF; B. IF :SYSTEM.cursor_item > 10000 AND :SYSTEM.trigger_item < 10000 THEN MESSAGE('Credit limit exceeded'); END IF; C. IF NAME_IN('order_total') > 10000 AND NAME_IN('credit_limit') < 10000 THEN MESSAGE('Credit limit exceeded'); END IF...
View Full Document

Ask a homework question - tutors are online