（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;(here)

D. SELECT prod_name || q'<'s >' || 'category is ' || prod_category CATEGORIES FROM products;

答案：（C、D）

备注：从Oralce 10g开始，可以使用q’<>/[]/{}/\\’，引号中用特殊字符将作为普通字符使用。

ITPub博客

Oracle Certificate Profession 1Z0-051-13