Oracle
1Z0-873 · Question #4
Which of the following best describes the processing model for how the MySQL server handles queries?
The correct answer is B. The server uses a two-tier processing model: a SQL/optimizer tier and a storage engine tier. The upper tier includes the SQL parser and optimizer. The lower tier comprises a set of storage engines.
JDBC
Question
Which of the following best describes the processing model for how the MySQL server handles queries?
Options
- AThe server uses a one-tier processing model in which each storage engine optimizes and
- BThe server uses a two-tier processing model: a SQL/optimizer tier and a storage engine tier.
- CThe server uses a three-tier processing model: a SQL/optimizer tier, a formatting tier and a
How the community answered
(55 responses)- A9% (5)
- B71% (39)
- C20% (11)
Explanation
The upper tier includes the SQL parser and optimizer. The lower tier comprises a set of storage engines.
Topics
#MySQL architecture#SQL optimizer#storage engine tier#processing model
Community Discussion
No community discussion yet for this question.