Interview Questions.

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

When we set lock alternative we can't circulate the fields inside the layout editor outdoor the frame. This may be very useful for retaining the fields.

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

There are five reports cause with order:

Before Parameter Form

After Parameter Form

Before Report

Between Pages

After Report

Before Form Trigger: It wills Fires before the Run time Parameter Form so as to displayed on display screen. By using this cause you could trade the price of the parameters.

After Form Trigger: Fires after the Run time Parameter Form is displayed. From this cause, you may get entry to parameters and take a look at their values. This cause can also be used to trade parameter values or, if an errors takes place, go back to the Runtime Parameter Form.

Before Report Trigger: It will Fires earlier than the report is performed however after queries are parsed and statistics is fetched.

Between Pages Trigger: Fires earlier than each web page of the record are formatted, except the first actual page. This cause may be used for customized page formatting. (Note: In the Previewer, this trigger handiest fires the primary time that you visit a page. If you sooner or later return to the page, the trigger does no longer fire again.)

After Report Trigger: Fires once you go out the Previewer, or after document output is sent to a particular vacation spot, together with a file, a printer, or an Oracle*Mail userid. This trigger may be used to easy up any initial processing that become carried out, along with deleting tables. Note, but, that this cause continually fires, whether or not or not your document completed efficiently.

Format Triggers: Format Triggers are PL/SQL functions executed before the item 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:

System Parameters

User defined (bind and lexical) parameters

Q5. What Are Placeholder Columns?

A placeholder is a logical column for which you could conditionally set the datatype and cost through PL/SQL or a person exit. Placeholder columns are beneficial whilst you want to selectively populate a column with a price.

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

A report has 3 important sections:

Report header pages

Report body/margin pages

Report trailer pages

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

A There are  varieties of anchors in Oracle Reports:

Implicit (Created when a file will run)

Explicit (Anchors you create)

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

You can set the most information per web page belongings of the Repeating body to.

Q9. What Are Anchors In Reports Builder?

An anchor defines the actual role of an item. Anchors are used to determine the vertical and horizontal positioning of a toddler object relative to its determine.

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

Four corporations are required for a matrix reports.

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

Bind parameters are used to replace a single price in SQL or PL/SQL, which includes a character string, quantity, or date.

Lexical parameters are placeholders for text which you embed in a SELECT assertion. Use Lexical reference when you want the parameter to alternative a couple of values at runtime. You can use lexical references to update 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 three types of columns in the reviews builder:

Placeholder Column

Formula Column

Summary Column

Q13. Define Different Types Of Matrix Report?

Single query

Multi question

Nested Query

Matrix Break