Which tool runs the query
Which part of a Database Management System (DBMS) checks an SQL statement, works out the most efficient way to carry it out, and runs it against the database?
A developer interface
B query processor
C data dictionary
D logical schema
[1]
- 1
Rule out the other options. The developer interface is used to build tables, forms, reports and queries. The data dictionary stores metadata (data about the data). The logical schema is the design of the tables, fields and relationships.
- 2
The query processor takes a query, checks it, optimises it and executes it, then returns the results. Answer B (1).
Answer
B
Examiner tip
Examiner tip: a short way to keep the two tools apart: the developer interface is where a query is written; the query processor is where it is run.
Common mistake: choosing C because the data dictionary is used during the check. The query processor does look up table and field names in the data dictionary, but the dictionary itself does not run anything.