Prev Question
Next Question

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.)

WHERE REGEXP_LIKE (category_description, ‘hard+.s’);

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

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

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

Prev Question
Next Question

Leave a Reply

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