nerdexam
SAP

C_HANAIMP131 · Question #109

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
  • CIt performs a fuzzy search on the PRODUCT_NAME column in the PRODUCT_ITEMS table
  • DIt performs a fuzzy search of all columns in the PRODUCT_ITEMS table for the term 'Paper'.

How the community answered

(46 responses)
  • A
    4% (2)
  • B
    9% (4)
  • C
    2% (1)
  • D
    85% (39)

Community Discussion

No community discussion yet for this question.

Full C_HANAIMP131 Practice