Question

Which of the following statements is true about SQLite collations?

a) A collation determines how strings are compared and sorted.

b) SQLite has several built-in collations, including BINARY, NOCASE, and RTRIM.

c) A custom collation can be created using the CREATE COLLATION statement.

d) All of the above.

Answer 1

Answer: d) All of the above.

Explanation: A collation determines how strings are compared and sorted, and SQLite has several built-in collations, including BINARY, NOCASE, and RTRIM. A custom collation can be created using the CREATE COLLATION statement.