The statement used to find out which character sets are available is ______________
(a) SHOW CHARACTER SET
(b) SHOW COLLATION
(c) SHOW CHARACTER SETS
(d) SHOW COLLATIONS
(a) SHOW CHARACTER SET
(b) SHOW COLLATION
(c) SHOW CHARACTER SETS
(d) SHOW COLLATIONS
Correct choice is (a) SHOW CHARACTER SET
Easiest explanation: It is simple to determine the character sets and collations that are available in MySQL. ‘SHOW CHARACTER SET’ shows the character sets while ‘SHOW COLLATION’ shows the collations.