Oracle
1Z0-883 · Question #74
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. See the full explanation below for the reasoning.
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
- DNone of the above.
How the community answered
(34 responses)- A6% (2)
- B85% (29)
- C9% (3)
Community Discussion
No community discussion yet for this question.