SQL Quiz: What is FULL-TEXT index?

Task :

What is FULL-TEXT index? Select all correct facts from the options below:

Full-text indexes are identical across all SQL databases.

You can only create a full-text index on numeric columns.

A full-text index guarantees faster performance than a B-tree index for any query.

A FULL-TEXT index is a special index for efficient searching of words and phrases in large text columns.

Full-text indexes automatically support typo correction in all engines.

Full-text search often uses tokenization and can ignore stopwords depending on configuration.

Full-text indexes are designed for searching words within large text columns like VARCHAR or TEXT.

Mark all correct answers and click the "Check!" button

Login