Oracle Reports Interview Questions and Answers

What is SRW Package?
The Report builder Built in package know as SRW Package (Sql Report Writer) This package extends reports, Control report execution, output message at runtime, Initialize layout fields, Perform DDL statements used to create or Drop temporary table, Call User Exit, to format width of the columns, to page break the column, to set the colors Ex: SRW.DO_SQL, It’s like DDL command, we can create table, views, etc.
What is User Parameters?
Parameter, which is created by user. For to restrict values with where clause in select statement. We can use Lovs in user parameter with static and Dynamic Select Statement.
What is System Parameters?

These are built-in parameters provided by Oracle corporation.
BACKGROUND: Is whether the report should run in the foreground or the background.

COPIES Is the number of report copies that should be made when the report is printed.

DESFORMAT Is the definition of the output devices format (e.g., landscape mode for a printer). This parameter is used when running a report in a character-mode environment, and when sending a bitmap report to a file (e.g. to create PDF or HTML output).

DESNAME Is the name of the output device (e.g., the file name, printers name, mail userid).

DESTYPE Is the type of device to which to send the report output (screen, file, mail, printer, or Screen using PostScript format).

MODE Is whether the report should run in character mode or bitmap.

ORIENTATION Is the print direction for the report (landscape, portrait,default).

PRINTJOB Is whether the Print Job dialog box should appear before the report is run

What are the different types of anchors in Reports?
A There are two types of anchors in Oracle Reports: Implicit (Creates when a report will run) Explicit (Anchors you create)
What is the difference between Bind and Lexical parameter?

1-Bind parameters are used to replace a single value in SQL or PL/SQL, such as a character string, number, or date.
2-Lexical parameters are placeholders for text that you embed in a SELECT statement. Use Lexical reference when you want the parameter to substitute multiple values at runtime. You can use lexical references to replace the clauses appearing after SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH.

How can you print one record per page in the output?
You can set the maximum records per page property of the Repeating frame to

Latest Updates


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?


Who invented Aspirin?


A larger force on a rotating body results in larger?

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


The system of equations 2x + 4y = 6 and 4x + 8y = 8 is ?

Time and Distance

A thief is spotted by a policeman from a distacne of 100 m. When the policeman starts the chase, the thief also starts running. If the speed of the theif is 8 km / hour and that of the policeman is 10 km/hour, then how far will the theif have to run before he is overtaken?


Aman and Alok attempted to solve a quadratic equation. Aman made a mistake in writing down the constant term and ended up in roots (4, 3). Alok made a mistake in writing down the coefficient of x to get roots (3, 2). The correct roots of the equation are?

Compound Interest

The effective annual rate of interest corresponding to a nominal rate of 22% per annum payable half-yearly is?

Volume and Surface Area

If the volume of a cylinder is 2156 cubic cm and height is 14 cm, find its radius?


What is the equation of the line which passes through the points (2, 3) and (- 4, 1)?


In △ABC, the angle bisector of ∠A cuts BC at E. Find length of AC, if lengths of AB, BE and EC are 9 cm, 3.6 cm and 2.4 cm?

In a triangle, the length of the opposite side of the angle which measures 45° is 8√2 cm, what is the length of the side opposite to the angle which measures 90°?

General Knowledge of India

The boundary line between India and Pakistan is called?

Which city is located on the banks of the river Mahanadi?

Indian History

When was the battle of Haldighati fought?

In 1498, which Portuguese explorer discovered a new sea route from Europe to India?

General Knowledge of India

Chapchar Kut is a festival of which State?


In chemistry, soap is a salt of a ?

Indian Economy

Which of the following is a Direct tax?


Sauria lacertidae is the scientific name of?

Which of the following is a primary function of haemoglobin?


A factory buys 8 machines.3 Machine A, 2 Machine B and rest Machine C. Prices of the machines are 100000, 80000 and 45000 respectively.Calculate the average cost of these machines?


Ticket for an adult is 500 and a child is 200. 1 child goes free with two adults. If a group has 20 adults and 8 children what will be the discount the group get?