Five employee records are displayed at one time and a

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: 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? A. GET_GROUP_ROW_COUNT B. GET_GROUP_SELECTION_COUNT C. GET_GROUP_SELECTION D. FIND_GROUP E. FIND_COLUMN F. ADD_GROUP_ROW Answer: C 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: - 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. Answer: B 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. QUESTION 43: 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 Answer: A 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. QUESTION 44: 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 OPEN_FORM built-in. D. Form_A has inserts that have not been posted or committed, and Form_A invokes Form_B with the CALL_FORM built in. Answer: B - 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. QUESTION 45: Which value is valid for the iterate parameter in the CREATE_TIMER built-in function? A. CYCLE B. ITERATE C. NO_REPEAT D. REUSE Answer: C 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. QUESTION 46: 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. Answer: A 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 QUESTION 47: 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? - The Power of Knowing 1Z0-132 A. table B. transactional trigger C. stored procedure D. FROM clause query Answer: C 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. QUESTION 48: Examine this portion of code: timer_id := FIND_TIMER('my_timer');...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online