【071考试题库】OCP-1Z0-071最新考试题库大全-第12题
Oracle 12c的OCP考试考3科，分别是071、062、063，对于这些考题，我们专门有人负责收集整理，并由专业的老师对这些考题进行解析，希望可以帮助想考OCP的同学，这里开始介绍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
(执行结果如下：
Promotion Launches
---------------------------------------------------------------
NO PROMOTION #'s start date was \01-1 月 -99
newspaper promotion #16-108's start date was \23-12 月-00
)
精华阅读