Q51 Examine the description of the customers table

Q51 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:

SELECT cust_last_name, cust_credit_limit FROM customers Which two where conditions give the required result?

• (A). WHERE (UPPER(cust_last_name) LIKE INITCAP(‘A’) OR UPPER(cust_last_name) LIKE INITCAP(‘B’)) AND ROUND(cust_credit_limit) < ROUND(1000);
• (B). WHERE UPPER(cust_last_name) BETWEEN UPPER(‘A%’ AND ‘B%’) AND ROUND(cust_credit_limit) < 1000;
• (C). WHERE UPPER(cust_last_name) IN (‘A%’, ‘B%’) AND cust_credit_limit < 1000;
• (D). WHERE (UPPER(cust_last_name) LIKE ‘A%’ OR UPPER(cust_last_name) LIKE ‘B%’) AND ROUND(cust_credit_limit) < 1000;
• (E). WHERE (INITCAP (cust_last_name) LIKE ‘A%’ OR INITCAP(cust_last_name) LIKE ‘B%’) AND cust_credit_limit < 1000;