Oracle Reports Interview questions with answer
1. What are the various report layout regions in oracle reports ?
There are three report regions in the Layout editor :
* header
* body/margin
* trailer
Header : The report header pages appear once at the beginning of each report on a set of separate pages.
They can contain text, graphics, data, and computations.
Body/Margin : The body/margin pages appear between the header and trailer pages, and are the bulk of the report.
Each physical page in this section consists of a body
and a margin. The body contains the majority of the report's text, graphics, data, and computations.
A top and bottom margin appear on each page, until all data within the body has been formatted.
A margin may include text, graphics, page numbers, page totals, and
grand totals. The default margin size is one half inch each for the top and bottom margins and zero for the left and right margins.
Trailer : The report trailer pages appear once at the end of each report on a set of separate pages.
They can contain text, graphics, data, and computations.
2. In Oracle Reports, how can you print one record per page in the output ?
Set the Maximum records per page property of the Repeating frame to 1.
3. How do you print a Report 2.5 report in character mode in oracle reports ?
Set MODE = 'Character' in the Parameter form
4. What are widow lines in oracle reports?
Widow lines are the minimum number of lines of the boilerplate text or field that
should appear on the logical page where the text starts to print. If the number of
lines specified for this property cannot fit on the logical page, then all lines of
the boilerplate are moved to the next page.
5. What are widow records in oracle reports?
Widow records are the minimum number of instances (records) that should appear on the
logical page where the repeating frame starts to print. If the number of
instances specified for this property cannot fit on the logical page where the
repeating frame is initially triggered to print, then the repeating frame will start
formatting on the next page.
6. What is 'page protect' property for objects in oracle reports?
Page protect property for an object indicates whether to try to keep the entire object
and its contents on the same logical page. Checking Page Protect 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.
7. What is the 'Print Condition Type' property in oracle reports?
'Print Condition Type' property specifies the frequency with which you want the object to appear in the report.
The Print Condition Type options indicate the logical page(s) on which the object should be triggered
to print with regard to the Print Condition Object.
8. What is the horizontal of vertical sizing property of objects in oracle reports?
Horizontal of vertical sizing property specifies how the horizontal or vertical size of the object may
change at runtime to accommodate the objects or data within it.
9. Name some of the procedures in the SRW package in oracle reports?
SRW.Message
SRW.User_Exit
SRW.Do_Sql
SRW.Run_Report
10. What is 'Page Break Before' object property in oracle reports?
'Page Break Before' object property indicates that you want the object to be formatted on the page
after the page on which it is initially triggered to print. Note that this does not necessarily mean
that all the objects below the object with Page Break Before will move to the next page.
11. What is 'Page Break After' object property in oracle reports?
'Page Break After' object property indicates that you want all children of the object to be moved to the next page.
In other words, any object that is a child object of an anchor (implicit or explicit) to this object will be treated
as if it has Page Break Before set. Note that this does not necessarily mean that all the objects below the object
with Page Break After will move to the next page.
12. How can a group in a cross products be visually distinguished from a group that does not form a cross product?
A group that forms part of a cross product will have a thicker border.
13. Atleast how many set of data must a data model have before a data model can be base on it?
Four.
14. Is it possible to have a link from a group that is inside a cross product to a group outside ? (Y/N)
No.
15. Is it possible to link two groups inside a cross products after the cross products group has been created?
No.
16. What is an user_exit used for?
A way in which to pass control (and possibly arguments ) form Oracle report to another Oracle products of 3 GL
and then return control ( and ) back to Oracle reprots.
17. What are the three types of user exits available ?
Oracle Precompiler exits, Oracle call interface,NonOracle user exits.
18. How can values be passed bet. precompiler exits & Oracle call interface?
By using the statement EXECIAFGET & EXECIAFPUT.
19. what are the parameters are available in oracle reports?
Two parameters in oracle reports
1. System parameter
2. User Parameter
20. How can a cross product be created?
By selecting the cross products tool and drawing a new group surrounding the base group of the cross products.
1. What are the various report layout regions in oracle reports ?
There are three report regions in the Layout editor :
* header
* body/margin
* trailer
Header : The report header pages appear once at the beginning of each report on a set of separate pages.
They can contain text, graphics, data, and computations.
Body/Margin : The body/margin pages appear between the header and trailer pages, and are the bulk of the report.
Each physical page in this section consists of a body
and a margin. The body contains the majority of the report's text, graphics, data, and computations.
A top and bottom margin appear on each page, until all data within the body has been formatted.
A margin may include text, graphics, page numbers, page totals, and
grand totals. The default margin size is one half inch each for the top and bottom margins and zero for the left and right margins.
Trailer : The report trailer pages appear once at the end of each report on a set of separate pages.
They can contain text, graphics, data, and computations.
2. In Oracle Reports, how can you print one record per page in the output ?
Set the Maximum records per page property of the Repeating frame to 1.
3. How do you print a Report 2.5 report in character mode in oracle reports ?
Set MODE = 'Character' in the Parameter form
4. What are widow lines in oracle reports?
Widow lines are the minimum number of lines of the boilerplate text or field that
should appear on the logical page where the text starts to print. If the number of
lines specified for this property cannot fit on the logical page, then all lines of
the boilerplate are moved to the next page.
5. What are widow records in oracle reports?
Widow records are the minimum number of instances (records) that should appear on the
logical page where the repeating frame starts to print. If the number of
instances specified for this property cannot fit on the logical page where the
repeating frame is initially triggered to print, then the repeating frame will start
formatting on the next page.
6. What is 'page protect' property for objects in oracle reports?
Page protect property for an object indicates whether to try to keep the entire object
and its contents on the same logical page. Checking Page Protect 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.
7. What is the 'Print Condition Type' property in oracle reports?
'Print Condition Type' property specifies the frequency with which you want the object to appear in the report.
The Print Condition Type options indicate the logical page(s) on which the object should be triggered
to print with regard to the Print Condition Object.
8. What is the horizontal of vertical sizing property of objects in oracle reports?
Horizontal of vertical sizing property specifies how the horizontal or vertical size of the object may
change at runtime to accommodate the objects or data within it.
9. Name some of the procedures in the SRW package in oracle reports?
SRW.Message
SRW.User_Exit
SRW.Do_Sql
SRW.Run_Report
10. What is 'Page Break Before' object property in oracle reports?
'Page Break Before' object property indicates that you want the object to be formatted on the page
after the page on which it is initially triggered to print. Note that this does not necessarily mean
that all the objects below the object with Page Break Before will move to the next page.
11. What is 'Page Break After' object property in oracle reports?
'Page Break After' object property indicates that you want all children of the object to be moved to the next page.
In other words, any object that is a child object of an anchor (implicit or explicit) to this object will be treated
as if it has Page Break Before set. Note that this does not necessarily mean that all the objects below the object
with Page Break After will move to the next page.
12. How can a group in a cross products be visually distinguished from a group that does not form a cross product?
A group that forms part of a cross product will have a thicker border.
13. Atleast how many set of data must a data model have before a data model can be base on it?
Four.
14. Is it possible to have a link from a group that is inside a cross product to a group outside ? (Y/N)
No.
15. Is it possible to link two groups inside a cross products after the cross products group has been created?
No.
16. What is an user_exit used for?
A way in which to pass control (and possibly arguments ) form Oracle report to another Oracle products of 3 GL
and then return control ( and ) back to Oracle reprots.
17. What are the three types of user exits available ?
Oracle Precompiler exits, Oracle call interface,NonOracle user exits.
18. How can values be passed bet. precompiler exits & Oracle call interface?
By using the statement EXECIAFGET & EXECIAFPUT.
19. what are the parameters are available in oracle reports?
Two parameters in oracle reports
1. System parameter
2. User Parameter
20. How can a cross product be created?
By selecting the cross products tool and drawing a new group surrounding the base group of the cross products.
No comments:
Post a Comment