The DBMS _____ the SQL query and chooses the most efficient access/execution plan.
A) parses
B) executes
C) fetches
D) processes

Question

Quizplus · Accepted Answer

Parsing is the process of analyzing the SQL query and breaking it down into its constituent parts. During parsing, the DBMS checks the syntax and semantics of the query to ensure that it is valid, and converts it into a format that the query optimizer can understand. The query optimizer then takes over and chooses the most efficient access/execution plan for the query.

The DBMS _____ the SQL Query and Chooses the Most