What are the values that can be specified for OPTIMIZER MODE Parameter ?

What are the values that can be specified for OPTIMIZER
MODE Parameter ?

Question Posted / guest

What are the values that can be specified for OPTIMIZER MODE Parameter ?..

Answer / guest

COST and RULE

Is This Answer Correct ?

3 Yes

3 No

More Oracle General Interview Questions

which statement is running fastly ie insert or delete?

Can a property clause itself be based on a property clause ?

What is recycle bin in Oracle?

What are joins, explain all types of joins?

What privilege is needed for a user to delete rows from tables in another schema?

Is oracle a programming language?

Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?

How do you handle duplicate records in a database?

What is the use of aggregate functions in oracle?

What is SYSTEM tablespace and When is it Created?

What are transaction isolation levels supported by oracle?

Where do you use decode and case statements?

For more Oracle General Interview Questions Click Here