What are the values that can be specified for OPTIMIZER

What are the values that can be specified for
OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?

Question Posted / guest

What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Comman..

Answer / guest

CHOOSE,ALL_ROWS,FIRST_ROWS and RULE

Is This Answer Correct ?

0 Yes

2 No

More Oracle General Interview Questions

Name the various constraints used in oracle?

Where is the export dump file located?

Design database draw er diagram for a certain scenario ?

How to use "if" statements on multiple conditions?

What is sequence?

What is the Tune Query

How to use windows user to connect to the server?

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

What do you mean by a tablespace?

Write a simple Store procedure and pass parameter to it ?

What are ACID properties in databases?

how to clone 9i Database on to 10g Database.

For more Oracle General Interview Questions Click Here