Answer b d explanation when record groups are created

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: red in the database. B. They are stored in local Forms memory. C. The type is specified explicitly at design time. D. The type is implied by when and how it is created. Answer: B, D Explanation : When record groups are created they will be stored in the local forms memory where they created. Record group can be created from a query with CREATE_GROUP_FROM_QUERY or created manually using CREATE_GROUP the type is implied by when and how it is created. QUESTION 65: You need to change the text of a pop-up menu that appears when a user right clicks the mouse in the EMP_DATA data block. Where could you find the node for the pop-up menu in the Object Navigator? A. Built-in Packages B. Menus C. PL/SQL Libraries D. Object Libraries E. Form Module Answer: E Explanation : Pop-up menus can be created in a form module. It must be attached to an item or canvas of a form. The user can click the right mouse button to invoke the pop-up menu when the mouse is on the item or canvas. QUESTION 66: Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully? A. FORMS_DDL B. DO_SQL C. FORM_SUCCESS D. FORM_NOT_SUCCESS E. DBMS.ERROR_CODE Answer: C Explanation : FORM_SUCCESS Returns the outcome of the action most recently performed during the current Runform session. Outcome Returned Value success TRUE failure FALSE fatal error FALSE - The Power of Knowing 1Z0-132 QUESTION 67: Examine the code below: FUNCTION check_window RETURN VARCHAR2 IS BEGIN RETURN (GET_VIEW_PROPERTY(GET_ITEM_PROPERTY( NAME_IN('system.cursor_item'), item_canvas), window_name)); END; What does this function return? A. The name of the item where the cursor is located. B. The name of the form where the cursor is located. C. The name of the window where the cursor is located. D. The name of the canvas where the cursor is located. Answer: C Explanation : The GET_ITEM_PROPERTY is used to retrieve property of a specific item. ITEM_CANVAS parameter Returns the name of the canvas to which the item is assigned. When used with GET_VIEW_PROPERTY which retrieve a property for specific view it will return the name of the window where the cursor is located since system.cursor_item is used in the GET_ITEM_PROPERTY. QUESTION 68: You are developing a Hotel Booking application for a travel company. The users request a wizardstyle interface for this application. How could you satisfy this requirement? A. Reference the Object Iron packages in your form module. B. Write an HTML interface, and invoke it from your form module. C. Include the Wizard class reusable component in your application. D. Build a customized wizard using tab canvases and a horizontal toolbar canvas. Answer: C Explanation : The Wizard class reusable component allows you to add a wizard-style interface to your application. This type of interface is similar to the wizards found in Oracle Developer builders. Creating an interface to step a customer through the playset building process is an ideal use of this component. This component is found in the stndrd20.olb library. You could build this wizard-style interface by using tab and horizontal toolbar canvases and writing the necessary code, but this would take much longer than using the Wizard class. QUESTION 69: Which statement about windows and blocks is true? A. Transaction management is block-oriented rather than window-oriented. B. Forms automatically navigates to an item located in an activated window. - The Power of Knowing 1Z0-132 C. A window may contain multiple blocks, but each block can only span one window. D. A window can contain multiple canvases, and an item can be located on multiple canvases. Answer: A Explanation : Transaction management in Oracle Forms is block based. Commit processing takes place in the block sequential order. Each item of a block may be assigned to a canvas and each canvas is assigned to a window. Therefore, a block can be displayed in multiple windows. QUESTION 70: What does the following code do? BEGIN IF GET_RECORD_PROPERTY(3, 'ORD', status) = 'CHANGED' THEN SET_RECORD_PROPERTY(3, 'ORD', status, query_status); END IF; END; A. If the third property in the ORD block is changed, set the status back to QUERY. B. If the third record in the current block is set to ORD, set the status back to QUERY. C. If three records are changed database records in the ORD block, set the status back to QUERY. D. If the third record in the ORD block is changed database record, set the status back to QUERY. Answer: D Explanation : SET_RECORD_PROPERTY Sets the specified record property to the specified value. QUERY_STATUS Specifies that the record is to be treated as a QUERY record, whether it actually is. The syntax is : SET_RECORD_PROPERTY ( record_number NUMBER , block_name VARCHAR2, property NUMBER, value NUMBER); So If the third record in the ORD block is changed database record, set the status back to QUERY. QUESTION 71: The data blocks in your form module are based...
View Full Document

Ask a homework question - tutors are online