Database Management Systems (DBMS)
In computer science, Query optimizer refers to which of the following?
- A. A database property ensuring that relationships between tables remain consistent, typically enforced through foreign keys.
- B. A precompiled collection of SQL statements stored in a database that can be executed as a single unit.
- C. A large, centralized repository of integrated data from multiple sources used for reporting and analysis.
- D. A DBMS component that determines the most efficient way to execute a given database query. ✓
Correct answer
D. A DBMS component that determines the most efficient way to execute a given database query.
Explanation
Query optimizer refers to a DBMS component that determines the most efficient way to execute a given database query.