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
