Oracle
1Z0-071 · Question #213
1Z0-071 Question #213: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #213. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the structure of the CUSTOMERS table. You want to generate a report showing the last names and credit limits of all customers whose last names start with A, B, or C, and credit limit is below 10,000. Evaluate the following two queries: SQL> SELECT cust_last_name, cust_credit_limit FROM customers WHERE (UPPER(cust_last_name) LIKE 'A%' OR UPPER (cust_last_name) LIKE 'B%' OR UPPER (cust_last_name) LIKE 'C%') AND cust_credit_limit < 10000; SQL>SELECT cust_last_name, cust_credit_limit FROM customers WHERE UPPER (cust_last_name) BETWEEN 'A' AND 'C' AND cust_credit_limit < 10000; Which statement is true regarding the execution of the above queries?
Exhibit
Options
- AOnly the second query gives the correct result
- BBoth execute successfully but do not give the required result
- COnly the first query gives the correct result
- DBoth execute successfully and give the same result
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.