Which MySQL statement is used to find out which character sets are available?

This question is about finding out what different character sets are available in MySQL. Character sets determine how characters are stored and displayed in your database.

Let's break down the options:

Option A: SHOW CHARACTER SET - This is the correct answer. It specifically displays the available character sets.
Option B: SHOW COLLATION - This command lists available collations, which are rules for comparing and sorting characters within a character set.
Option C: SHOW CHARACTER SETS - This is the same as Option A, just with plural "SETS." It's also correct.
Option D: SHOW COLLATIONS - Similar to Option B, this lists available collations.

So, the answer is either Option A or Option C. Both are correct ways to list available character sets.