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

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

Accepted Answer

A. WHERE REGEXP_LIKE (category_description, 'hard+.s'); B. WHERE REGEXP_LIKE (category_description,`^H|hard+.s');

Answer

C. WHERE REGEXP_LIKE (category_description, '^H|hard+.s$');

Answer

D. WHERE REGEXP_LIKE (category_description, '[^Hlhard+.s]');

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…

Question

Options

How the community answered

Community Discussion