OCP-1Z0-新051-61题版本-55
来源:互联网 发布:linux ssh修改文件内容 编辑:程序博客网 时间:2024/05/19 19:41
QUESTION NO: 55
You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:
Which two SQL statements would execute successfully? (Choose two.)
A.
UPDATE promotions
SET promo_cost = promo_cost+ 100
WHERE TO_CHAR(promo_end_date, 'yyyy') > '2000';
B.
SELECT promo_begin_date
FROM promotions
WHERE TO_CHAR(promo_begin_date,'mon dd yy')='jul 01 98';
C.
UPDATE promotions
SET promo_cost = promo_cost+ 100
WHERE promo_end_date > TO_DATE(SUBSTR('01-JAN-2000',8));
D.
SELECT TO_CHAR(promo_begin_date,'dd/month')
FROM promotions
WHERE promo_begin_date IN (TO_DATE('JUN 01 98'), TO_DATE('JUL 01 98'));
Answer: A,B
答案解析:
参考:91:http://blog.csdn.net/rlhua/article/details/12071263
Explanation:
- OCP-1Z0-新051-61题版本-55
- OCP-1Z0-新051-61题版本-61
- OCP-1Z0-新051-61题版本-1
- OCP-1Z0-新051-61题版本-2
- OCP-1Z0-新051-61题版本-3
- OCP-1Z0-新051-61题版本-4
- OCP-1Z0-新051-61题版本-5
- OCP-1Z0-新051-61题版本-6
- OCP-1Z0-新051-61题版本-7
- OCP-1Z0-新051-61题版本-8
- OCP-1Z0-新051-61题版本-9
- OCP-1Z0-新051-61题版本-10
- OCP-1Z0-新051-61题版本-11
- OCP-1Z0-新051-61题版本-12
- OCP-1Z0-新051-61题版本-13
- OCP-1Z0-新051-61题版本-14
- OCP-1Z0-新051-61题版本-15
- OCP-1Z0-新051-61题版本-16
- 【深入Java虚拟机】之二:Class类文件结构
- OCP-1Z0-新051-61题版本-54
- 【C#】AviFile使用
- JPQL语法总结
- Network Component Analysis(NCA)
- OCP-1Z0-新051-61题版本-55
- OCP-1Z0-新051-61题版本-56
- 有无奈有快乐的银行系统----My Love.
- JDK 压力测试工具——jps、jinfo、jstat、jmap、jconsole
- Sql Server 获取、增加、修改、删除 字段描述
- SQL 中exists的用法
- OCP-1Z0-新051-61题版本-57
- 用QTP调用VB6生成的DLL实例
- OCP-1Z0-新051-61题版本-58