What is RULE-based approach to optimization?

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

(Continued from previous question...)

190. What is RULE-based approach to optimization?

Choosing an executing plan based on the access paths available and the ranks of these access paths.

(Continued on next question...)

Other Job Interview Questions

• Differentiate simple and complex, snapshots?
• Audit Trial
• What are the built-ins that are used for setting the LOV properties at runtime?
• What are the two panes that Appear in the design time pl/SQL interpreter?
• Explain materialized views and how they are used.
• What is Statement Auditing?
• What are the trigger associated with image items?
• Do View contain Data?
• What is user Account in Oracle database?
• Can a Tablespace hold objects from different Schemes?
• More...