Oracle Interview Questions And Answers


Computer Tutorials
Earn Money From Internet
Cheap Freelancers
Ask An Expert

Register Cheap Domain
Data Recovery
Best Mutual Funds
Trading Forex Online
Cheap Web Hosting
Ajax Tutorials
Cheap Cell Phone Plans
Free Mobile Learning
Job Portal
Photoshop Tutorials
Cheap Jewelry
Cheapest Air Travel

Oracle Interview Questions And Answers


Page 73 of 95
view by structure.

61.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.

62. How is it possible to select generate a select ste. for the
query in
the query property sheet?

By using the tables/columns button and then specifying the table and
the
column names.

63. 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.

64. Do user parameters appear in the data modal editor in 2.5?

No.

65.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.

66. What is the diff. when Flex mode is mode on and when it is off?

When flex mode is on, reports automatically resizes the parent when
the
child is resized.

67. How can a button be used in a report to give a drill down facility?

By setting the action asscoiated with button to Execute pl/sql option
and
using the SRW.Run_report function.

68. What are the two ways by which data can be generated for a
parameter's
list of values?

1. Using static values.
2. Writing select statement.