QuizzesFull-Text Index — Concept Check
intermediate
mysql

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.

8 minutes 8 questions Pass at 70%
Time Limit
8 minutes - timer starts when you begin
Change Answers Freely
Revisit and change any answer before submitting
Full Review After Submit
Correct answers and explanations shown for every question
Auto-submit on timeout
Quiz submits automatically when time runs out

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. 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. 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. 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. 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. 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. 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. 7.Which operator in Boolean mode is used to increase the relevance of a search term?

    • A+
    • B*
    • C<
    • D-
  8. 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