SAP
C_HANAIMP142 · Question #124
What does the following SQL statement do? SELECT SCORE() as SCORE, PRODUCT_NAME, FROM PRODUCT_ITEMS WHERE CONTAINS(,'Paper', FUZZY(0.8)) ORDER BY PRODUCT_NAME
The correct answer is D. It performs a fuzzy search of all columns in the PRODUCT_ITEMS table for the term 'Paper'. See the full explanation below for the reasoning.
Question
What does the following SQL statement do? SELECT SCORE() as SCORE, PRODUCT_NAME, * FROM PRODUCT_ITEMS WHERE CONTAINS(*,'Paper', FUZZY(0.8)) ORDER BY PRODUCT_NAME
Options
- AIt performs a fuzzy search on all columns in the PRODUCT_NAME table for the term 'Paper'.
- BIt performs a fuzzy search count on the number of columns in the PRODUCT_NAME table that
- CIt performs a fuzzy search on the PRODUCT_NAME column in the PRODUCT_ITEMS table for
- DIt performs a fuzzy search of all columns in the PRODUCT_ITEMS table for the term 'Paper'.
How the community answered
(31 responses)- A6% (2)
- B3% (1)
- C6% (2)
- D84% (26)
Community Discussion
No community discussion yet for this question.