Home > Sample chapters > Programming > SQL Server

Querying Full-Text Data in Microsoft SQL Server 2012

Answers

This section contains answers to the lesson review questions and solutions to the case scenarios in this chapter.

Lesson 1

  1. Correct Answers: A and D

    1. Correct: Stopwords include noisy words.

    2. Incorrect: Thesaurus is used for synonyms.

    3. Incorrect: Stemmer is used for generating inflectional forms of words.

    4. Correct: You group stopwords in stoplists.

  2. Correct Answer: C

    1. Incorrect: The msdb database is installed by default and is used for SQL Server Agent.

    2. Incorrect: The distribution database is installed and used by replication.

    3. Correct: You need the semanticsdb database in order to enable semantic search.

    4. Incorrect: The tempdb database is installed by default and is used for all temporary objects.

  3. Correct Answer: A

    1. Correct: You can add synonyms by editing the thesaurus file.

    2. Incorrect: Full-text search uses thesaurus files and not tables for synonyms.

    3. Incorrect: You cannot use stopwords for synonyms.

    4. Incorrect: Full-text search supports synonyms.

Lesson 2

  1. Correct Answer: E

    1. Incorrect: FORMSOF is a valid keyword of the CONTAINS predicate.

    2. Incorrect: THESAURUS is a valid keyword.

    3. Incorrect: NEAR is a valid keyword.

    4. Incorrect: PROPERTY is a valid keyword.

    5. Correct: TEMPORARY is not a valid keyword of the CONTAINS predicate.

  2. Correct Answer: A

    1. Correct: This proximity term defines both distance and order of searched terms.

    2. Incorrect: This is not a valid syntax.

    3. Incorrect: This proximity term defines distance of searched terms only.

    4. Incorrect: This proximity term does not define either distance or order of searched terms.

  3. Correct Answers: A, B, D, and E

    1. Correct: You can search for inflectional forms of a word.

    2. Correct: You can search for synonyms of a searched word.

    3. Incorrect: Full-text search does not support translations.

    4. Correct: You can search for text in which a search word is close to another search word.

    5. Correct: You can search for a prefix of a word or a phrase only.

Lesson 3

  1. Correct Answer: A

    1. Correct: You use the CONTAINSTABLE function to rank documents based on proximity of words.

    2. Incorrect: You use the FREETEXTTABLE function to rank documents based on containment of words.

    3. Incorrect: You use the SEMANTICKEYPHRASETABLE function to return key phrases associated with the full-text indexed column.

    4. Incorrect: You use the SEMANTICSIMILARITYTABLE function to retrieve documents scored by similarity to a specified document.

    5. Incorrect: You use the SEMANTICSIMILARITYDETAILSTABLE function to return key phrases that are common across two documents.

  2. Correct Answer: D

    1. Incorrect: You use the CONTAINSTABLE function to rank documents based on proximity of words.

    2. Incorrect: You use the FREETEXTTABLE function to rank documents based on containment of words.

    3. Incorrect: You use the SEMANTICKEYPHRASETABLE function to return key phrases associated with the full-text indexed column.

    4. Correct: You use the SEMANTICSIMILARITYTABLE function to retrieve documents scored by similarity to a specified document.

    5. Incorrect: You use the SEMANTICSIMILARITYDETAILSTABLE function to return key phrases that are common across two documents.

  3. Correct Answer: C

    1. Incorrect: You use the CONTAINSTABLE function to rank documents based on proximity of words.

    2. Incorrect: You use the FREETEXTTABLE function to rank documents based on containment of words.

    3. Correct: You use the SEMANTICKEYPHRASETABLE function to return key phrases associated with the full-text indexed column.

    4. Incorrect: You use the SEMANTICSIMILARITYTABLE function to retrieve documents scored by similarity to a specified document.

    5. Incorrect: You use the SEMANTICSIMILARITYDETAILSTABLE function to return key phrases that are common across two documents.

Case Scenario 1

  1. You should use the Full-Text Search feature of SQL Server.

  2. You should revise your queries to include the full-text predicates, or use the full-text and semantic search table-valued functions.

Case Scenario 2

  1. A T-SQL solution is simpler in this scenario because the SQL Server Full-Text Search and Semantic Search features support the functionality you need out of the box.

  2. You should use the SEMANTICSIMILARITYTABLE function.