Oracle Application Technical Consultant Interview Questions and Answers for Freshers

Value sets can be related in Oracle Apps by using cross validation rules.

• Create cross validation rules to relate one value set with another

• Define the conditions under which values from one value set can be used with values from another

• Cross validation rules can be set up at the segment level in the value set definition

• Example: Creating a cross validation rule to ensure that a specific department can only be associated with certain projects

There are 6 types of report triggers in Oracle Reports.

• BEFORE REPORT trigger

• AFTER REPORT trigger

• BEFORE PARAMETER FORM trigger

• AFTER PARAMETER FORM trigger

• BEFORE REPORT BODY trigger

• AFTER REPORT BODY trigger

A cursor is a database object used to manipulate data in a result set.

• A cursor is used to retrieve data from a database one row at a time.

• There are two types of cursors: implicit and explicit.

• Implicit cursors are used for single-row queries, while explicit cursors are used for multi-row queries.

• Examples of explicit cursors include FOR LOOP and OPEN-FOR-FETCH-CLOSE.

• Cursors can be used to update, delete, or insert data into a database.