大数据就业实战培训 Oracle就业实战培训

CUUG,以就业为导向,让学员学到真正实用的技术

当前位置: CUUG培训-优技培训 >> 071考试 >

【071考试】最新OCP认证071考试题库整理-第12题

【071考试】最新OCP认证071考试题库整理-第12题

来源:CUUG培训-优技培训    更新时间:2019/5/21 9:42:43    阅读次数:

071考试题库之前是比较稳定的,但随着Oracle的调整,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

)

071考试
大数据课程
WDP
oracle机构
oracle认证
oracle课程
oracle视频
CUUG就业实战培训
CUUG与ORACLE公司建立最核心、最权威、最深层次的战略合作伙伴关系;
CUUG是唯一一家只做DBA就业培训和oracle认证的授权机构,28年培养数万名oracle技术人才;
CUUG金牌讲师授课,来自一线的资深ORACLE OCM技术专家团队;
CUUG顶尖完善的学习体系,以甲骨文原厂ORACLE数据库核心技术为教学课程;

报名入口 点击进入

课程咨询:400-0909-964

考试咨询:400-0909-964

QQ:点击获取

E-mail:yuezt@cuug.com