Which statement is true regarding the following query?

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?

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.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


user

user

Why is Answer A? How is the condition on CUST_CITY column valid?

Ben

Ben

try it on you oracle

palash

palash

no its not right we can’t use between with character strings.

Suh

Suh

Just tried and it worked so you could use the between operator on character strings so A is correct.