The statement used to find out which character sets are available is . . . . . . . .

Solution (By Examveda Team)

This question is about how to list all the character sets available in your MySQL database. Character sets define how letters, numbers, and symbols are stored and represented. Here's the breakdown of the options:
Option A: SHOW CHARACTER SET
This is the correct answer! This statement directly lists all the character sets available in your MySQL database.
Option B: SHOW COLLATION
This statement lists all the collations available. Collations are rules for comparing and sorting characters within a specific character set.
Option C: SHOW CHARACTER SETS
This is similar to Option A, but it's not the standard way to list character sets in MySQL.
Option D: SHOW COLLATIONS
This statement lists all the collations, not the character sets.
So, the best answer is Option A: SHOW CHARACTER SET. This statement will give you a list of all the available character sets in your MySQL database.