What is the effect of setting the value “CHOOSE”

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

181. What is the effect of setting the value “CHOOSE” for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?

The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

(Continued on next question...)

Other Job Interview Questions

• What are some of the Oracle provided packages that DBAs should be aware of?
• What are the use of Roles?
• It is possible to use raw devices as data files and what is the advantages over file system files?
• Briefly, how do you install Oracle software on UNIX.
• What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
• What is Full Backup?
• What are the steps involved in Database Shutdown?
• What is the effect of setting the value “CHOOSE” for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?
• How can you tell if a tablespace has excessive fragmentation?
• How do I eliminate the duplicate rows ?
• More...