This preview shows page 1. Sign up to view the full content.
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.
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.
IF mi_id THEN
MESSAGE('The Exit menu item exists');
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
Answer: D Actualtests.com - The Power of Knowing 1Z0-141
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
G. Update Only If NULL
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.
- Fall '09