When the calculation completes it returns a single

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: data in the database. When the calculation completes, it returns a single value to the non-base table field. To optimize performance and maintainability, which PL/SQL structure should be used? A. A trigger in each form. B. A subprogram in each form. C. A stored subprogram in the database. D. A subprogram in a library that is attached to each form. Answer: D Explanation: Because the process required is to do calculations which is the same for both forms and no need to access database or change values in the tables and the result is a single value then the option of storing it as a subprogram in a library then attach it to each form will save you the time to create the same functionality twice for each forms more over you can maintain the code easily because on code will be attached for both forms as a library. QUESTION 8: A sales analyst reviews the first draft on your Sales application, and requests that the application Actualtests.com - The Power of Knowing 1Z0-132 graphically represent revenue generated for each sales representative, in addition to the textual data currently displayed for the ORDER block. How would you incorporate this graphic in your form? A. Invoke the Chart Wizard and create a chart based on the ORDER block. B. Create a chart using Graphics Builder and then select File Import Chart in Form Builder, positioning the new chart with the text items in the ORDER block. C. Invoke the Data Block Wizard in reentrant mode, select the Charts tab, and specify the chart type and column sources for the X and Y axes. D. Select the Chart node in the Object Navigator, Click the Create icon, and specify the details of the chart in the chart's Property Palette. Answer: A Explanation: Graphical representation is done be using the Chart Wizard to create charts of different types. Charts will represent the data available in the source block. Charts can not be created from the object navigator, Changing also can be done by the Chart Wizard. Data Bock wizard can not create charts. QUESTION 9: You want to implement a master-detail relation between data blocks based on object tables. How would you do this? A. Create the relation manually and coordinate the blocks using triggers. B. Base the relation on a REF pointer using the Data Block Wizard. C. Base the relation on a foreign key using the Data Block Wizard. D. This task is not possible because master-detail relations can be implemented only for blocks based on relation tables. Answer: B Explanation: Relation can be created on blocks based on objects table using the Data Block Wizard. When you select the Master Table from the wizard and the Child Table REF pointers will be listed in the wizard as items which can be used to base the relation of both blocks. Selecting the REF pointer is the only thing needed to base the relationship. QUESTION 10: You established access to menu modules using roles. You have allowed the sales role to access the menu module, but prevented access to the Update menu item. Which item property would you alter to gray out the menu option for the role? A. Item Roles. B. Menu Item Roles. C. Display without Privilege. D. Use Security. Actualtests.com - The Power of Knowing 1Z0-132 E. Command Type. Answer: C Explanation: When access is established in the menu module using roles. Each menu will be given the permission based on Oracle Server Roles created by DB A. The Display without Privilege item property in the menu will Disable "gray out" the menu item if user does not belong the role that have access to this menu item. QUESTION 11: You create a data block based on a relational table containing a REF column. You select the REF column for your form module. What is true about the items based on the REF column attributes? A. The Query Only property is set to Yes. B. The Conceal Data property is set to Yes. C. The Insert Allowed property is set to Yes. D. The Update Allowed property is set to Yes. Answer: A Explanation: If form contains blocks based on relational tables containing REF Columns. The REF column will be an item with property Query Only is set to YES automatically. Conceal Data and Insert allowed and Update Allowed property are set to NO. QUESTION 12: Which technique retrieves the error number when explicit DML fails? A. SQLCODE in an On-Error trigger. B. SQLCODE in an exception handler. C. DBMS_ERROR_CODE in an On-Error trigger. D. DBMS_ERROR_CODE in an exception handler. Answer: B Explanation: SQLCODE and SQLERRM returns the last Oracle Server error code and message due to an explicit DML within a form application. These function must be used in the exception handler of the program unit that issues the DML command. DBMS_ERROR_CODE return the last Oracle server error due to an implicit DML fail. QUESTION 13: Which two built-ins would you use to remove the HOUR_ALARM timer using the timer_id parameter? (Choose two) Actualtests.com - The Power of Knowing 1Z0-132 A. FIND_TIMER B. CREATE_TIMER C. SET_TIMER D. DELETE_TIMER E. GET_APPLICATION_PROPERTY Answer: A, D Explanation: To remove the timer FIND_TIMER is used to retrieve the...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online