41.
Which database do you have to install in order to enable the Semantic Search feature?
- A.msdb
- B.distribution
- C.semanticsdb
- D.tempdb
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
|
A. Incorrect: The msdb database is installed by default and is used for SQL Server
Agent. B. Incorrect: The distribution database is installed and used by replication. C. Correct: You need the semanticsdb database in order to enable semantic search. D. Incorrect: The tempdb database is installed by default and is used for all temporary objects. |
42.
How can you create synonyms for the words searched?
- A.You can edit the thesaurus file.
- B.You can create a thesaurus table.
- C.You can use the stopwords for synonyms as well.
- D.Full-text search does not support synonyms.
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
|
A. Correct: You can add synonyms by editing the thesaurus file. B. Incorrect: Full-text search uses thesaurus files and not tables for synonyms. C. Incorrect: You cannot use stopwords for synonyms. D. Incorrect: Full-text search supports synonyms. |
43.
Which of the following is not a part of the CONTAINS predicate?
- A.FORMSOF
- B.THESAURUS
- C.NEAR
- D.PROPERTY
- E.TEMPORARY
- Answer & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
|
A. Incorrect: FORMSOF is a valid keyword of the CONTAINS predicate. B. Incorrect: THESAURUS is a valid keyword. C. Incorrect: NEAR is a valid keyword. D. Incorrect: PROPERTY is a valid keyword. E. Correct: TEMPORARY is not a valid keyword of the CONTAINS predicate. |
44.
Which form of the proximity term defines the distance and the order?
- A.NEAR((SearchWord1, SearchWord2), 5, TRUE)
- B.NEAR((SearchWord1, SearchWord2), CLOSE, ORDER)
- C.NEAR((SearchWord1, SearchWord2), 5)
- D.NEAR(SearchWord1, SearchWord2)
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
|
A. Correct: This proximity term defines both distance and order of searched terms. B. Incorrect: This is not a valid syntax. C. Incorrect: This proximity term defines distance of searched terms only. D. Incorrect: This proximity term does not define either distance or order of searched terms. |
45.
What can you search for with the CONTAINS predicate? (Choose all that apply.)
- A.Inflectional forms of a word
- B.Synonyms of a searched word
- C.Translations of a word
- D.Text in which a search word is close to another search word
- E.A prefix of a word or a phrase only
- Answer & Explanation
- Report
Answer : [A, B, D, E]
Explanation :
Explanation :
|
A. Correct: You can search for inflectional forms of a word. B. Correct: You can search for synonyms of a searched word. C. Incorrect: Full-text search does not support translations. D. Correct: You can search for text in which a search word is close to another search word. E. Correct: You can search for a prefix of a word or a phrase only. |
|
|
||||||||||||||||||||||||||||
