Most DBMSs Operate in One of Two Optimization Modes: Cost-Based

question 38

Multiple Choice

Most DBMSs operate in one of two optimization modes: cost-based or rule-based.Others automatically determine the ____ based on whether database statistics are available.

• A) data cache
• B) SQL cache
• C) sort cache
• D) optimization mode

---

Definitions:

Interference Theory

A theory that explains forgetting in the human memory as the result of competing information that interferes with the retention or retrieval of other information.

Replacement

The act of substituting one thing for another, whether it's a physical object, a person in a job role, or a concept.

Cue-dependent

Refers to the phenomenon where recall of information is improved when retrieval occurs in the same context as the initial learning.

Decay

The process by which information is lost from memory over time, typically due to the passage of time and lack of use.