Home > Interview Question and Answer > Oracle > Oracle Cross Products and Matrix Reports

Interview Questions and Answers for Oracle Cross Products and Matrix Reports

Interview questions and answers for Oracle database Oracle Cross Products and Matrix Reports Interview Questions and Answers Oracle Cross Products and Matrix Reports Interview Questions includes, cross product creation, distinguished from a group, user exit used for, types of user exits, Oracle call interface, statement EXECIAFGET & EXECIAFPUT, use of SRW. MESSAGE function.

Oracle Cross Products and Matrix Reports Interview Questions and Answers

1. How can a cross product be created?

By selecting the cross products tool and drawing a new group surrounding the base group of the cross products.

2. How can a group in a cross products be visually distinguished from a group that does not form a cross product?

A group that forms part of a cross product will have a thicker border.

3. Atleast how many set of data must a data model have before a data model can be base on it?

Four

4. Is it possible to have a link from a group that is inside a cross product to a group outside ? (Y/N)

No.

5. Is it possible to link two groups inside a cross products after the cross products group has been created?

No.

6. What is an user exit used for?

A way in which to pass control (and possibly arguments ) form Oracle report to another Oracle products of 3 GL and then return control ( and ) back to Oracle reprots.

7. What are the three types of user exits available ?

Oracle Precompiler exits, Oracle call interface,NonOracle user exits.

8. How can values be passed bet. precompiler exits & Oracle call interface?

By using the statement EXECIAFGET & EXECIAFPUT.

9. How can I message to passed to the user from reports?

By using SRW.MESSAGE function.

Go Back to Oracle Interview Qusetion and Answers

More Oracle Database, DBA, Forms and Reports Interview Question and Answers