当前位置: Oracle DBA培训网-优技培训 >> 071题库 >

【071题库】最新OCP-071考试题库解析-第20题

【071题库】最新OCP-071考试题库解析-第20题

071考试是OCP考试科目的一种,由于071考题多变,我们专门收集整理了最新的考试题库,并对这些考题进行讲解,希望可以帮助广大考生。

每周五晚8点,我们有免费的OCP解析公开课,地址:https://ke.qq.com/course/326223  OCP题库交流群:1015267481,验证ocp

-------------------------------------------------------

071题库-第20题、choose the best answer

View the Exhibit and examine the data in the PROMOTIONS table.

PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr.

You need to produce a report that provides the name,cost,and start date of all promos

in the POST category that were launched before January 1, 2000.

Which SQL statement would you use?

A) SELECT promo_name, promo_cost, promo_begin_date

FROM promotions

WHERE promo_category LIKE '%post%' AND promo_begin_date < '1-JAN-00';

B) SELECT promo_name, promo_cost, promo_begin_date

FROM promotions

WHERE promo_category = 'post' AND promo_begin_date < '01-01-00';

C) SELECT promo_name, promo_cost, promo_begin_date

FROM promotions

WHERE promo_cost LIKE 'post%' AND promo_begin_date < '01-01-2000';

D) SELECT promo_name, promo_cost, Promo_begin_date

FROM promotions

WHERE promo_category LIKE 'p%' AND promo_begin_date < '1-JANUARY-00';

Answer:A

(解析:因为日期的默认格式是 dd-mon-yy,所以 January 1, 2000 转换成匹配的格式为

01-jan-00

)

技术沙龙MORE+

Oracle技术沙龙:【数据保护顶尖技术-MAA】首次全国首播12c MAA技术 云数据库加上MAA技术组成最豪华的技...
Oracle技术沙龙第49期:【Oracle 数据库云技术分享】Oracle技术沙龙第49期:【Oracle 数据库云技术分享】本次技术沙...
Oracle技术沙龙第48期:【Oracle 12c RAC安装】小编:今天讲什么内容呢?以后有什么用呢? 大师:今天讲的是12c...
我要参加技术沙龙

关闭