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]');
View the Exhibit and examine the details for the CATEGORIES_TAB table.Evaluate the following incomplete SQL statement:SE
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am