SELECT SCORE() as SCORE, PRODUCT_NAME, * FROM PRODUCT_ITEMS WHERE CONTAINS(*,’Paper’, FUZZY(0.8)) ORDER BY PRODUCT_NAME
A. It performs a fuzzy search on all columns in the PRODUCT_NAME table for the term ‘Paper’.
B. It performs a fuzzy search count on the number of columns in the PRODUCT_NAME table that contain the term ‘Paper’.
C. It performs a fuzzy search on the PRODUCT_NAME column in the PRODUCT_ITEMS table for the term ‘Paper’.
D. It performs a fuzzy search of all columns in the PRODUCT_ITEMS table for the term ‘Paper’.
Answer:D
SELECT SCORE() as SCORE, PRODUCT_NAME, * FROM PRODUCT_ITEMS WHERE CONTAINS(*,’Paper’, FUZZY(0.8)) ORDER BY PRODUCT_NAME
A. It performs a fuzzy search on all columns in the PRODUCT_NAME table for the term ‘Paper’. B. It performs a fuzzy search count on the number of columns in the PRODUCT_NAME table that contain the term ‘Paper’. C. It performs a fuzzy search on the PRODUCT_NAME column in the PRODUCT_ITEMS table for the term ‘Paper’. D. It performs a fuzzy search of all columns in the PRODUCT_ITEMS table for the term ‘Paper’.