ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

The collations this statement lists are . . . . . . . .
SHOW COLLATION LIKE 'utf8%'

Answer & Solution
Correct Answer: Option A
The statement SHOW COLLATION LIKE 'utf8%' is used to display collations that start with the characters 'utf8'.
The '%' character is a wildcard in MySQL, meaning it matches any sequence of characters.
Therefore, the statement will list collations whose names begin with 'utf8'.
Option B, names ending with utf8, is incorrect because the statement looks for collations starting with 'utf8', not ending with it.
Option C, names containing utf8% anywhere, is incorrect because the statement specifically looks for collations that start with 'utf8'.
Option D, names ending in utf8%, is incorrect because the statement searches for collations starting with 'utf8', not ending with it.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.