大數(shù)據(jù)就業(yè)實戰(zhàn)培訓 Oracle就業(yè)實戰(zhàn)培訓
071考試題庫之前是比較穩(wěn)定的,但隨著Oracle的調(diào)整,071考試不斷的增加新的考題,增加了考試的難度,所以我們專門收集整理了這些考試,并對這些考題進行解析,希望可以對考生有幫助。
每周五晚8點,我們有免費的OCP解析公開課,地址:https://ke.qq.com/course/326223 OCP題庫交流群:1015267481,驗證ocp
-------------------------------------------------------
071考試-第12題、choose the best answer
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 the data types are not matching.
B) It executes successfully and displays the literal "{'s start date was \} " for each row in the output.
C) It executes successfully and introduces an 's at the end of each promo_name in the output.
D) It produces an error because flower braces have been used.
Answer:B
(執(zhí)行結(jié)果如下:
Promotion Launches
---------------------------------------------------------------
NO PROMOTION #'s start date was \01-1 月 -99
newspaper promotion #16-108's start date was \23-12 月-00
)