Solved

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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q35: _ refers to the number of different

Q37: All data in a database are stored

Q40: Use _ to provide balance between performance

Q40: The cache is a shared, reserved memory

Q44: Database _ activities can be divided into

Q45: Working with data in the data cache

Q48: One of the main functions of a

Q65: Good database performance is easy to evaluate.

Q67: A cost-based optimizer uses a set of

Q75: Knowing the sparsity of a column helps