Question

The clause that can be used to sort string values according to a specific collation is ______________

(a) SORT

(b) GROUP

(c) FILTER

(d) COLLATE

I got this question in an internship interview.

Question is taken from Securing a New MySQL Installation topic in section General MySQL Administration of MySQL

Answer 1

The correct option is (d) COLLATE

For explanation I would say: The ‘COLLATE’ operator can be used to sort the string values according to a specific collation. For example, ‘SELECT col FROM tbl ORDER BY col COLLATE latin1_swedish_ci’ sorts by Swedish collation.