ocp 11g认证考试题：1Z0-051-060题
ocp 11g认证考试题：1Z0-051-060题，完整题库请点击这里联系老师咨询了解
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列。
精华阅读