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

Solution (By Examveda Team)

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.