D use the data block wizard in reentrant mode to add

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: 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. Answer: A QUESTION 133: 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 Answer: F QUESTION 134: 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 side. 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 Records. 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. Answer: A,C,E QUESTION 135: 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.

Ask a homework question - tutors are online