-
-
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.
-
What are the various methods of performing a calculation in a report ?
1. Perform the calculation in the SQL statements itself.2. Use a calculated / summary column in the data model.
-
Which of the above methods is the faster method?
Performing the calculation in the query is faster.
-
Why is a Where clause faster than a group filter or a format trigger?
Because, in a where clause the condition is applied during data retrievalthan after retrieving the data.
-
What is the main diff. bet. Reports 2.0 & Reports 2.5?
Report 2.5 is object oriented.
-
What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?
LOVs can be attached to parameters in the reports 2.5 parameter form.
-
How is link tool operation different bet. reports 2 & 2.5?
In Reports 2.0 the link tool has to be selected and then two fields to be linked are selected and the link is automatically created. In 2.5 the first field is selected and the link tool is then used to link the first field to the second field.
-
What is WHEN-Database-record trigger?
Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit as an insert or update. c generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item.
Oracle Concepts Interview Questions
Ans