OCP-1Z0-051-V9.02-102题
来源:互联网 发布:eclipse连不上数据库 编辑:程序博客网 时间:2024/05/16 11:48
102. Examine the structure of the TRANSACTIONS table:
name Null Type
TRANS_ID NOT NULL NUMBER(3)
CUST_NAME VARCHAR2(30)
TRANS_DATE TIMESTAMP
TRANS_AMT NUMBER(10,2)
You want to display the date, time, and transaction amount of transactions that where done before 12
noon. The value zero should be displayed for transactions where the transaction amount has not been
entered.
Which query gives the required result?
A. SELECT TO_CHAR(trans_date,'dd-mon-yyyy hh24:mi:ss'),
TO_CHAR(trans_amt,'$99999999D99')
FROM transactions
WHERE TO_NUMBER(TO_DATE(trans_date,'hh24')) < 12 AND COALESCE(trans_amt,NULL)<>NULL;
B. SELECT TO_CHAR(trans_date,'dd-mon-yyyy hh24:mi:ss'),
NVL(TO_CHAR(trans_amt,'$99999999D99'),0)
FROM transactions
WHERE TO_CHAR(trans_date,'hh24') < 12;
C. SELECT TO_CHAR(trans_date,'dd-mon-yyyy hh24:mi:ss'),
COALESCE(TO_NUMBER(trans_amt,'$99999999.99'),0) 已经是number类型,不需要转换
FROM transactions
WHERE TO_DATE(trans_date,'hh24') < 12;
D. SELECT TO_DATE (trans_date,'dd-mon-yyyy hh24:mi:ss'),
NVL2(trans_amt,TO_NUMBER(trans_amt,'$99999999.99'), 0) 已经是number类型,不需要转换
FROM transactions
WHERE TO_DATE(trans_date,'hh24') < 12;
Answer: B
答案解析:
A,TO_DATE(trans_date,'hh24'),trans_date已经为日期类型,不用再to_date
B,正确,这里0隐式转换为字符型
C,(TO_NUMBER(trans_amt,'$99999999.99'),trans_amt已经是数值型,不用再to_number
D,错误同C一样。
- OCP-1Z0-051-V9.02-102题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-11题
- OCP-1Z0-051-V9.02-12题
- OCP-1Z0-051-V9.02-14题
- OCP-1Z0-051-V9.02-15题
- OCP-1Z0-051-V9.02-17题
- OCP-1Z0-051-V9.02-18题
- OCP-1Z0-051-V9.02-21题
- OCP-1Z0-051-V9.02-118题
- OCP-1Z0-051-V9.02-120题
- OCP-1Z0-051-V9.02-32题
- OCP-1Z0-051-V9.02-33题
- OCP-1Z0-051-V9.02-93题
- OCP-1Z0-051-V9.02-94题
- OCP-1Z0-051-V9.02-95题
- Visio 2003 图形剪切合并 高级技巧
- mysql 批量插数据到数据库以及返回插入生成的id号
- 少计较,多宽容,知满足,心也就闲了
- 基于TCP/IP协议的Socket JAVA编程
- [google面试CTCI] 1-7.将矩阵中特定行、列置0
- OCP-1Z0-051-V9.02-102题
- 算法习题21:输入两个整数 n 和 m,从数列1,2,3.......n 中 随意取几个数,找出和为m
- Linux 常用命令
- TCP报文段首部格式详解
- Android 第三方应用接入微信平台研究情况分享
- MFC 文档视图学习笔记----list控件标题乱码解决办法
- ubuntu 13.10 android ia32-libs 不能安装解决方法
- UBIFS介绍 - MTD网站
- 验证多个孩子进程进程socketpair竞争读