Oracle 1Z0-151 Exam Questions & Answers

Correct Answer: C

See 5) below.

Note: Object Groups An object group is a logical container for a set of Forms Builder objects. You need to define an object group when you want to package related objects for copying or subclassing in another module or if you want to bundle numerous objects into higher-level building blocks that you can use again in another application. You can package the various objects in an object group and copy the entire bundle in one operation. Steps to create an object group

1.

Select the Object Group node in the Object Navigator.

2.

Select the Create icon.

3.

Rename the new object group that is displayed.

4.

Click the form module and expand all the nodes.

5.

Select all the objects of one type that you want to include in the object group.

6.

Drag the selected objects into the new object group entry.

Key notes about object groups

Including a block in an object group also includes its items, the item-level triggers, the block-level triggers

and the relations. You cannot use any of these objects in an object group without the block.

It is not possible to include another object group.

Deleting an object from a module automatically deletes the object from the object group.

Deleting an object group from a module does not delete the objects it contains from the module.

Correct Answer: AD

A: You should use DBMS_ERROR_CODE and DBMS_ERROR_TEXT in an ON-ERROR trigger to trap errors propagated from Oracle server from Forms.

Note: FORM_SUCCESS and FORM_TRIGGER_FAILURE

Either the FORM_SUCCESS built-in or the FORM_TRIGGER_FAILURE exception must be used to handle all Forms errors. FORM_SUCCESS is a Boolean function that evaluates to TRUE or FALSE depending on the success or failure of a Forms built-in. FORM_TRIGGER_FAILURE is an exception that has to be raised to stop further processing whenever an error occurs or FORM_SUCCESS evaluates to FALSE. The following sections describe their use in error-message handling.

Correct Answer: A

PL/SQL is the language used in Forms triggers and program units.

PL/SQL lets you declare variables and constants, then use them in SQL and procedural statements anywhere an expression can be used. You must declare a constant or variable before referencing it in any other statements.

Variables can have any SQL datatype, such as CHAR, DATE, or NUMBER, or a PL/SQL-only datatype, such as BOOLEAN orPLS_INTEGER.

Note:

PL/SQL's data types correspond with SQL's column types, making it easy to interchange PL/SQL variables with data inside a table.