Top 13 Oracle Reports Builder Interview Questions You Must Prepare 23.Jul.2024

Q1. What Is The Lock Option In Reports Layout In Oracle Reports Builder?

When we set lock option we cannot move the fields in the layout editor outside the frame. This is very useful for maintaining the fields.

Q2. What Are Different Types Of Report Triggers Also Define Their Order Of Firing?

There are five reports trigger with order:

  1. Before Parameter Form
  2. After Parameter Form
  3. Before Report
  4. Between Pages
  5. After Report

Before Form Trigger: It wills Fires before the Run time Parameter Form that will displayed on screen. By using this trigger you can change the value of the parameters.
After Form Trigger: Fires after the Run time Parameter Form is displayed. From 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.
Before Report Trigger: It will Fires before the report is executed but after queries are parsed and data is fetched.
Between Pages Trigger: Fires before each page of the report are 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.)
After Report Trigger: 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.

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.

Q3. What Are The Different Types Of Reports?

  • Tabular
  • Master Detail Reports
  • Form Reports
  • From Letter Reports
  • Mailing Labels Reports
  • Matrix Reports

Q4. What Are Different Types Of Parameters?

There are two types of parameters:

  1. System Parameters
  2. User defined (bind and lexical) parameters

Q5. What Are Placeholder Columns?

A placeholder is a logical column for which you can conditionally set the datatype and value via PL/SQL or a user exit. Placeholder columns are useful when you want to selectively populate a column with a value.

Q6. What Are The Different Page Layout Sections In Oracle Reports?

A report has three main sections:

  1. Report header pages
  2. Report body/margin pages
  3. Report trailer pages

Q7. What Are The Different Types Of Anchors In Reports?

A There are two types of anchors in Oracle Reports:

  • Implicit (Created when a report will run)
  • Explicit (Anchors you create)

Q8. How Can You Print One Record Per Page In The Output?

You can set the maximum records per page property of the Repeating frame to.

Q9. What Are Anchors In Reports Builder?

An anchor defines the actual position of an object. Anchors are used to determine the vertical and horizontal positioning of a child object relative to its parent.

Q10. What Is The Minimum Number Of Groups That Is Required In Matrix Report?

Four groups are required for a matrix reports.

Q11. What Is The Difference Between Bind And Lexical Parameter?

  1. Bind parameters are used to replace a single value in SQL or PL/SQL, such as a character string, number, or date.
  2. Lexical parameters are placeholders for text that you embed in a SELECT statement. Use Lexical reference when you want the parameter to substitute multiple values at runtime. You can use lexical references to replace the clauses appearing after SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH.

Q12. What Are Different Types Of Column In Reports?

There are 3 types of columns in the reports builder:

  1. Placeholder Column
  2. Formula Column
  3. Summary Column

Q13. Define Different Types Of Matrix Report?

  1. Single query
  2. Multi query
  3. Nested Query
  4. Matrix Break