Examine the description of the CUSTOMERS table:
Name Null type
-----------------------------------------------------
CUST_ID NOT NULL NUMBER(2)
CUST_LAST_NAME VARCHAR2(30)
CITY VARCHAR2(10)
CUST_CREDIT_LIMIT NUMBER(6,2)
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(INITCAP(cust last namE.LIKE 'A%' OR INITCAP(cust last namE.LIKE 'B%')正确答案AD
AND cust credit limit < 1000 B.WHERE UPPER(cust_1ast_namE.IN ('A%', 'B%' )
AND cust credit limit < 1000 C.WHERE (UPPER(cust last namE.LIKE INITCAP('A') OR UPPER(cust -Last-namE.LIKE
INITCAP('B'))
AND ROUND(cust credit limit)< ROUND(1000)； D.WHERE( UPPER(cust_1ast_namE.LIKE 'A% OR UPPER(Cust_1ast_namE.LINK ‘B%’
AND ROUND(cust credit limit)< 1000 E.WHERE UPPER(cust last namE.BETWEEN UPPER ('A%' AND 'B%' )
AND ROUND(cust credit limit)< 1000
