Oracle Reports Interview Questions and Answers

What is Print Direction?
The Print Direction property is the direction in which successive instances of the repeating frame appear.
Post comment
Cancel
Thanks for your comment.!
Write a comment(Click here) ...
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.
What is Page Protector?
The Page Protect property indicates whether to try to keep the entire object and its contents on the same logical page. Setting Page Protect to Yes means that if the contents of the object cannot fit on the current logical page, the object and all of its contents will be moved to the next logical page. Ex: if you set yes, the object information prints another page.
What is the Print Condition?
The print condition type First, All, All but first, Last, All but last refer to the frequency with which you want to appear based upon the setting of the print condition object. A print condition object of Enclosing Object is whichever object encloses the current object (could be the parent or a frame within the parent), while Anchoring Object is the parent object (unless you have explicitly anchored the object in which case it is the object to which it is anchored).
What is Vertical and Horizental Elasticity?
The Horizontal Elasticity property is how the horizontal size of the object will change at runtime to accommodate the objects or data within it, same for vertical elasticity to vertical direction.
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.

Latest Updates

Fractions

First we increased the denominator of a positive fraction by 3 and then decrease it by 5.The sum of the resulting fractions proves to be equal to 2/3. Find the denominator of the fraction if its numerator is 2?

Simplification

If we divide a two digit number by the sum of its digits we get 4 as a quotient and 3 as a remainder. Now if we divide that two digit number by the product of its digits we get 3 as a quotient and 5 as a remainder . Find the two digit number?

Fractions

The denominators of an irreducible fraction is greater than the numerator by 2.If we reduce the numerator of the reciprocal fraction by 3 and subtract the given fraction from the resulting one,we get 1/15.Find the given fraction?

Simplification

If we add the square of the digit in the tens place of the positive two digit number to the product of the digits of that number we get 52,and if we add the square of the digit in the unit's place to the same product of the digits we get 117.Find the two digit number?

The sum of squares of the digits constituting a positive two digit number is 13, If we subtract 9 from that number we shall get a number written by the same digits in the reverse order. Find the number?

The arithmetic mean of two numbers is smaller by 24 than the larger of the two numbers and the GM of the same numbers exceeds by 12 the smaller of the numbers. Find the numbers?

A number being successively divided by 3,5,8 leaves remainder 1,4,7 respectively. Find the respective remainders if the order of divisors are reversed?

The sum of all possible two digit numbers formed from three different one digit natural numbers when divided by the sum of the original three numbers is equal to?

HCF and LCM

Find the HCF and LCM of the polynomial x2-5x+6 and x2-7x+10?

Simplification

When we multiply a certain two digit number by the sum of its digits , 405 is achieved. If we multiply the number written in reverse order of the same digits by the sum of the digits, we get 486. Find the number?

Average

The sum of two numbers is 15 and their geometric mean is 20% lower than their arithmetic mean. Find the numbers?

Numbers

The difference of 1025-7 and 1024+x is divisible by 3. find x=?

A number when divided by the sum of 555 and 445 gives two times their difference as quotient and 30 as remainder . The number is?

The sum of three prime numbers is 100.If one of them exceeds another by 36 then one of the numbers is?

Find the number of zeros in the factorial of the number 18?

If a number is multiplied by 22 and the same number is added to it then we get a number that is half the square of that number. Find the number?

In doing a division of a question with zero remainder,a candidate took 12 as divisor instead of 21.The quotient obtained by him was 35. The correct quotient is?

Fractions

A number when divided by 342 gives a remainder 47.When the same number is divided by 19 what would be the remainder?

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