Examine the description of the CUSTOMERS table:
You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit is below 1000.
Examine this partial query:
Which two WHERE conditions give the required result? (Choose two.)
The correct query needs to handle both conditions: the last name starting with letters A or B in any case, and the credit limit being less than 1000. Option A uses the UPPER function to handle different letter cases and uses LIKE with wildcard %, which is correct for string matching. It also ensures that the credit limit is less than 1000. Option B uses INITCAP, which is meant to capitalize the first letter of each word, but for string matching here, it should ideally function well enough with the LIKE operator and correct credit limit condition. Both options A and B handle the required conditions for selecting the last names starting with A or B and their credit limits correctly.
Why is not AB? I know that '%' is only used in LIKE operator. Doesn't it?
AB CORRECT - TESTED
Only B is correct. Answer A is almost correct, however function ROUND negatively affects condition cust_credit limit < 1000 for customers with credit ranging from 999.50 to 999.99. Their credit is rounded to 1000 and condition < 1000 removes these customers from query results. So these customers are not shown in final results, thought their credit is below 1000. Initial instruction requesting to show customers with credit below 1000 is not fulfilled. Answer A is false. Other answers C,D,E do not return correct results.
Provided answer are wrong! The base! Part IX! :-)
Correct Answer AB