Question

Which of the following statements is true about SQLite full-text search?

a) SQLite supports full-text search using the FTS5 extension.

b) Full-text search allows you to search for words or phrases within a large block of text.

c) Full-text search can be faster than a LIKE query for large amounts of text.

d) All of the above.

Answer 1

Answer: d) All of the above.

Explanation: SQLite supports full-text search using the FTS5 extension, which allows you to search for words or phrases within a large block of text. Full-text search can be faster than a LIKE query for large amounts of text.