This preview shows page 1. Sign up to view the full content.
Unformatted text preview: rom which the current item
should derive its value. Setting this property synchronizes the values of the two items, so that they
effectively mirror each other. When the end user or the application changes the value of either item, the
value of the other item changes also. This property is used when you define master-detail relationship
between two blocks.
You write a procedure that will be called from two level triggers and a database trigger.
Where should you store this code?
A. On the Oracle server.
B. Locally in each form module.
C. In an attached PL/SQL library
D. On your file network server.
Explanation : Stored Procedures are stored in Oracle Server. These stored procedures can be called by the
form applications and from the triggers specified in Forms. Stored procedure can be called also from
database triggers. Database triggers can not call libraries stored in Forms at the client applications.
You need to create a data block for query operations in the RETIRED_EMPLOYEES form module.
Which three data sources can you use for this block? (Choose three)
B. database view
C. database table
Actualtests.com - The Power of Knowing 1Z0-132
D. transactional trigger
E. PL/SQL table of records
F. multi-dimensional array
Answer: B, C, D
Explanation : A data block can be based on a relational table, Database view, an object table that is based
on a single object type, and a relational table that uses a REF column. It cannot be based on a varray column,
a stored procedure that returns an object value, and object tables that are based on a complex type.
transactional triggers are typically used when Form Builder is running against a non-ORACLE data source.
These triggers include ON-FETCH, ON-LOCK, ON-ROLLBACK.
Which two PL/SQL8 features are supported in Oracle Forms? (Choose two)
B. object tables
C. object columns
D. collection types
E. object as stored procedure parameters
Answer: B, C
Explanation : Blocks can be based on object tables and items can be based on object columns within Oracle
Forms. Oracle Forms also supports declaration of LOB variables. However, Oracle Forms does not support
the declaration of collection variables. It also does not support objects as stored procedure parameters.
What is the data type returned by the CREATE_TIMER built-in?
Explanation : The CREATE_TIMER built-in returns the internal ID of the timer. Therefore, the V_TIMER
variable must be declared with a datatype of TIMER.
You have written a custom menu for a Forms application. You saved the menu module to the file
custmenu.mmb. In the Property Palette for the form, you set the Menu Module property to custmenu.
When you run the form, the custom menu does not appear.
What can you do to fix this problem? Actualtests.com - The Power of Knowing 1Z0-132
A. Generate the menu module executable.
B. Save the menu module as custmenu.mmx.
C. In the Property Sheet for the form, set the Starting Menu property to custmenu.
D. In the Property Sheet for the form, set the Menu Module property to custmenu.mmb.
Explanation : An Oracle Developer menu module must be compiled to create the executable file (.MMX).
This file must be attached to a form application.
Select File-->Administration-->Compile File to compile a menu. To attach the menu module to a form,
navigate to the form module property sheet and locate the Menu Module property. Specify the name of the
menu in this property.
You want to make use of the object features available in the database for the form module you are
Which three statements about object types are true? (Choose three)
A. An object type is a user-defined composite data type.
B. The attributes of an object type can be those of other object types.
C. A PL/SQL table of records is an example of a nested object type.
D. An object type must be declared as a type before the actual object itself can be declared.
Answer: A, B, D
Explanation : Object types is a user-defined composite data type and each attribute of an object type can be
an object type of other types specified. But object types must be declared first as type before they are
declared in other object types.
CREATE OR REPLACE TYPE name_typ AS OBJECT
CREATE TABLE name_table OF name_typ;
What are three uses for record groups? (Choose three)
A. To pass data to a pop-up menu.
B. To populate a base table block.
C. To pass data to other form modules.
D. To pass data to other Oracle products.
E. To dynamically construct SELECT statements.
F. To server as the source for a FROM clause query.
Answer: C, D, E
Actualtests.com - The Power of Knowing 1Z0-132
Explanation : Regardless of how a record group is created, it can be used to send information to another
form or Oracle Developer product such as Reports and Graphics. The SELECT statement can be built during
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09