Which two WHERE clause options can give you the desired result?

View the Exhibit and examine the details for the CATEGORIES_TAB table. Evaluate the
following incomplete SQL statement: SELECT category_name ,category_description FROM
categories_tab You want to display only the rows that have ‘harddisks’ as part of the string
in the CATEGORY_DESCRIPTION column. Which two WHERE clause options can give
you the desired result? (Choose two.)

View the Exhibit and examine the details for the CATEGORIES_TAB table. Evaluate the
following incomplete SQL statement: SELECT category_name ,category_description FROM
categories_tab You want to display only the rows that have ‘harddisks’ as part of the string
in the CATEGORY_DESCRIPTION column. Which two WHERE clause options can give
you the desired result? (Choose two.)

A.
WHERE REGEXP_LIKE (category_description, ‘hard+.sā€™);

B.
WHERE REGEXP_LIKE (category_description, ā€˜^H|hard+.sā€™);

C.
WHERE REGEXP_LIKE (category_description, ‘^H|hard+.s$’);

D.
WHERE REGEXP_LIKE (category_description, ‘[^Hlhard+.s]’);



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Ab Hin

Ab Hin

Answer: A & B