1Z0-051 practice - PrepKeys

Q1 Single choice

View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the query statement:

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.