nerdexam
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)
  • A
    6% (2)
  • B
    85% (29)
  • C
    9% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-883 Practice