ocp 11g題庫(kù)詳解：1Z0-051-060題，完整題庫(kù)請(qǐng)點(diǎn)擊這里聯(lián)系老師咨詢了解

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í)驗(yàn)環(huán)境得出結(jié)果，可以正常執(zhí)行。

此表在數(shù)據(jù)庫(kù)的sh用戶里。連接到sh用戶，然后查詢。因?yàn)闈M足條件的數(shù)量很多，故用rownum列出前5列。