1z0-071 Exam Dumps | Examine the description of the CUSTOMERS table: (Exhibit) You need to display last names and credit limits

<< Prev Question Next Question >>

Question 62/144

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_nare, cust_credit_limit FROM customers
Which two WHERE conditions give the required result?

A. WHERE UPPER(cust_last_name) IN ('A%', 'B%') AND cust_credit_limit < 1000:

B. WHERE (INITCAP(cust_last_name) LIKE 'A%' OR ITITCAP(cust_last_name) LIKE 'B%') AND cust_credit_limit < 1000

C. WHERE UPPER(cust_last_name) BETWEEN UPPER('A%' AND 'B%') AND ROUND(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 (UPPER(cust_last_name) like INITCAP ('A') OR UPPER(cust_last_name) like INITCAP('B')) AND ROUND(cust_credit_limit) < ROUND(1000) ;

Question 62/144

LEAVE A REPLY

Download PDF File