Automatic Query Optimization Means That The

question 71

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.

---

Definitions:

Pareto Analysis

A statistical technique in decision-making used for the selection of a limited number of tasks that produce significant overall effect. It uses the principle that 80% of results come from 20% of the actions.

Transactions Account

A bank account that allows for the direct deposit and withdrawal of funds without any limitation on the frequency of transactions.

Global Database

A comprehensive collection of data organized and stored digitally, accessible worldwide.

Technical Standards

Specifications and guidelines established by consensus among professionals that ensure the reliability, safety, and interoperability of products, services, and systems.