____ query optimization means that the DDBMS finds the most cost-effective access path without user intervention.
A) Static
B) Dynamic
C) Automatic
D) Commit

Question

Quizplus · Accepted Answer

Automatic query optimization refers to the ability of the DDBMS to find the most cost-effective access path without user intervention. This is achieved through the use of various optimization techniques such as cost-based optimization, rule-based optimization, and heuristic-based optimization. In contrast, static optimization requires the user to specify the access path, while dynamic optimization involves constant re-evaluation of the access path during query execution. The term "commit" refers to the final stage of a transaction in which the changes made to the database are permanently saved.

____ Query Optimization Means That the DDBMS Finds the Most