E to place various control items such as buttons on a

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: ion within the form so that users cannot randomly navigate to any item. E. To place various control items (such as buttons) on a single block that is not related to a table in the database. Answer: E QUESTION 61: You want to find out if a certain menu item exists in the menu that is attached to a form, so you use the following code in a When-Button-Pressed trigger. DECLARE mi_id BOOLEAN; BEGIN MI_ID:= FIND_MENU_ITEM('File.Exit'); IF mi_id THEN MESSAGE('The Exit menu item exists'); END IF; END; Is this code correct? If not, what would you need to change? A. No changes are needed; the code is correct. B. Use a different built-in; FIND_MENU_ITEM is not correct. C. Do not place the menu item name in single quotes; precede it with a colon instead. D. The variable mi_id should be of the MENU_ITEM data type, and the IF clause should check to see that the variable is not null. E. Change the arguments for FIND_MENU_ITEM; the menu name and the menu item name should be separate arguments. Answer: D Actualtests.com - The Power of Knowing 1Z0-141 QUESTION 62: Exhibit: You use the Data Block and Layout wizards to create a block based on the ORDER_ITEMS table. The table does not include a column for the item total, so you create a text item in the block to display the item total. You change six properties for the Item_Total text item, then run the form and execute a query. The exhibit shows the form as it appears at run time. What are four of the properties of the Item_Total item that you manually changed? (Choose four) A. Update Allowed B. Column Name C. Database Item D. Format Mask E. Summary Function F. Enabled G. Update Only If NULL H. Justification Answer: C,D,F,H QUESTION 63: Exhibit: The DBA added a STATE column defined as VARCHAR2(2) to the CUSTOMERS table. This column will contain two-letter state abbrevations; because the CUSTOMERS table is quite large, storing complete state Actualtests.com - The Power of Knowing 1Z0-141 names would waste space in the database. The DBA asks you to add a c...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online