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]’);
|
Download Printable PDF. VALID exam to help you PASS. |
 |