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.
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.
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.
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.
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
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.
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.
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
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.
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.
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.
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.
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
Answer: A, D
Explanation: To remove the timer FIND_TIMER is used to retrieve the...
View Full Document