Which of these functions are performed by the optimizer? (Choose four.)
A. Checks the SQL syntax.
B. Chooses an access path for each table.
C. Transforms statements, if needed.
D. Evaluates expressions and conditions.
E. Chooses the optimizer approach (rule- or cost-based).
Explanation:
Answer BCDE: These are the functions of the optimizer. The parser is responsible for validating SQL syntax and database references. The SQL execution engine then executes the query.
No comments:
Post a Comment