This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Set the Name property for the Order_Status item to ORDER_STATUS, because it must be uppercase to
match the column name in the database.
D. Use the Data Block Wizard in reentrant mode to add the item, because you cannot add a base table item by
changing the item type of an existing item.
Exhibit: Examine the form.
The text items are in the CONTROL block and are called FIELD1 and FIELD2 respectively.
There is a Pre-Text-Item trigger written on FIELD2 that contains the following code:
message(:system.cursor_item '-': system.trigger_item);
With the focus in FIELD1, what message will be displayed when you click in FIELD2?
A. FIELD1 - FIELD1
B. FIELD1 - FIELD2
C. FIELD2 - FIELD1
D. FIELD2 - FIELD2
E. CONTROL.FIELD1 - CONTROL.FIELD1
F. CONTROL.FIELD1 - CONTROL.FIELD2
G. CONTROL.FIELD2 - CONTROL.FIELD1
H. CONTROL.FIELD2 - CONTROL.FIELD2
Which three statements best describe a Table of Records in Forms Builder? (Choose three)
Actualtests.com - The Power of Knowing 1Z0-141
A. A Table of Records enables you to query and update multiple tables, and perform validation, on the server
B. A Table of Records is not efficient in terms of network traffic, because multiple round trips are required for
all the records to be returned.
C. Array processing cannot be used when a data block is based on a stored procedure that returns a Table of
D. A stored procedure that uses a Table of Records can be used only as a DML block datasource.
E. A stored procedure that uses a Table of Records can be used as both a query and DML block.
F. A stored procedure that uses a Table of Records can be used only as a query block datasource.
Which three statements best describe a Form Clause query in Forms Builder? (Choose three)
A. A FROM clause is a valid DML datasource for a data block.
B. A FROM clause is a valid query datasource for a data block.
C. A FROM clause cannot be used to prototype views.
D. A FROM clause allows you to nest a SELECT statement in the FROM clause of the da...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09