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 can I convert single byte kana characters into multi byte kana characters and vice-versa.

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.

How to start your 10g xe server?

Can sub procedure/function be called recursively?

Explain the relationship among Database, Tablespace and Data file?

How to create a single index for multiple columns?

Explain joins in oracle?

Explain the characteristics of oracle dba?

Describe the different type of Integrity Constraints supported by ORACLE ?

How to rename a tablespace in oracle?

What is a Database instance ? Explain?

For more Oracle General Interview Questions Click Here