OCP-1Z0-051-V9.02-60题

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