Chinaunix首页 | 论坛 | 博客
  • 博客访问: 600237
  • 博文数量: 487
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 4916
  • 用 户 组: 普通用户
  • 注册时间: 2018-07-05 13:59
个人简介

ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291

文章分类

全部博文(487)

文章存档

2023年(37)

2021年(151)

2020年(37)

2019年(222)

2018年(38)

我的朋友

分类: Oracle

2019-02-26 16:06:53

38.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


)

阅读(973) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~