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

General Knowledge of India

‘Kanchipuram’ is in which of the following states?

General Knowledge of World

In which year was Pulitzer Prize established?

Indian History

The roads of cities in the Indus Valley Civilization generally divided the city into?

Which dynasty was ruling over North India when Alexander invaded India?

Who was the Spanish navigator who set out to discover India, but instead landed on the soil of America?

Who was the Viceroy of India, when Quit India Resolution was passed in 1942?

Order Sequence

There is a queue in a ticketing office. Amanda is 10​ th​ from the front while Murthy is 25​ th from behind and Marta is just in the middle of the two. If there be 50 persons in the queue. What position does Marta occupy from the front?

Direction

A man walks 5 Km towards south and then turns to the right. After walking 3 Km he turns to the left and walks 5 Km. Now in which direction is he from the starting place?

Series

Find the missing term: 60, 40, 55, 45, 50, 50,....?

Numbers

X is a whole number. If the only common factors of X and X2 are 1 and X, then X is _______?

Ratio and Proportion

An alloy contains copper and zinc in the ratio 5 : 3 and another contains copper and tin in the ratio 8 : 5, If equal weights of the two are melted together to form a 3​ rd​ alloy, find the weight of tin per kg in the new alloy?

Simplification

Aamir and Birju can cut 5000 g of wood in 20 min. Birju and Charles can cut 5000 g of wood in 40 min. Charles and Aamir can cut 5 kg of wood in 30 min. How much time Charles will take to cut 5 kg wood alone?

Compound Interest

The difference between the compound interest and the simple interest earned at the end of the third year on a sum of money at a rate of 10% per annum is Rs 77.5. What is the sum?

General Knowledge of MP

According to history, who established Gwalior?

General Knowledge of India

The headquarters of the Hindustan Aeronautics Limited is located at?

Indian Economy

The Reserve Bank of India was established in?

General Knowledge of MP

Who constructed the Chaturbhuj Temple of Orchha?

Highest peak in the Vindhya Range is the?

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 अंतिम तिथि