Oracle Reports (Report 6i) – Technical – Interview – Question Answers
Question: How many types of columns are there and what are they
Formula columns: For doing mathematical calculations and returning one value
Summary Columns: For doing summary calculations such as summations etc.
Place holder Columns: These columns are useful for storing the value in a variable
Question: Can u have more than one layout in report
Answer: It is possible to have more than one layout in a report by using the additional layout option in the layout editor.
Answer: Yes it is possible to run the report without parameter form by setting the PARAM value to Null
Question: What is the lock option in reports layout
Answer: By using the lock option we cannot move the fields in the layout editor outside the frame. This is useful for maintaining the fields.
Question: What is Flex
Answer: Flex is the property of moving the related fields together by setting the flex property on
Question: What is the minimum number of groups required for a matrix report
Question: How many different triggers are available in Report?
Answer: There are five types of triggers in report 6i
1) Before report trigger
2) After report trigger
3) Before Parameter trigger
4) After parameter trigger
5) Between pages trigger
Question: What is the Firing sequence of report trigger?
Answer: First the before parameter trigger will raise, after firing this trigger parameter form will displayed, after passing parameter after parameter trigger will fire query will parsed & then before report trigger will fired then if there are number of pages in your report then the between pages trigger will fired but it will fire between first & second & so on pages but it will not fired in reverse condition the after report trigger will fire after closing the runtime parameter form is closed.
Question: What is bind variables?
Answer: Bind variables are used in report 6i for replacing the single parameter in the select statement
Question: What is lexical parameter?
Answer: Lexical Parameter is used to replace the where, order by ………conditions at run time.
Question: What are different types of column in reports?
Answer: There are three types of columns in the report 6i these are:
1) Placeholder Column – Placeholder column is used to store a value for a variable.
2) Formula Column
Answer: The minimum of groups required for a matrix report are 4
Question: Can u run the report with out a parameter form