Full-Text Index — Concept Check
Questions on Full-Text Index. Full-text indexes enable MATCH(col) AGAINST('term') searches with natural language and boolean modes; faster than LIKE '%term%' for text-heavy search on large datasets.
Questions in this quiz
8 questions on Full-Text Index — Concept Check. Work through them here, then start the quiz to answer them and see your score.
1.A developer needs to perform a fast search on a large text dataset. They initially use LIKE '%term%' but find it slow. What should they do to improve performance?
- AContinue using LIKE '%term%' for simplicity
- BUse a B-tree index on the text column
- CUse a full-text index with MATCH() AGAINST()
- DSwitch to using Elasticsearch for all searches
2.In MySQL, you want to ensure that search results must include 'kafka' and exclude 'zookeeper'. Which query mode should you use?
- ALIKE '%term%'
- BNatural Language mode
- CFull table scan
- DBoolean mode
3.While setting up a full-text index, a developer notices that searches for 'AI' return no results, even though the term is present. What is likely the issue?
- A'AI' is shorter than the default min token size
- B'AI' is a stop word
- CThe query is not using Boolean mode
- DThe table lacks a full-text index
4.A team is considering using MySQL full-text search for their application. Which scenario would make Elasticsearch a better choice?
- AModerate-scale text search
- BSimple word searches on a single table
- CSearching across > 50M rows
- DNo need for multilingual tokenization
5.To perform a relevance-ranked search using full-text indexes, which mode should be used by default?
- ALIKE '%term%'
- BBoolean mode
- CNatural Language mode
- DRegular expressions
6.A developer mistakenly believes that Boolean mode results are always ranked by relevance. What is the truth about Boolean mode?
- ABoolean mode is slower than LIKE '%term%'
- BBoolean mode does not support phrase matching
- CBoolean mode results are not ranked by default
- DBoolean mode ranks results by relevance
7.Which operator in Boolean mode is used to increase the relevance of a search term?
- A+
- B*
- C<
- D-
8.What is a limitation of MySQL full-text search that might lead a developer to choose Elasticsearch instead?
- ASupports complex tokenization
- BNo support for stemming
- CFast index rebuilds
- DEfficient for > 50M rows