The value needed to generate this summary data are

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: the fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? A. Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. B. Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. C. Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Actualtests.com - The Power of Knowing 1Z0-132 Source Arguments properties to enter the SELECT statement. D. Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property. E. Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. F. Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property. Answer: F Explanation: Data block based on "FROM" clause can retrieve data from multiple table in the database without the need to create any object in the database server. This is done by creating the Data Bock manually in the Object Navigator and specify the Data Source type as "FROM" Clause query and enter the SELECT statement in the Query Data Source Name Property. QUESTION 24: The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view? A. REF cursor. B. Instead Of trigger. C. Stored procedure that returns object values. D. The underlying view cannot be modified because DML on a view is not supported. Answer: B Explanation: When the Update Allowed property is set to YES and the block is based on view on the database server, Instead Of Triggers should be used to update the underlying tables that the view depends on. This trigger will fire whenever the user updates a value through the view. REF Cursors and Stored Procedures that returns object values will not update the values in the underlying view in the server. Views can not be modified using DML operation unless instead of trigger exists. QUESTION 25: You are developing the Payroll application that contains the SALARY and COMMISSION forms. When a user invoked the COMMISSION form from the SALARY form, the SAL value should be passed to the COMMISSION form. In which data form and at what time should you define the parameter to accept the value? A. SALARY form at runtime. B. SALARY form at design time. C. COMMISSION form at runtime. Actualtests.com - The Power of Knowing 1Z0-132 D. COMMISSION form at design time. Answer: D Explanation: If the called form will contain parameter value then the parameter should be created at design time in the called form "COMMISION FROM", Then in the calling form "SALARY" form will have to create a parameter and assign it a value using CREATE_PARAMETER_LIST and ADD_PARAMETER which will create a parameter list that includes the specific parameter which is then used in the OPEN_FORM method to open the COMMISSION form and pass the value of parameter to the COMMISION form. Example : declare MyParameter PARAMLIST; begin MyParameter := CREATE_PARAMETER_LIST('wh_pl'); ADD_PARAMETER (MyParameter , 'wh_param',TEXT_PARAMETER,:Commision_id); OPEN_FORM('COMMISION', ACTIVATE, NO_SESSION,NO_SHARE_DATA, 'wh_pl'); end; here wh_pl Is the parameter list and MyParameter is the parameter to be passed QUESTION 26: At design time, you create a query record group for the LOV associated with the HOTEL text item in a form module for the Travel Planner Application. When is the record group deleted? A. When the user navigates to the HOTEL item. B. When the form module successfully compiles. C. After Form Builder validates the SELECT statement and dismisses the New Record Group dialog box. D. When the user enters data in the HOTEL item, and the Validate from List property for the HOTEL item is set to YES. Answer: D Explanation: When LOV that contain record group value attached to a text item the record group will be deleted when user enters data in the text item. This will be if the text item Validate from List property is set to YES. Successful compilation of the form will not delete the record group neither navigation to the text item. QUESTION 27: Which object is added to a form module when you copy the reusable calender class? A. List icon B. Object group C. PL/SQL library Actualtests.com - The Power of Knowing 1Z0-132 D. Key-Listval trigger Answer: B Explanation: Calendar class when used in...
View Full Document

Ask a homework question - tutors are online