OCP考试题库：11g-1Z0-051-v9.02-016题
最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！
我要咨询OCP考试题库：11g-1Z0-051-v9.02-016题，完整题库请点击这里联系老师咨询了解
16. Evaluate the following query:
SQL> SELECT promo_name q'{'s start date was }' promo_begin_date
AS "Promotion Launches"
FROM promotions;
What would be the outcome of the above query?
A. It produces an error because flower braces have been used.
B. It produces an error because the data types are not matching.
C. It executes successfully and introduces an 's at the end of each promo_name in the output.
D. It executes successfully and displays the literal " {'s start date was } " for each row in the output.
Answer: C
试题解析：
实验验证：
sh@TEST1107> SELECT promo_name|| q'{'s start date was }'|| promo_begin_date AS "Promotion Launches" FROM promotions;
Promotion Launches
------------------------------------------------------------------
NO PROMOTION #'s start date was 01-JAN-99
newspaper promotion #16-108's start date was 23-DEC-00
post promotion #20-232's start date was 25-SEP-98
newspaper promotion #16-349's start date was 10-JUL-98
internet promotion #14-471's start date was 26-FEB-00
TV promotion #13-448's start date was 06-AUG-00
