OCPÈÏÖ¤Ì⣺11g-1Z0-051-v9.02-013Ìâ

OCP¿¼ÊÔÌâ¿â£º11g-1Z0-051-v9.02-013Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

13. 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;

Answer: CD