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:

Critical Items

Goods or components crucial for the manufacturing process or customer satisfaction, often given higher priority in inventory management.

Inventory

The total amount of goods stored by a company that is ready or will be ready for sale.

Service Inventory

Intangible goods in a service operation that cannot be stored or inventoried in the traditional sense, such as available hotel rooms or hours of consulting.