1. Home
  2. Discussions
  3. Oracle
  4. Oracle PL
  5. 1z0-071 Discussions
  6. 1z0-071 Exam Topic 6 Question 58 Discussion

Oracle Database 12c SQL 1z0-071 Question # 58 Topic 6 Discussion

 Oracle Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Oracle Database 12c SQL 1z0-071 Question # 58 Topic 6 Discussion

1z0-071 Exam Topic 6 Question 58 Discussion:
Question #: 58
Topic #: 6

Examine the description of the CUSTOMERS table:

1z0-071 Question 58

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) ;

Get Premium 1z0-071 Questions
Actual exam question for Oracle 1z0-071 exam by Zephyr30580 at Aug 3, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next