OCP-1Z0-051-V9.02-60题
来源:互联网 发布:mac系统怎么装office 编辑:程序博客网 时间:2024/06/11 13:25
60. View the Exhibit and examine the structure of CUSTOMERS table.
Evaluate the following query:
SQL>SELECT cust_id, cust_city
FROM customers
WHERE cust_first_name NOT LIKE 'A_%g_%' AND
cust_credit_limit BETWEEN 5000 AND 15000 AND
cust_credit_limit NOT IN (7000, 11000) AND
cust_city NOT BETWEEN 'A' AND 'B';
Which statement is true regarding the above query?
A. It executes successfully.
B. It produces an error because the condition on the CUST_CITY column is not valid.
C. It produces an error because the condition on the CUST_FIRST_NAME column is not valid.
D. It produces an error because conditions on the CUST_CREDIT_LIMIT column are not valid.
Answer: A
答案解析:
实验环境得出结果,可以正常执行。
此表在数据库的sh用户里。连接到sh用户,然后查询。因为满足条件的数量很多,故用rownum列出前5列。
sh@TESTDB> SELECT cust_id, cust_city
2 FROM customers
3 WHERE cust_first_name NOT LIKE 'A_%g_%' AND
4 cust_credit_limit BETWEEN 5000 AND 15000 AND
5 cust_credit_limit NOT IN (7000, 11000) AND
6 cust_city NOT BETWEEN 'A' AND 'B'
7 AND ROWNUM<6;
CUST_ID CUST_CITY
---------- ------------------------------
36117 Wolverhampton
25470 Stuttgart
4117 Clermont-l'Herault
14784 Belfast City
25451 Heilbronn
- OCP-1Z0-051-V9.02-60题
- 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题
- 完美的解决如何让AsyncTask终止操作
- 深入浅出CChart 每日一课——第十六课 实习之旅,百年老店之新锐WTL
- Matlab在微积分中的应用
- Linux关闭防火墙命令
- AsyncTask的缺陷
- OCP-1Z0-051-V9.02-60题
- 2013杭电warm up1 Rotation Lock Puzzle
- Java SE学习笔记-Java基础语法
- VS2005中关于char[]转换成LPCWSTR的问题
- Ubuntu kill命令用法详解
- New/delete malloc/free
- Ubuntu的apt命令详解
- 云计算运维与传统运维的探讨
- 【leetcode】Remove Nth Node From End of List