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.
Why is Answer A? How is the condition on CUST_CITY column valid?
try it on you oracle
no its not right we can’t use between with character strings.
Just tried and it worked so you could use the between operator on character strings so A is correct.