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列。 [email protected]> 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