Automatic Query Optimization Means That The

Multiple Choice

Automatic query optimization means that the:

A) optimization takes place at compilation time by the programmer.
B) DBMS finds the most cost-effective access path without user intervention.
C) optimization process is scheduled and selected by the end user or programmer.
D) database access strategy is defined when the program is executed.