Reports  Questions And Answers
 

Oracle Questions And Answer Page 1

SQL*PLUS QUESTIONS

ORACLE  FORMS TEST PAPER 

ORACLE QUESTIONS And ANSWERs Page 1

Oracle Questions And Answer Page 2

Oracle Questions And Answer Page 3

Reports  Questions And Answers

Oracle Assignments

Oracle Faqs



Reports 2.5 Questions & Answers

What are the different styles of Reports ?

Tabular, Form. Form Letter, Master/Detail, Matrix, Mail Label

Name the SYSTEM VARIABLESthat are available in Reports 2.5 ?

11 System Parameters.

a] Backround, b] Copies, c] Currency d] Decimal e] Desination Format, f] Destination Name

g] Destination type, h] Mode, i] Orientation, j] Print job and k] Thousands.

Name the Objects that are created Under the Data Model Node in Reports 2.5 ?

9 Objects come under Data Model Editor node.

System parameters, User Parameters, Queries, Groups, Database Columns, Formula Columns, Placeholder Columns, Summary Columns and Data Links.

Name the Objects that are created Under the Layout Editor Node in Reports 2.5 ?

4 Objects come under the Layout Editor node.

Header, Trailer, Body and Margin.

Name the Objects that are created Under the Parameter Form in Reports 2.5 ?

4 Objects come under the Parameter Form editor node in reports 2.5.

Fields, graphics Boiler Plate, text Boiler Plate and Image boiler Plate.

Name the Objects that are created Under the Reports trigger Node in Reports 2.5 ?

Before Parameter Form, After Parameter Form, Before Repor Trigger, Between Pages and After Report Trigger.

How many groups are required for a MATRIX REPORT ?

4 Groups.

What are the steps in creating a PAGEWISE SUMMMARY COLUMN ?

Explain DEFAULT LAYOUT & LAYOUT EDITOR ?

What is an EXTERNAL QUERY ?

An External query is an Oracle Report Module that is an ANSI - standard SQL SELECT statement that can be used in more than one report or Oracle Product.

Through which object you are establishing LINKS BETWEEN GROUPS ?

Data Link Object - It establishes a relationship between the data of two queries.

What is a a] FORMULA COLUMN, b] PLACEHOLDER COLUMN , c] SUMMARY COLUMN?

a] A formula is a computation performed on a single record spanning one or more columns.

b] A Place holder is a “dummy” column for which you can set the Data type & value via PL/SQL or a

user exit. They are useful when you want to selectivelypopulate a column wih a value.

c] A summary is a computation that is performed on all records of a single column.

What is an ANCHOR ?

Anchors determine the relative position of objects in the report output by attaching one layout object, called the child, to a second called the parent.

What is a PARAMETER ? Different types of parameter ? Trigger associated wih the Parameter ?

Parameters are Report variables to which users can assign values at runtime.

a] Bind Parameter [ : ], b] Lexical Parameter [ & ].

1] Before Parameter form

2] After Parameter form

Can we use DDL statements in Reports ? If so how ?

Yes. Using SRW.DO_SQL Package.

What is a DRILLDOWN Report ?

What is the trigger associated with PUSH BUTTON ?

Action Trigger.

What are the different types of REPORT TRIGGERS ? List out the sequence in which they fire ?

BEFORE PARAMETER FORM

AFTER PARAMETER FORM

BEFORE REPORT TRIGGER

BETWEEN PAGES

AFTER REPORT TRIGGER

Can I use DML statements in FORMAT trigger ?

What is the significance of GROUP FILTER trigger ?

With this we can restrict the Rows retrieved from the Database when the query is executed.

How to control the no of records retrieved ?

Using the FILTER OPTION.

Can we refer to column values in REPORT triggers ?

Yes - Check.

In the table I am having a value for ENAME as ‘ALLEN’ But I want it to be printed as ‘XXX’ in the previewer screen, printer. Is it possible ? If so how ?

I want 3 records to be displayed for each page What should I do ?

For achieving this you have to set the RECORDS DISPLAYED PRE PAGE property to 3.

How to integrate REPORTS 2.5 wih FORMS 4.5 ? How to pass parameters from FORMSto REPORTS ?

Using RUN_PRODUCT.

With the help of RECORD GROUPS.