To check how MySQL would execute a SELECT query, which statement is used?

This question is about understanding how MySQL works behind the scenes. Imagine you're asking MySQL, "Hey, how are you going to find the data I asked for in this SELECT query?"

To answer that question, we use a special command. Out of the options given, the one that helps us see the execution plan is EXPLAIN.

So the answer is Option D: EXPLAIN.

Let's break down why the other options are incorrect:
* TELL: This command isn't used in MySQL. It's more common in other databases.
* SHOW: This command is used to get information about the database itself, like tables or user privileges.
* DISPLAY: This command isn't used in MySQL either.

Remember: EXPLAIN is your go-to command when you want to understand how MySQL will execute your SELECT query.