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

Where are the settings stored for each instance in oracle?

How to view the tablespaces in the current database?

What is a named program unit?

What is cluster Key ?

How to create a new oracle data file?

does the query needs a hint to access a materialized view?

Â What are the oracle DML commands possible through an update strategy?

What privilege is needed for a user to query tables in another schema?

What is query image?

Query to retrieve record for a many to many relationship ?

How to drop a tablespace?

Explain oracle data types with examples?

For more Oracle General Interview Questions Click Here