OCP-1Z0-051-V9.02-79题
来源:互联网 发布:淘宝联盟怎么购买省钱 编辑:程序博客网 时间:2024/06/06 09:52
79. View the Exhibit and examine the structure of the CUSTOMERS table.
In the CUSTOMERS table, the CUST_LAST_NAME column contains the values 'Anderson' and 'Ausson'.
You issue the following query:
SQL> SELECT LOWER(REPLACE(TRIM('son' FROM cust_last_name),'An','O'))
FROM CUSTOMERS
WHERE LOWER(cust_last_name) LIKE 'a%n';
What would be the outcome?
A. 'Oder' and 'Aus'
B. a n error because the TRIM function specified is not valid
C. a n error because the LOWER function specified is not valid
D. a n error because the REPLACE function specified is not valid
Answer: B
答案解析:
参考:http://blog.csdn.net/rlhua/article/details/12848395
TRIM:截去字符串首字符或尾字符(或者两者都截去)(如果trim_character或trim_source 是一个字符文字,则必须将其放在单引号内)
实验验证:
sh@TESTDB> select trim('son' from cust_last_name) from customers ;
select trim('son' from cust_last_name) from customers
*
ERROR at line 1:
ORA-30001: trim set should have only one character
sh@TESTDB> select trim('s' from cust_last_name) from customers where rownum<3;
TRIM('S'FROMCUST_LAST_NAME)
----------------------------------------
Ruddy
Ruddy
sh@TESTDB> select trim('sa' from 'saabd') from dual;
select trim('sa' from 'saabd') from dual
*
ERROR at line 1:
ORA-30001: trim set should have only one character
sh@TESTDB> select trim('s' from 'saabd') from dual;
TRIM
----
aabd
- OCP-1Z0-051-V9.02-79题
- 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题
- C嵌入PyThon遇到问题解决方法
- MDK 编译文件大小说明(Program Size)(转)
- word 快捷键
- 黑马程序员_java中的异常
- oracle 解除死锁
- OCP-1Z0-051-V9.02-79题
- Java getPath() getAbsolutePath() getCanonicalPath()区别
- [整理II]精选微软等公司数据结构+算法面试100题 [第41-60题]
- 总结一下可以研究的CAD源代码 .
- EasyUi_学习之路_05
- Structs学习笔记0:Structs与Servlet对比
- 数据流图
- c#/winform 串口编程
- SQL Server2005 不支持一条insert语句插入多条记录