Oracle Reports Interview Questions & Answers Part -2

Questions:

• Interview Questions on Oracle Reports Part-2
• Oracle Reports Technical Interview Questions & Answers Part-2
• D2K Technical Interview Questions And Answers Part-2

1.What are the various types of reports ?

There are 8 Types of reports in oracle report.

1.Tabular

2. Form Like

3. Form Letter

4. Mailing Label

5. Group Left

6. Group Above

7. Matrix

8. Matrix with group

2. What are Anchors in Oracle Reports?

An anchor defines the relative position of an object to the object to which it is anchored. Anchors are used to determine the vertical and horizontal positioning of a child object relative to its parent. Since the size of some layout objects may change when the report runs (and data is actually fetched), you need anchors to define where you want objects to appear relative to one another.

3. What are the various types of anchors in Reports ?

A There are two types of anchors in Oracle Reports:
* implicit (anchors that Oracle Reports creates when a report is run)
* explicit (anchors you create)

4. What is an Implicit Anchor?

Implicit Anchors : At runtime, Oracle Reports generates an implicit anchor for each layout object that does not already have an explicit anchor. It determines for each layout object which objects, if any, can overwrite it, then creates an anchor from the layout object to the closest object that can overwrite it. This prevents the object from being overwritten. The implicit anchor functionality saves you from having to define the positioning of each object. Implicit anchors are not visible in the Layout editor. However, you can specify that the Object Navigator display anchoring information using the Object Navigator Options dialog.

5. What is an Explicit Anchor?

Explicit Anchors : Create an anchor in the Layout editor by clicking on the Anchor tool, dragging from one edge of the child to the one of the parent's edges, then specifying the anchor's properties in its property sheet. Any anchor you create for an object will override its implicit anchoring. Explicit anchors are always visible in the Layout editor unless you specify otherwise via the Layout Options dialog
6. What are the various report triggers ? What is their order of firing ?

A There are eight report triggers. Of these there are five global triggers called the Report Triggers. They are fired in the following order :
* Before Parameter Form
* After Parameter Form
* Before Report
* Between Pages
* After Report

7. Apart from the global report triggers what are the other triggers used in Oracle Reports?

Apart from the Five Global Report Triggers, there are three other types of triggers :

* Validation Triggers
* Format Triggers
* Action Triggers

8. What is Before Form Trigger? What is the importance of Before Form Trigger?

Before Form : It Fires before the Runtime Parameter Form is displayed. Using this trigger, you can access and change the values of parameters, PL/SQL global variables, and report-level columns. (Note : If the Runtime Parameter Form is suppressed, this trigger still fires. Consequently, you can use this trigger for validation of command line parameters).

9. What is After Form Trigger? What is the importance of After Form Trigger?

After Form : It Fires after the Runtime Parameter Form is displayed. Using this trigger, you can access parameters and check their values. This trigger can also be used to change parameter values or, if an error occurs, return to the Runtime Parameter Form. Columns from the data model are not accessible from this trigger. (Note : If the Runtime Parameter Form is suppressed, the After Form trigger still fires. Consequently, you can use this trigger for validation of command line parameters or other data).

10. What is Before Report Trigger? What is the importance of Before Report Trigger?

Before Report : Fires before the report is executed but after queries are parsed and data is fetched.

11. What is Between Pages Trigger? What is the importance of Between Pages Trigger?

Between Pages : Fires before each page of the report is formatted, except the very first page. This trigger can be used for customized page formatting. (Note : In the Previewer, this trigger only fires the first time that you go to a page. If you subsequently return to the page, the trigger does not fire again.)
12. What is After Report Trigger? What is the importance of After Report Trigger?

After Report : Fires after you exit the Previewer, or after report output is sent to a specified destination, such as a file, a printer, or an Oracle*Mail userid. This trigger can be used to clean up any initial processing that was done, such as deleting tables. Note, however, that this trigger always fires, whether or not your report completed successfully.

13. What is Validation Trigger? What is the importance of Validation  Trigger?

Validation Triggers : Validation Triggers are PL/SQL functions that are executed when parameter values are specified on the command line and when you accept the Runtime Parameter Form. (Notice that this means each Validation Trigger may fire twice when you execute the report). Validation Triggers are also used to validate the Initial Value of the parameter in the Parameter property sheet.

14. What is Format Trigger? What is the importance of Format Trigger?

Format Triggers : Format Triggers are PL/SQL functions executed before the object is formatted. The trigger can be used to dynamically change the formatting attributes of the object.

15. What is Action Trigger? What is the importance of Action Trigger?

Action Triggers : Action Triggers are PL/SQL procedures executed when a button is selected in the Previewer. The trigger can be used to dynamically call another report (drill down) or execute any other PL/SQL.

Some More Articles Related To Oracle Reports:

1. How To Register An Oracle Report In Oracle Applications
2. Oracle Reports Interview Questions & Answers Part -3
3. Oracle Reports Interview Questions & Answers Part-1
4. Oracle Reports Interview Questions & Answers Part-4
5. Oracle Reports Interview Questions & Answers Part-5
6. Oracle Reports Interview Questions & Answers Part-6
7. User Exits in Oracle Reports | Oracle Reports Tutorials
8. Difference Between Bind & Lexical Parameters in Reports