ocp 11gÈÏÖ¤¿¼ÊÔÌ⣺1Z0-051-054Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

54. View the Exhibit and examine the structure of the CUSTOMERS table.

Evaluate the query statement:

SQL> SELECT cust_last_name, cust_city, cust_credit_limit

FROM customers

WHERE cust_last_name BETWEEN 'A' AND 'C' AND cust_credit_limit BETWEEN

1000 AND 3000;

What would be the outcome of the above statement?

A. It executes successfully.

B. It produces an error because the condition on CUST_LAST_NAME is invalid.

C. It executes successfully only if the CUST_CREDIT_LIMIT column does not contain any null values.

D. It produces an error because the AND operator cannot be used to combine multiple BETWEEN clauses.

Answer: A