View the Exhibit and examine the details for the CATEGORIES_TAB table.Evaluate the following incomplete SQL statement:SE
Posted: Wed Jun 07, 2023 6:11 am
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_tabYou want to display only the rows that have 'harddisks' as part of the string in theCATEGORY_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]');
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]');