This preview shows page 1. Sign up to view the full content.
Unformatted text preview: cord group in the EMP form is populated using a SELECT statement that is constructed
programmatically at runtime. Five employee records are displayed at one time, and a user chooses
item two from the record group. Which built-in would you use to determine which rows were flagged
in the record group?
Explanation: GET_GROUP_SELECTION Retrieves the sequence number of the selected row for the given
group. The GET_GROUP_SELECTION_COUNT built-in returns the number of rows in the specified
record group that have been marked using the SET_GROUP_SELECTION built-in.
QUESTION 42: Actualtests.com - The Power of Knowing 1Z0-132
You want to create a temporary table while executing a procedure in a form.
Which statement is true?
A. You cannot create a table form within Forms.
B. You must use the FORMS_DDL built-in to create the table.
C. You must use the DBMS_DYNAMIC_DDL package to create the table.
D. You can write the CREATE TABLE statement directly into the trigger.
Explanation: The FORMS_DDL built-in allows you to create dynamic SQL statements at runtime and to
issue DDL commands. All DDL operations issue an implicit COMMIT and will end the current transaction
without allowing Form Builder to process any pending changes, as well as losing any locks Form Builder
may have acquired.
Your end users will need to change values in a REF lookup field in the form application you create.
To facilitate choosing a new appropriate value, your provide them with?
A. An LOV for REFS.
B. A list item for REFs.
C. A radio group for REFs.
D. A hierarchical tree for REFS
Explanation: LOV is used to display REF lookup field because the same LOV gets attached to all the
lookup items associated with a particular REF. List item, radio group and hierarchical tree are not used for
REF lookup field.
Form_A invokes Form_B in Post-Only mode.
Which statement must be true?
A. Form_A has updates or deletes that have not been posted or committed, and Form_A invokes
Form_B with the OPEN_FORM built-in.
B. Form_A has updates or deletes that have not been posted or committed, and Form_A invokes
Form_B with the CALL_FORM built-in.
C. Form_A has inserts that have not been posted or committed, and Form_A invokes Form_B with the
D. Form_A has inserts that have not been posted or committed, and Form_A invokes Form_B with the
CALL_FORM built in.
Actualtests.com - The Power of Knowing 1Z0-132 Explanation: A form that is called from another form (with changes pending) using CALL_FORM is in
post only mode. When a form is in post only mode, it cannot perform commits. Changes to the called form
must be committed along with the change in the calling form by committing in the calling form. Post-only
mode can occur when your form issues a call to another form while unposted records exist in the calling
form. To avoid losing the locks issued by the calling form, Form Builder prevents any commit processing in
the called form.
Which value is valid for the iterate parameter in the CREATE_TIMER built-in function?
Explanation: The syntax for the CREATE_TIMER built-in is:
CREATE_TIMER (timer_name, milliseconds, iterate);
The value for iterate can be REPEAT or NO_REPEAT. The default is REPEAT. This instructs the timer to
repeat after each expiration. It will not repeat if the timer is created using the NO_REPEAT keyword.
Omitting the milliseconds parameter results in a compilation error.
You need to display a very large single-record data block. Since it will be so large, a convenient means
of navigation is needed between items. Which type of canvas would you use to display the data block?
A. Tab canvas.
B. Pop up canvas.
C. Spread table canvas.
D. Vertical toolbar canvas.
Explanation: Tab canvas can be used to display large data block, It can display items which make them
easy to navigate. No Popup canvas or Spread Table canvas or vertical toolbar used to display large blocks
You need to base a data block on the EMP table, but you do not want to give the users of the
application access privileges on the table. Which type of data source would you use to create the data
block? Actualtests.com - The Power of Knowing 1Z0-132
B. transactional trigger
C. stored procedure
D. FROM clause query
Explanation: Stored Procedure used to with IN parameter to retrieve data based on the parameter sent by
the application to display different data depending on the parameter sent. A SELECT statement is assigned
to a REF cursor when it is opened using the OPEN FOR statement. Therefore, the procedure could contain
multiple OPEN FOR statements, each with a different SELECT statement. The value of the IN argument
will then be evaluated to determine which OPEN FOR statement should be executed.
Examine this portion of code:
timer_id := FIND_TIMER('my_timer');...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09