Oracle Exam 1Z0-082 Topic 17 Question 94 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 94
Topic #: 17

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_name, cust_credit_limit FROM customers

Which two where conditions give the required result?

AOption A

BOption B

COption C

DOption D

EOption E

Show Suggested Answer

Suggested Answer: C, E

by Refugia at May 28, 2024, 10:02 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-082 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Ramonita

5 months ago

Hey, at least they didn't ask us to find the customers with last names starting with Z. That would be a real credit limit!

upvoted 0 times

...

Mickie

5 months ago

I bet the person who wrote this question was having a hard time coming up with options that weren't completely obvious. Option D is the way to go.

upvoted 0 times

...

Ivette

5 months ago

A and B, huh? I guess the exam writers are really trying to cover all the bases. Option D it is.

upvoted 0 times

Doyle

4 months ago

I agree, let's go with Option D.

upvoted 0 times

...

Malcolm

4 months ago

I think Option D is the correct choice.

upvoted 0 times

...

Phuong

6 months ago

C'mon, this is too easy. Option D is clearly the answer. I could write this query with my eyes closed.

upvoted 0 times

Rossana

5 months ago

Definitely, Option D is the answer. It's a basic query to select the required data.

upvoted 0 times

...

Aretha

5 months ago

Yeah, Option D is the way to go. It's straightforward and meets all the criteria.

upvoted 0 times

...

Herminia

6 months ago

I agree, Option D is the correct answer. It's a simple query to filter the results.

upvoted 0 times

...

Fanny

6 months ago

Option D looks good to me. It checks for last names starting with A or B and credit limits below 1000.

upvoted 0 times

Rodrigo

5 months ago

Yes, Option D is the correct choice for filtering customers with last names starting with A or B and credit limits below 1000.

upvoted 0 times

...

Eura

6 months ago

I agree, Option D covers the conditions we need for the query.

upvoted 0 times

...

Gaston

6 months ago

Yes, Option D is the correct choice for filtering customers with last names starting with A or B and credit limits below 1000.

upvoted 0 times

...

Sanda

6 months ago

I agree, Option D covers the conditions we need for the query.

upvoted 0 times

...

Polly

6 months ago

I agree with you, Louvenia. Option A filters by last name starting with A or B, and option C filters by credit limit below 1000.

upvoted 0 times

...

Louvenia

7 months ago

I think option A and option C could be the correct choices.

upvoted 0 times

...