Bird
0
0

Why does ts_headline sometimes highlight words that are not exact matches to the query terms?

hard📝 Conceptual Q10 of 15
PostgreSQL - Full-Text Search
Why does ts_headline sometimes highlight words that are not exact matches to the query terms?
ABecause it highlights all words in the text by default.
BBecause it uses stemming and normalization in text search.
CBecause the query is case sensitive and matches partial words.
DBecause ts_headline ignores the tsquery argument.
Step-by-Step Solution
Solution:

  1. Step 1: Understand text search behavior

    PostgreSQL text search uses stemming to match word roots, not exact words.

  2. Step 2: Explain why non-exact matches highlight

    Stemming causes related word forms to be matched and highlighted.

  3. Final Answer:

    Because it uses stemming and normalization in text search. -> Option B

  4. Quick Check:

    Stemming causes related words to highlight [OK]
Quick Trick: Stemming causes related words to highlight [OK]
Common Mistakes:
  • Assuming exact word match only
  • Thinking ts_headline highlights all words
  • Ignoring stemming effects

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More PostgreSQL Quizzes
Aggregate Functions and GROUP BY - JSON aggregation with JSON_AGG - Quiz 13medium Aggregate Functions and GROUP BY - GROUPING SETS for multiple groupings - Quiz 8hard Aggregate Functions and GROUP BY - HAVING for filtering groups - Quiz 10hard Common Table Expressions - CTE vs subquery performance - Quiz 3easy Joins in PostgreSQL - NATURAL join and its risks - Quiz 1easy Joins in PostgreSQL - Self join patterns - Quiz 1easy Joins in PostgreSQL - NATURAL join and its risks - Quiz 12easy Set Operations and Advanced Queries - INTERSECT and EXCEPT - Quiz 12easy Window Functions in PostgreSQL - PARTITION BY for grouping windows - Quiz 9hard Window Functions in PostgreSQL - NTILE for distribution - Quiz 10hard