-
-
-
-
-
If yes, how?
By the use anchors.
-
What are the two repeating frame always associated with matrix object?
One down repeating frame below one across repeating frame.
-
-
-
How can a square be drawn in the layout editor of the report writer?
By using the rectangle tool while pressing the (Constraint) key.
-
-
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.
-
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.
-
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.
-
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.
-
-
-
Give the sequence of execution of the various report triggers?
Before form , After form , Before report, Between page, After report.
-
-
What are the ways to monitor the performance of the report?
Use reports profile executable statement.Use SQL trace facility.
-
Why is it preferable to create a fewer no. of queries in the data model?
Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data.
Oracle Concepts Interview Questions
Ans