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

How to create index-by table in oracle?

How to update a table row with a record?

How to filter out duplications in the returning rows using oracle?

Explain the use of record length option in exp command.

Point out the difference between user tables and data dictionary?

how to retrieve daily sal from emp table in oracle 10g

how many columns can a plsql table have

How to run the anonymous block again?

How to sort output in descending order in oracle?

What are a cluster and non-cluster index?

what is the difference between UNION AND UNIONALL

What is dual table oracle?

For more Oracle General Interview Questions Click Here