|
|
|
|
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. |
