Oracle OCP认证-Oracle OCM认证

您当前的位置:优技教育 > ocp考试 >

ocp题库解析:11g-1Z0-051-第13题

来源:优技教育

ocp题库解析:11g-1Z0-051-第13题,完整题库请点击这里联系老师咨询了解

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

精华阅读