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?
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

Simple Interest

The rate of simple interest on a sum of money is 6 percent per annum for first 3 years, 8 percent per annum for the next 5 years and 10 percent per annum for period beyond 8 years. If simple interest accrued by the sum for a total period of 10 years is Rs 1560, What is the sum?


Shirin went to a bakery and bought items worth Rs 25, out of which 30 paise went on sales tax on taxable purchases. If the tax rate was 6%, then what was the cost of the tax free items?

Blood Relation

Pointing to a photograph, a man said, "I have no brother or sister but that man’s father is my father’s son." Whose photograph was it?

Introducing a man to her husband, a woman said "His brother's father is the only son of my grandfather". How is the woman related to the man ?

Apache Tomcat

What is the difference between Apache Tomcat server and Apache web server?


What is the full form of DOS?

Explain the use of help DOS Command?

How we can create a directory in DOS?






Pipes and Cistern

A tank can be filled by one tap in 10 minutes and by another in 30 minutes. Both the taps are kept open for 5 minutes and then the first one is shut off. In how many minutes more is the tank completely filled?


Assume that a sum of money is divided equally among n girls. Each girl will receive $60. If another girl is added to the group and the sum is divided equally among all the girls, each child girl gets a $50 share. What is the sum of money?

Problems on Trains

A 300 meter long metro train crosses a platform in a metro station in 39 seconds while it crosses a lamp post in 18 seconds. What is the length of the platform?

Problems on Ages

In a group of 7 people, the average age is found to be 17 years. Two more people joined with an average age 19 years. One person left the group whose age was 25 years. What is the new average age of the group?

Profit and Loss

Irvin sold a book at a profit of 12%. If Irvin had sold it for Rs 18 more, then 18% would have been gained. Find the cost price?


Non stick cooking utensils are coated with?

Latest Job Notifications

Jobs in West Bengal

इंडियन पोस्ट सर्विस Indian Post Service - 2357 पद - 19/08/2021 अंतिम तिथि - पश्चिम बंगाल पोस्टल सर्कल

Banking Jobs

भारतीय स्टेट बैंक State Bank of India(SBI) - 6100 पद - 26/07/2021 अंतिम तिथि - CRPD/APPR/2021-22/10

SSC Recruitment

कर्मचारी चयन आयोग Staff Selection Commission(SSC) - 25271 पद - 31/08/2021 अंतिम तिथि

Jobs in Madhya Pradesh

राष्ट्रीय स्वास्थ्य मिशन मध्य प्रदेश National Health Mission MP(NRHM) - 5215 पद - 22/06/2021 अंतिम तिथि

Jobs in Punjab

पंजाब स्टेट पावर कॉर्पोरेशन लिमिटेड Punjab State Power Corporation Limited (PSPCL) - 2632 पद - 20/06/2021 अंतिम तिथि

Jobs in Chhattisgarh

स्वास्थ्य सेवा निदेशालय, छत्तीसगढ़ Department of Health & Family Welfare, Chhattisgarh - 267 पद - 26/06/2021 अंतिम तिथि

Government Jobs

दिल्ली सबऑर्डिनेट सर्विस सिलेक्शन बोर्ड Delhi Subordinate Services Selection Board(DSSSB) - 5807 पद - 03/07/2021 अंतिम तिथि

Jobs in Madhya Pradesh

राष्ट्रीय स्वास्थ्य मिशन मध्य प्रदेश National Health Mission MP(NRHM) - 2850 पद - 31/05/2021 अंतिम तिथि

Government Jobs

इंडियन पोस्ट सर्विस Indian Post Service - 4368 पद - 29/05/2021 अंतिम तिथि

दिल्ली सबऑर्डिनेट सर्विस सिलेक्शन बोर्ड Delhi Subordinate Services Selection Board(DSSSB) - 7236 पद - 24/06/2021 अंतिम तिथि