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

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

运行上述查询语句

sh@TESTDB> SELECT cust_last_name, cust_city, cust_credit_limit

  2  FROM customers 

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

  4  1000 AND 3000 and rownum<6;

CUST_LAST_NAME                           CUST_CITY                      CUST_CREDIT_LIMIT

---------------------------------------- ------------------------------ -----------------

Aaron                                    Pune                                        1500

Aaron                                    Diss                                        3000

Aaron                                    Hoofddorp                                   1500

Aaron                                    Stockport                                   3000

Aaron                                    Hyderabad                                   1500