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 REGEXPJJKE (category_description, ‘hard+.sā);
B.
WHERE REGEXPJJKE (category_description, ā^H|hard+.sā);
C.
WHERE REGEXPJJKE (category_description, ‘^H|hard+.s$’);
D.
WHERE REGEXPJJKE (category_description, ‘[^Hlhard+.s]’);
D is correct also because:
SQL> select * from dual WHERE REGEXP_LIKE (‘harddisks’, ‘[^H|hard+.s]’);
D
–
X
A,B