|
1.
|
What are the different file
extensions that are created by oracle reports?
|
|
Rep file and Rdf file.
|
|
2.
|
From which designation is it
preferred to send the output to the printed?
|
|
Previewer.
|
|
3.
|
Is it possible to disable the
parameter from while running the report?
|
|
Yes
|
|
4.
|
What is lexical reference?How
can it be created?
|
|
Lexical reference is
place_holder for text that can be embedded in a sql statements.A lexical
reference can be created using & before the column or parameter name.
|
|
5.
|
What is bind reference and how
can it carate?
|
|
Bind reference are used to
replace the single value in sql,pl/sql statements a bind reference can be
careated using a (:) before a column or a parameter name.
|
|
6.
|
What use of command line
parameter cmd file?
|
|
It is a command line argument
that allows you to specify a file that contain a set of arguments for
r20run.
|
|
7.
|
Where is a procedure return in
an external pl/sql library executed at the client or at the server?
|
|
At the client.
|
|
8.
|
Where is the external query
executed at the client or the server?
|
|
At the server.
|
|
9.
|
What are the default parameter
that appear at run time in the parameter screen?
|
|
Destype and Desname.
|
|
10.
|
Which parameter can be used to
set read level consistency across multiple queries?
|
|
Read only.
|
|
11.
|
What is term?
|
|
The term is terminal definition
file that describes the terminal form which you are using r20run.
|
|
12.
|
What is use of term?
|
|
The term file which key is
correspond to which oracle report functions.
|
|
13.
|
Is it possible to insert
comments into sql statements return in the data model editor?
|
|
Yes.
|
|
14.
|
If the maximum record retrieved
property of the query is set to 10 then a summary value will be calculated?
|
|
Only for 10 records.
|
|
15.
|
What are the sql clauses
supported in the link property sheet?
|
|
Where startwith having.
|
|
16.
|
To execute row from being
displayed that still use column in the row which property can be used?
|
|
Format trigger.
|
|
17.
|
Is it possible to set a filter
condition in a cross product group in matrix reports?
|
|
No.
|
|
18.
|
If a break order is set on a
column would it effect columns which are under the column?
|
|
No.
|
|
19.
|
With which function of summary
item is the compute at options required?
|
|
percentage of total functions.
|
|
20.
|
What is the purpose of the
product order option in the column property sheet?
|
|
To specify the order of
individual group evaluation in a cross products.
|
|
21.
|
Can a formula column be obtained
through a select statement?
|
|
Yes.
|
|
22.
|
Can a formula column refered to
columns in higher group?
|
|
Yes.
|
|
23.
|
How can a break order be created
on a column in an existing group?
|
|
By dragging the column outside
the group.
|
|
24.
|
What are the types of calculated
columns available?
|
|
Summary, Formula, Placeholder
column.
|
|
25.
|
What is the use of place holder
column?
|
|
A placeholder column is used to
hold a calculated values at a specified place rather than allowing is to
appear in the actual row where it has to appeared.
|
|
26.
|
What is the use of hidden
column?
|
|
A hidden column is used to when
a column has to embedded into boilerplate text.
|
|
27.
|
What is the use of break group?
|
|
A break group is used to display
one record for one group ones.While multiple related records in other group
can be displayed.
|
|
28..
|
If two groups are not linked in
the data model editor, what is the hierarchy between them?
|
|
Two group that is above are the
left most rank higher than the group that is to right or below it.
|
|
29.
|
The join defined by the default data
link is an outer join yes or no?
|
|
Yes.
|
|
30.
|
How can a text file be attached
to a report while creating in the report writer?
|
|
By using the link file property
in the layout boiler plate property sheet.
|
|
31.
|
Can a repeating frame be
careated without a data group as a base?
|
|
No.
|
|
32.
|
Can a field be used in a report
wihtout it appearing in any data group?
|
|
Yes.
|
|
33.
|
For a field in a repeating
frame, can the source come from the column which does not exist in the data
group which forms the base for the frame?
|
|
Yes.
|
|
34.
|
Is it possible to center an
object horizontally in a repeating frame that has a variable horizontal
size?
|
|
Yes.
|
|
35.
|
If yes,how?
|
|
By the use anchors.
|
|
36.
|
What are the two repeating frame
always associated with matrix object?
|
|
One down repeating frame below
one across repeating frame.
|
|
37.
|
Is it possible to split the
printpreviewer into more than one region?
|
|
Yes.
|
|
38.
|
Does a grouping done for objects
in the layout editor affect the grouping done in the datamodel editor?
|
|
No.
|
|
39.
|
How can a square be drawn in the
layout editor of the report writer?
|
|
By using the rectangle tool
while pressing the (Constraint) key.
|
|
40.
|
To display the page no. for each
page on a report what would be the source & logical page no. or &
of physical page no.?
|
|
& physical page no.
|
|
41.
|
What does the term panel refer
to with regard to pages?
|
|
A panel is the no. of physical
pages needed to print one logical page.
|
|
42.
|
What is an anchoring object
& what is its use?
|
|
An anchoring object is a print
condition object which used to explicitly or implicitly anchor other
objects to itself.
|
|
43.
|
What is a physical page? &
what is a logical page?
|
|
A physical page is a size of a
page. That is output by the printer. The logical page is the size of one
page of the actual report as seen in the Previewer.
|
|
44.
|
What is the frame &
repeating frame?
|
|
A frame is a holder for a group
of fields. A repeating frame is used to display a set of records when the
no. of records that are to displayed is not known before.
|
No comments:
Post a Comment