This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ype can you assign to the data block for this form without having the DBA create
a database object?
A. database table
B. transactional trigger
C. stored procedure
D. FROM clause query
E. client-side procedure
Explanation : The From clause data source enables you to create a block based on a SELECT statement.
This is similar to basing a block on a view, however, the view does not have to be created in the database.
When a query is executed on this type of block, the SELECT statement is sent to the database, and the
resultant rows are returned to the block. Use this data source in place of creating a database view or table.
However, unlike a table or view, DML operations are not allowed.
Where can you add your own PL/SQL code in relation-handling triggers?
A. Before the "End default relation program section" comment.
B. After the "Begin default relation program section" comment.
C. Before the "Begin default relation program section" comment.
D. It is not possible to modify the relation-handling code that Forms automatically creates for relations.
Explanation : Relation-Handling triggers are created automatically when relation is built between Master
and Detail blocks. Relation-handling will have comments inserted automatically Before the "Begin" and
after the "End" default sections to allow users to replace them with developer PL/SQL custom code.
Which value is valid for the iterate parameter in SET_TIMER built-in procedure?
Actualtests.com - The Power of Knowing 1Z0-132
Explanation : SET_TIMER Changes the settings for an existing timer. You can modify the interval, the
repeat parameter, or both. The parameter NO_CHANGE Specifies that the milliseconds property is to
remain at its current setting.
You create a data block based on a relation table containing a REF column. You select the REF
column for your form module.
Which statement about the REF column is true?
A. It is created as a nondisplay item.
B. The Lock Record property is set to Yes.
C. It cannot be referenced in item level triggers.
D. It is placed on the canvas with the highest sequence number.
Explanation : When creating a data block based on a table that contains a REF column, the Data Block
Wizard will display two instances of this type of column. The first instance is the regular object column and
all of its attributes. Selecting the attributes of this instance creates normal items in the data block. The
second instance is the REF itself. Choosing this instance creates a nondisplay item on a null canvas.
Which three objects can be components of a menu module? (Choose three)
C. object groups
D. report objects
E. visual attributes
Answer: B, C, E
Explanation : Menu module components could be parameters which can be passed between menu item and
forms. Also menu module component could be Object Group and Visual Attributes.
You create a package that contains PL/SQL variables that must be shared among several forms in the
Travel application. You place the package in a library and attach the library to all the forms that need
to share the data.
Which parameter in the OPEN_FORM built-in must you set to ensure that changes made by one
form are visible to the other forms in the application?
Actualtests.com - The Power of Knowing 1Z0-132 A. data_mode
Explanation : Use OPEN_FORM to create multiple-form applications, that is, applications that open more
than one form at the same time. Data mode value is NO_SHARE_LIBRARY_DATA (The default.) At
runtime, Form Builder will not share data between forms that have identical libraries attached (at design
How can you change the cursor style in your form?
A. Open the form module property palette and set the Cursor Style property.
B. From the Tools menu, select Preferences-->Runtime Settings.
C. Use the GET_APPLICATION_PROPERTY and SET_APPLICATION_PROPERTY built-ins.
D. You cannot change the cursor style.
Explanation : GET_APPLICATION_PROPERTY and SET_APPLICATION_PROPERTY built-ins are
used to Get and Set properties of the form applications. CURSOR_STYLE parameter Returns the name of
the current cursor style property.
Which trigger property applies to Key triggers?
A. Hide Keys
B. Show Menu Keys
C. Hide Menu Keys
D. Display in 'Keyboard Help'
E. Hide Keys Description
Explanation : Key triggers allow you to modify the standard functionality of a function key. These triggers
are subprograms that execute when a certain key is pressed. Key triggers allow you to modify, replace, or
disable the standard functionality of a function key. Display in 'Keyboard Help' can be an application of key
Which two statements are true about record groups? (Choose two) Actualtests.com - The Power of Knowing 1Z0-132
A. They are sto...
View Full Document
- Fall '09