46.
Which function can be used to rank documents based on proximity of words?
- A.CONTAINSTABLE()
- B.FREETEXTTABLE()
- C.SEMANTICKEYPHRASETABLE()
- D.SEMANTICSIMILARITYTABLE()
- E.SEMANTICSIMILARITYDETAILSTABLE()
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
|
A. Correct: You use the CONTAINSTABLE function to rank documents based on proximity
of words. B. Incorrect: You use the FREETEXTTABLE function to rank documents based on containment of words. C. Incorrect: You use the SEMANTICKEYPHRASETABLE function to return key phrases associated with the full-text indexed column. D. Incorrect: You use the SEMANTICSIMILARITYTABLE function to retrieve documents scored by similarity to a specified document. E. Incorrect: You use the SEMANTICSIMILARITYDETAILSTABLE function to return key phrases that are common across two documents. |
47.
Which function can be used to find the document that is most semantically similar to a
specified document?
- A.CONTAINSTABLE()
- B.FREETEXTTABLE()
- C.SEMANTICKEYPHRASETABLE()
- D.SEMANTICSIMILARITYTABLE()
- E.SEMANTICSIMILARITYDETAILSTABLE()
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
|
A. Incorrect: You use the CONTAINSTABLE function to rank documents based on
proximity of words. B. Incorrect: You use the FREETEXTTABLE function to rank documents based on containment of words. C. Incorrect: You use the SEMANTICKEYPHRASETABLE function to return key phrases associated with the full-text indexed column. D. Correct: You use the SEMANTICSIMILARITYTABLE function to retrieve documents scored by similarity to a specified document. E. Incorrect: You use the SEMANTICSIMILARITYDETAILSTABLE function to return key phrases that are common across two documents. |
48.
Which function returns a table with key phrases associated with the full-text indexed
column?
- A.CONTAINSTABLE()
- B.FREETEXTTABLE()
- C.SEMANTICKEYPHRASETABLE()
- D.SEMANTICSIMILARITYTABLE()
- E.SEMANTICSIMILARITYDETAILSTABLE()
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
|
A. Incorrect: You use the CONTAINSTABLE function to rank documents based on
proximity of words. B. Incorrect: You use the FREETEXTTABLE function to rank documents based on containment of words. C. Correct: You use the SEMANTICKEYPHRASETABLE function to return key phrases associated with the full-text indexed column. D. Incorrect: You use the SEMANTICSIMILARITYTABLE function to retrieve documents scored by similarity to a specified document. E. Incorrect: You use the SEMANTICSIMILARITYDETAILSTABLE function to return key phrases that are common across two documents. |
49.
Which FOR XML options are valid? (Choose all that apply.)
- A.FOR XML AUTO
- B.FOR XML MANUAL
- C.FOR XML DOCUMENT
- D.FOR XML PATH
- Answer & Explanation
- Report
Answer : [A, D]
Explanation :
Explanation :
|
A. Correct: FOR XML AUTO is a valid option to produce automatically formatted
XML. B. Incorrect: There is no FOR XML MANUAL option. C. Incorrect: There is no FOR XML DOCUMENT option. D. Correct: With the FOR XML PATH option, you can format XML explicitly. |
50.
Which directive of the FOR XML clause should you use to produce element-centric XML?
- A.ATTRIBUTES
- B.ROOT
- C.ELEMENTS
- D.XMLSCHEMA
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
|
A. Incorrect: There is no specific ATTRIBUTES directive. Attribute-centric formatting
is the default. B. Incorrect: With the ROOT option, you can specify a name for the root element. C. Correct: Use the ELEMENTS option to produce element-centric XML. D. Incorrect: With the XMLSCHEMA option, you produce inline XSD. |
|
|
||||||||||||||||||||||||||||
