Oracle Interview Questions And Answers

Computer Tutorials, Interview Question And Answer
Data Recovery Softwares | Free Games | Online Degree | Cellular Phone| Mutual Fund | Forex
Free Scholarship| Free Magazines | Cheap Digital Camera | Cheap Air Ticket | Cheap Air Fare


Bookmark It  Blogmarks del.icio.us Digg it feedmelinks Furl reddit Spurl Yahoo MyWeb
Google Squidoo StumbleUpon
Ultimate Guide To Job Interview Answers
Download Free Interview Guides
Interview Experts Reveals All
Interview Questions Software

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.


Hosted by www.Geocities.ws




Hosted by www.Geocities.ws

1