Which statement is true about a query explain plan?

A.
It determines how to run the query, runs it, and returns the result.

B.
It writes the SQL to execute a query.

C.
It tells exactly how many rows will be returned by the query.

D.
It displays the results of Optimizer to the user, showing projection(s) used and the query
process.

Explanation: