-
What are the two types of views available in the object navigator(specific to report 2.5)?
View by structure and view by type .
-
Which of the two views should objects according to possession?
View by structure.
-
How is possible to restrict the user to a list of values while entering values for parameters?
By setting the Restrict To List property to true in the parameter property sheet.
-
How is it possible to select generate a select set for the query in the query property sheet?
By using the tables/columns button and then specifying the table and the column names.
-
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?
While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.
-
-
What is the diff. when confine mode is on and when it is off?
When confine mode is on, an object cannot be moved outside its parent in the layout.
-
How can a button be used in a report to give a drill down facility?
By setting the action associated with button to Execute pl/sql option and using the SRW.Run_report function.
-
What are the two ways by which data can be generated for a parameters list of values?
1. Using static values.2. Writing select statement.
-
What are the two panes that Appear in the design time pl/sql interpreter?
1.Source pane. 2. Interpreter pane
-
What are three panes that appear in the run time pl/sql interpreter?
1.Source pane. 2. interpreter pane. 3. Navigator pane.
-
What are the different file extensions that are created by oracle reports?
Rep file and Rdf file.
-
-
-
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.
-
What is bind reference and how can it be created?
Bind reference are used to replace the single value in sql, pl/sql statements a bind reference can be created using a (:) before a column or a parameter name.
-
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.
-
-
-
Oracle Concepts Interview Questions
Ans