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

what is dynamic SGA and static SGA

How to apply filtering criteria at group level in oracle?

How to delete a user account in oracle?

How to define an external table with a text file?

What happens to the current transaction if the session is killed?

How to drop an index?

How to get a list of all user accounts in the database?

What is a Private Synonyms ?

how to get second highest sal of emp table

how to handle exceptions in post production

What is primefaces used for?

Why do we use coalesce function in oracle?

For more Oracle General Interview Questions Click Here