nerdexam
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)
  • A
    6% (2)
  • B
    3% (1)
  • C
    6% (2)
  • D
    84% (26)

Community Discussion

No community discussion yet for this question.

Full C_HANAIMP142 Practice