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;
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.
答案:A
解析:'A' 'C'这种字符型的判断应该走的是ascii码,因此该语句是正确的
SQL> select 1 from dual where '_' between 'A' and 'a';
1
----------
1
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?
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.
答案:A
解析:'A' 'C'这种字符型的判断应该走的是ascii码,因此该语句是正确的
SQL> select 1 from dual where '_' between 'A' and 'a';
1
----------
1