Exam 1z0-082 topic 1 question 144 discussion

Actual exam question from Oracle's 1z0-082

Question #: 144
Topic #: 1

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:

Which two WHERE conditions give the required result? (Choose two.)

Show Suggested Answer

Suggested Answer: AB 🗳️

by j_tw at April 13, 2023, 8:25 a.m.

Comments

Submit Cancel

psycrotic5

7 months, 3 weeks ago

AB CORRECT - TESTED

upvoted 2 times

...

nautil2

11 months ago

Selected Answer: B

Only B is correct. Answer A is almost correct, however function ROUND negatively affects condition cust_credit limit < 1000 for customers with credit ranging from 999.50 to 999.99. Their credit is rounded to 1000 and condition < 1000 removes these customers from query results. So these customers are not shown in final results, thought their credit is below 1000. Initial instruction requesting to show customers with credit below 1000 is not fulfilled. Answer A is false. Other answers C,D,E do not return correct results.

upvoted 3 times

...