Oracle Reports Interview Questions and Answers

What is Place holder Columns?
A placeholder is a column is an empty container at design time. The placeholder can hold a value at run time has been calculated and placed in to It by pl/sql code from anther object. You can set the value of a placeholder column is in a Before Report trigger , A report level formula column(if the place holder column is at report level) A formula column in the place holder group or a group below it. Uses of place holder columns enables u to populate multiple columns from one piece of code. U can calculate several values in one block of pl/sql code in a formula column and assign each value into a different placeholder column. U therefore create and maintain only program unit instead of many. Store a Temporary value for future reference.
What is Formula Column?
A formula column performs a user-defined computation on another column(s) data, including placeholder columns.
What is Summary columns?
A summary column performs a computation on another column's data. Using the Report Wizard or Data Wizard, you can create the following summaries: sum, average, count, minimum, maximum, % total. You can also create a summary column manually in the Data Model view, and use the Property Palette to create the following additional summaries: first, last, standard deviation, variance.
What is Boilerplate?

Boilerplate is any text or graphics that appear in a report every time it is run. Report Builder will create one boilerplate object for each label selected in the Report Wizard (it is named B_Column name). Also, one boilerplate object is sometimes created for each report summary. A boilerplate object is owned by the object surrounding it, unless otherwise noted.

What is Data Link?
When we join multiple quires in a report the join condition is stored in the data link section.Data links relate the results of multiple queries. A data link (or parent-child relationship) causes the child query to be executed once for each instance of its parent group. When you create a data link in the Data Model view of your report, Report Builder constructs a clause (as specified in the link's Property Palette) that will be added to the child query's SELECT statement at runtime. You can view the SELECT statements for the individual parent and child queries in the Builder, but can not view the SELECT statement that includes the clause created by the data link you define.
What is Query Builder?

it's a gui tool to build a query in Report Wizard, Data Wizard or Data model.

What is Break Column?
We can break a column through data model , it Display once for a group
How do u call Report from form?
RUN_PRODUCT and RUN_REPORT_OBJECT
What is the Firing sequence of report trigger?
The reports triggers are fired in the following sequence. Before Parameter Form After Parameter Form Before Report Between Pages After Report
What happens when Flex mode is on?
When flex mode is on, reports automatically resizes the parent when the child is resized.
What happens when confine mode on?
When confine mode is on, the object cannot be moved outside its parent in the layout.
What is the minimum number of groups required for a matrix report?
The minimum of groups required for a matrix report are 4
What is the use of an Anchor in Reports?
Anchor is used to make fixed distance between two objects in Reports Layout.
What is the difference between Frame and Repeating Frame?
Frames are used to surround other objects and protect them from being overwritten or pushed by other objects. For example a frame might be used to surround all objects owned by a group to surround column headings or to surround summaries. Repeating frames surround all of the fields that are created for a group’s columns. The repeating frame prints (is fired) once for each record of the group.
What are different types of column in reports?

There are three types of columns in Oracle report: 
1) Placeholder Column: Placeholder column is used to store a value for a variable.
2) Formula Column: Used For doing mathematical calculations and returning one value
3) Summary Column: The summary columns perform aggregate functions such as SUM, COUNT, MAX, MIN, AVG, and the like.

What are the various page layout sections in Oracle Reports ?

A report has three sections : 

report header pages, 
report body/margin pages, 
report trailer pages.

Latest Updates