MySQL supports different character sets. Which command is used to display all…

Concept

Database systems expose metadata through administrative statements. In MySQL, SHOW statements inspect server-supported objects and settings.

A compound SHOW statement narrows the request to a particular metadata category, such as character sets.

Application

1. The task asks for the list of character sets known to the MySQL server, so the required metadata category is CHARACTER SET.

2. Combining the SHOW statement with that category gives SHOW CHARACTER SET.

3. SHOW alone does not specify a metadata category, while CHARACTER SET alone is not the required SHOW statement.

Contrast

• SHOW CHARACTER SET is the complete statement for listing the server-supported character sets.

• SHOW is only the administrative statement family without the requested category.

• CHARACTER SET is the category phrase without the SHOW statement.

• None of the mentioned does not apply because a complete command is present among the choices.

Cross-check

MySQL documentation gives the syntax SHOW CHARACTER SET [LIKE pattern | WHERE expression], confirming SHOW CHARACTER SET as the base statement.

Therefore, the command is SHOW CHARACTER SET.