Which built-in is used to call the required
Report?
Run_Product.
Can you pass runtime parameters from reports
to a Graphics display?
Yes, you
can.
Do you use bind references to replace
reserved words or clauses?
Yes.
Which object you create to hold a value that
end_users can change at runtime?
User
Parameter.
Which property handles a situation where an
expected parameter is not passed at runtime?
Initial
Value.
Do you use System Parameter DESNAME to
specify the destination type for output?
No.
Do you reference parts of the SRW Package in
layout format triggers or report level trigger?
Yes, you
do.
Do you think that you can call the contents
of SRW Package form within any of the Developer tools?
No, you
do no.
Which SRW Package Procedure is used to apply
specified formatting attribute to the current layout object?
SRW.SET_ATTR.
In a Character Mode environment interaction
with the host computer is continuous or not?
It is
not continuous.
In a Bitmapped Mode environment interaction
with the host computer is continuous or not?
It is
continuous.
Do you think that Reports stored in the
database generally execute faster than those stored in the file system?
No.
Is it advisable to remove the redundant
frames in the layout ?
Yes, it is.
Can you determine your own search paths for
files called by Developer/2000 tools in a windows environment?
Yes, you
can.
Which file is used in windows environment as
the Performance File?
CAUPREFS.ORA.
Does Printer Definition file acts as a
translator for the Printer?
Yes.
'Reports printer definitions are stored as
SQL Plus files', is this statement is true?
No.
Do you need to compile Printer definitions
files before using them?
No you
don't need.
Which script deletes Report's specific
tables?
SRW2.DROP.SQL.
Does Confine mode keep child objects enclosed
within their parent frames?
Yes, it
is.
Do you think that it is possible for you as a
developer to assign common properties to multiple objects?
Yes.
When you set page break for an object, an objects
that appear below it always move to the next page. Is it true?
No, it
is false.
What are the categories for report_level
objects?
Data
Model objects, Layout objects, Parameter Form.
Is an external query a collection of PL/SQL
source code that can be referenced by other modules?
No, it is not.
Which design tool defines the appearance of
an interface that allow the end_user to supply runtime values to report?
Parameter
Form Editor.
Can External queries be saved to the
database?
Yes, you
can.
What is contained in the Database objects
fields of the Tables and Column names dialog box ?
Table
and View names.
The Master_Detail layout is the combination
of which two layouts?
Form and
Tabular.
By default is there a page break after each
record in the form default layout?
Yes,
there is.
Does a break report always contain a break
group?
Yes.
Is it true that a break report data model is
created using at least two queries and at least one group?
No, it
is false.
If you minimize the number of break columns
in your break groups, will you minimize the number of columns that are added to
the order by clause?
Yes, you
will.
The link causes, which query to be executed
for each instance of the Parent group?
Child
query.
How many cursors does Reports have to open for
a two-query data structure?
Two.
Does Default columns referred to as common
columns?
No, they
are not.
Does Default columns referred to as
placeholder columns?
No, they
are not.
Does Formula column performs a user_defined
computation on another columns data?
Yes.
Which field in Summery column's Property
Sheet shows the calculation to be performed?
Function
field.
If a Placeholder columns datatype is LONG or
LONGROW can you edit the width field?
Yes, you
can.
Can we define a Summery
column at Group level?
Yes we
can.
What anchor does?
Links
one or more layout objects together.
Does queries are created by default?
No
'Oracle Reports creates one group for each
query', Is it true?
Yes.
Does link are created by default?
No
Where you can restrict maximum number of
rows?
In Query
Property Sheet, in maximum rows field.
Because of creation of links, the
relationship between which two objects is created?
Group
and Query
To produce control break reports, to produce
matrix reports and to summarize data at intermediate level which object is
needed?
Group
Object.
If you change a query name after the group
has been created, Can you change the name of group?
No, You
cannot.
If we take one query eg. Select d.id, e.salary From EMP e, dept d Where e.dept_id = d.id
Order by salary
And if we create Break Group with d.id , What
will happen?
Here
Order By clause is modified just like order by 1, salary.
A Link
defines a parent / child relationship between a group & a query. Is
it true? If yes then via which two keys?
Primary
and Foreign.
Which term in SQL is related to the
"link" in reports?
Join.
Can you create a link from child query to
parent query?
No.
Always create a link from Parent query to Child query.
What is Bind reference?
A bind
reference replaces a single value or expression.
What is a Lexical reference?
A
Lexical reference replaces any part of a select statement, such as column
names, from clause, where clause, order by clause.
In which case Parameter is created by
default?
In case
of Bind reference Parameter is created by default.
Bind reference is used to replace which
clause?
Where
clause, Group by, Order by, Having, Connected by, Start with.
What is a User Parameter?
It is an
object that you create to hold a value that user can change at runtime.
What are the properties of Parameter?
Datatype,
Width,, Input Mask, Initial Value, Validation Trigger.
What is the function of 'Restrict the List of
Predetermined Values'?
It is
used to determine whether to prevent users from entering any value not
included
in your list.
If you uncheck the restricted values check
box what will happen?
User can
also enter values to the List box.
What is the default value of System Parameter
"COPIES"?
1.
What is value of System Parameter
"COPIES"?
Any
Integer.
What is the value of System Parameter
"DECEMIAL"?
Any
single Character.
What is the default value of System Parameter
" DESFROMAT"?
dflt.
What is the function of System Parameter
" DESTYPE"?
Destination
type for output.
What are the values of System Parameter
"DESTYPE"?
FILE,
PRITER, MAIL, SCREEN, PREVIEW.
What is the default value of
"DESNAME"?
SCREEN
What do you mean by System Parameter
"MODE"?
Whether
report executes in Bitmapped mode or in Character mode.
For what purpose you use System Parameter
"ORIANTATION"?
It is
used to specify the print direction of printer output.
What are the values of System Parameter
"ORIANTATION"?
Landscape
& Portrait
What is the default value of System Parameter
"ORIANTATION"?
Portrait
What is the value of System Parameter
"THOUSAND"?
Any
single Character.
Does Oracle Reports allow DML (i.e. insert,
update, delete) in layout format triggers?
No.
When you use Group filter in Data Model?
When you
need to restrict records in a specific group.
Whenever a where clause in a query is not
applicable which data model trigger is useful?
A Group
Filter.
Do you add a filter to a Matrix Cross_Product
group?
No, you
cannot
A matrix report is also referred to as
"CROSS_TAB" report, is it true?
Yes.
How many types of matrix reports are there?
Tell
their names. There are 4 types. Simple matrix, nested matrix, multiquery matrix
with break and matrix break.
If you build a matrix report with only one
query, how many groups are require in addition to one created by default?
3
groups.
How many types of query structures are there?
Tell
their names. Two. One_Query_Matrix & Multi_Query_Matrix.
Matrix reports are built with four or more
groups. Is it true?
Yes.
What is the difference between a Nested
Matrix and a Matrix Break?
In case
of Matrix Break, One or more groups are a parent of the cross_product group.
And in
case of Nested Matrix Three or more groups are surrounded by the cross_product
group.
No comments:
Post a Comment