Oracle Reports Interview Questions and Answers

What are various types of parameters ?

There are two types of parameters:

• default (system parameters)
• user-created (bind and lexical parameters)

Apart from the global report triggers what are the other triggers used in Oracle Reports?

Other types of triggers :
Validation Triggers-
Validation Triggers are PL/SQL functions that are executed when parameter values are specified on the command line and when you accept the Runtime Parameter Form.

Format Triggers-
Format Triggers are PL/SQL functions executed before the object is formatted. The trigger can be used to dynamically change the formatting attributes of the object.

How do you display a message in reports?
Using SRW.Message
Name some of the procedures in the SRW package ?
SRW.Message, SRW.User_Exit, SRW.Do_Sql, SRW.Run_Report
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

Indian Geography

What is the approximate distance between earth and the moon?

Indian History

In which year was the battle of ‘Koregaon Bhima’ fought?

The approach that is very useful in organizing the content in history is.

General Knowledge of India

NITI Aayog stands for _____.

General Knowledge of MP

India’s first Ramayan art museum was established at?

Errors Identification

Read the sentence carefully and choose the option that has an error in it:
The management’s trusted employee was suspected of stealing large sum of money.

Read the sentence carefully and choose the option that has an error in it:
The teacher asked the child to repeat again because he spoke feebly.

Fill in the blank

Fill in the blank with the most appropriate preposition in the given sentence.
Let’s sit _________ the shade of this beautiful tree.

Choose the most appropriate determiner for the given sentence.
________of what he said was very sensible.

Substitution

Choose the option that substitutes the given phrase appropriately.
A work of art made by carving

Correct sentence

Choose the option that best transforms the sentence into its Indirect form:
‘What country do you come from?’ said the police officer.

Alternative Phrase

Choose the option that best explains the highlighted expression:
All human beings have feet of clay.

Fill in the blank

Choose an appropriate modal for the given sentence:
My doctor said that I_____ stop smoking as one of my lungs got infected.

Choose the appropriate prepositions for the given sentence:
My parents have been married ________ forty-nine years, but you can still see the love ________ their eyes.

Choose the appropriate conjunction for the given sentence:
______ it rains, the college will declare the holiday.

Antonyms

Choose the appropriate antonym for the highlighted word in the given sentence.
The family protracted their visit by several days.

Tenses

Choose the appropriate tenses to fill in the blanks in the given sentence:
Please _________ a noise. Ritu __________ to sleep.

Synonyms

Choose the appropriate synonym for the highlighted word in the given sentence.
Does he really expect us to believe such a flimsy excuse?

Latest Job Notifications

Jobs in Bihar

बिहार तकनीकी सेवा आयोग / Bihar Technical Service Commission (BTSC) - 12771 पद - 01/09/2022 अंतिम तिथि

Jobs in Rajasthan

राजस्थान उच्च न्यायालय / Rajasthan High Court - 2756 पद - 22/09/2022 अंतिम तिथि

Jobs in Uttar Pradesh

उत्तर प्रदेश पावर कॉर्पोरेशन लिमिटेड / Uttar Pradesh Power Corporation Limited - 1033 पद - 12/09/2022 अंतिम तिथि

Jobs in Tamil Nadu

तमिलनाडु चिकित्सा सेवा भर्ती बोर्ड / Tamil Nadu Medical Services Recruitment Board (MRB) - 889 पद - 30/08/2022 अंतिम तिथि

Jobs in Andhra Pradesh

आंध्र प्रदेश स्वास्थ्य, चिकित्सा और परिवार कल्याण विभाग / Andhra Pradesh Health, Medical and Family Welfare Department - 1681 पद - 22/08/2022 अंतिम तिथि

SSC Recruitment

कर्मचारी चयन आयोग (एसएससी) Staff Selection Commission (SSC) - 4300 पद - 30/08/2022 अंतिम तिथि - CPO Recruitment

Banking Jobs

बैंकिंग कार्मिक चयन संस्थान Institute of Banking Personnel Selection(IBPS) - 6432 पद - 22/08/2022 अंतिम तिथि

बैंकिंग कार्मिक चयन संस्थान Institute of Banking Personnel Selection(IBPS) - 7855 पद - 29/07/2022 अंतिम तिथि

SSC Recruitment

कर्मचारी चयन आयोग (एसएससी) Staff Selection Commission (SSC) - 1411 पद - 29/07/2022 अंतिम तिथि

Jobs in Rajasthan

राजस्थान अधीनस्थ और मंत्रिस्तरीय सेवा चयन बोर्ड Rajasthan Subordinate and Ministerial Services Selection Board (RSMSSB) - 5546 पद - 22-Jul-2022 अंतिम तिथि