When the end user or the application changes the

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: 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. QUESTION 78: 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. Answer: A 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. QUESTION 79: 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) A. vector 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. QUESTION 80: Which two PL/SQL8 features are supported in Oracle Forms? (Choose two) A. methods 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. QUESTION 81: What is the data type returned by the CREATE_TIMER built-in? A. long B. timer C. number D. varchar2 Answer: B 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. QUESTION 82: 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. Answer: A 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. QUESTION 83: You want to make use of the object features available in the database for the form module you are developing. 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. Example: CREATE OR REPLACE TYPE name_typ AS OBJECT (f_name VARCHAR2(25), l_name VARCHAR2(25), initials VARCHAR2(7)); CREATE TABLE name_table OF name_typ; QUESTION 84: 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 runti...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online