Oracle Reports Interview Questions and Answers

How many Types of Reports available in Reports?

There are eight different layout formats:
1. Tabular
2. Form Like
3. Form Letter
4. Mailing Label
5. Group Left
6. Group Above
7. Matrix
8. Matrix with group

What Types of Triggers are Available in Report?

Report Level Triggers:

1) Before report trigger:
Fires before the report is executed but after queries are parsed and data is fetched.
2) 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.
3) Before Parameter trigger:
Fires before the Runtime Parameter Form is displayed. Using this trigger, you can access and change the values of parameters, PL/SQL global variables, and report-level columns. 
4) After parameter trigger:
Fires after the Runtime Parameter Form is displayed. Using this trigger, you can access parameters and check their values. This trigger can also be used to change parameter values.
5) Between pages trigger:
Fires before each page of the report is formatted, except the very first page. This trigger can be used for customized page formatting.

Layout Model Triggers:
1) Format triggers

What are Format triggers?

Format triggers enable you to modify the display of objects dynamically at run time or to suppress display altogether For Headings, for repeating frames, for field, for boilerplate object To format a column based on certain criteria. 

for example
To format the max (Sal) for particular department.
To format the Sal column with a Dollar ($) prefix.

What is Data Model?
Data Model is logically group of the Report Objects through query and Data model tools. Once query is compiled report automatically generates group. The queries build the groups and then Groups are used to populate the report. The only function of queries in report is to create the groups. The Report Editor's Data Model view enables you to define and modify the data model objects for a report.

What is Layout model?
Layout Model is to physically arrange Data model group objects on the Report. The Report Editor's Layout Model view enables you to define and modify the layout model objects for a report. In this view, objects and their property settings are represented symbolically to highlight their types and relationships.
What is Previewer?
Previewer is a work area in which you can preview your report and manipulate the actual or live data at the same time. In the Previewer you can customize reports interactively, meaning that you can see the results immediately as you make each change. In order to edit your report, such as changing column size, move columns, align columns insert page numbers, edit text, change colors, change fonts set format masks, insert field the Previewer must be in Flex Mode.
What is Parameter Form?
Parameters are variables for report that users can change at runtime immediately prior to the execution of the report. You can use system parameters to specify aspects of report execution, such as the output format, printer name, mailed or number of copies. We can also create own parameters through sql or Pl/sql at runtime. When you run a report, Report Builder uses the Parameter Form view as a template for the Runtime Parameter Form. If you do not define a Runtime Parameter Form in the Parameter Form view, Report Builder displays a default Parameter Form for you at runtime.

What is Query?
The first thing in data model is the query. Through query we access database objects with sql query. Compiled query creates groups. We can create query through query builder, sql query and import query from o/s file or database.
What is Group?
Groups are created to organize the columns in your report. When you create a query, Report Builder automatically creates a group that contains the columns selected by the query. You create additional groups to produce break levels in the report, either manually or by using the Report Wizard to create a group above or group left report.
What is Repeating Frame?
Repeating frames surround all of the fields that are created for a group’s columns. Repeating frames correspond to groups in the data model. Each repeating frame must to be associated with a group of data model the repeating frame prints (is fired) once for each record of the group.
What is Flex mode and Confine mode?

Confine mode 
On: child objects cannot be moved outside their enclosing parent objects. 
Off: child objects can be moved outside their enclosing parent objects. 

Flex mode
On: parent borders stretch when child objects are moved against them. 
Off: parent borders remain fixed when child objects are moved against them.

What is Page Break?
To limit the records per page.

Latest Updates

Height and Distance

An aeroplane flying at a height of 300 m above the ground passes vertically above another plane at an instant when the angles of elevation of the two planes from the same point on the ground are 60º and 45º respectively. What is the height of the lower plane from the ground?

From the top of a building 90 m high, the angles of depression of the top and the bottom of a tree are 30º and 45º respectively. What is the height of the tree?

Trigonometry

What is the value of sinx √( 1 /1+cosx + 1 /1-cosx ) ?

What is cos4 A - sin4 A / cos2 A - sin2 A equal to?

If 7sin2 x +3cos2 x = 4, 0 < x < 90º ,then what is the value of tan x?

If x = a cosθ + b sinθ and y = a sinθ - b cosθ then what is x2 + y2 equal to?

Average

The mean of 5 numbers is 15. If one more number is included, the mean of the 6 numbers becomes 17. What is the included number?

The mean marks obtained by 300 students in a subject are 60. The mean of top 100 students was found to be 80 and the mean of last 100 students was found to be 50. The mean marks of the remaining 100 students are?

In an asymmetrical distribution, of the mean and median of the distribution are 270 and 220 respectively, then the mode of the data is?

Let a, b, c, d, e, f, g be consecutive even numbers and j, k, l, m, n be consecutive odd numbers. What is the average of all the numbers?

Alligation or Mixture

25 kg of alloy X is mixed with 125 kg of alloy Y. If the amount of lead and tin in the alloy X is the ratio 1 : 2 and the amount of lead and tin in the alloy Y is in the ratio 2 : 3, then what is the ratio of lead to tin in the mixture?

Simplification

The ratio of two numbers is 1 : 5 and their product is 320. What is the difference between the square of these two numbers?

Trigonometry

What is the value of cot 4π/3 ?

Indian Politics

Article-24 of the Indian Constitution ‘Prohibition of employment of children in factories, etc’ deals with?

Article-134A of the Indian Constitution ‘Certificate for appeal to the Supreme Court’ deals with?

Chemistry

Who invented Aspirin?

Physics

A larger force on a rotating body results in larger?

What is the unit of the physical quantity, magnetic flux density?