View the Exhibit and examine the structure of the PRODUCTS table. You need to generate
a report in the following format: CATEGORIES 5MP Digital Photo Camera’s category is
Photo Y Box’s category is Electronics Envoy Ambassador’s category is Hardware Which
two queries would give the required output? (Choose two.)
A.
SELECT prod_name || q'<‘s >’ || ‘category is ‘ || prod_category CATEGORIES FROM
products;
B.
SELECT prod_name || q”’s category is ‘ || prod_category CATEGORIES FROM products;
C.
SELECT prod_name || q'[‘s ]’category is ‘ || prod_category CATEGORIES FROM
products;
D.
SELECT prod_name || q’\’s\’ || ‘ category is ‘ || prod_category CATEGORIES FROM
products;