Which statement is used to check how MySQL would execute a SELECT query?

This question is asking about a command in MySQL that lets you see how the database plans to run a SELECT query. Think of it like a roadmap for your query!

Here's why the answer is D: EXPLAIN:
* EXPLAIN is specifically designed to give you a breakdown of how MySQL will approach your query.
* TELL, SHOW, and DISPLAY have different uses in MySQL. They don't deal with analyzing query execution plans.

So, if you want to understand how your SELECT query will be processed, use the EXPLAIN statement!