Oracle Exam 1Z0-071 Topic 7 Question 84 Discussion

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

Question #: 84
Topic #: 7

[All 1Z0-071 Questions]

Examine the description of the BOOKS_TRANSACTIONS table:

Examine this partial SQL statement:

SELECT * FROM books_transactions

Which two WHERE conditions give the same result?

AWHERE (borrowed_date = SYSDATE AND transaction_type = 'RM') OR member_id IN ('A101','A102');

BWHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN('A101','A102');

CWHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN('A101','A102');

DWHERE borrowed_date = SYSDATE AND transaction_type = 'RM' AND (member_id = 'A101' OR member_id = 'A102'));

EWHERE borrowed_date = SYSDATE AND transaction_type = 'RM' AND member_id = 'A101' OR member_id = 'A102');

Show Suggested Answer

Suggested Answer: A, C

by Marti at Dec 24, 2023, 12:50 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Katina

2 months ago

Wait, are we talking about books or transactions? I thought this was a test on stand-up comedy!

upvoted 0 times

Annelle

13 days ago

Elmer: I believe options B and C both give the same result.

upvoted 0 times

...

Elmer

14 days ago

User 2: Oh, I see. So, which WHERE conditions do you think give the same result?

upvoted 0 times

...

Carlee

20 days ago

User 1

upvoted 0 times

...

Freeman

28 days ago

User 2

upvoted 0 times

...

Merilyn

1 months ago

User 1

upvoted 0 times

...

Angella

1 months ago

User 1: I think we're discussing SQL statements for a table called BOOKS_TRANSACTIONS.

upvoted 0 times

...

Franklyn

2 months ago

Option D, no doubt! It's the only one that uses proper parentheses for the OR conditions.

upvoted 0 times

...

Barney

2 months ago

Hold on, is this a trick question? I'm going to have to stare at this table for a while to figure it out.

upvoted 0 times

...

Veronique

2 months ago

I'm not sure about that. I think the correct answers are B and D.

upvoted 0 times

...

Glory

2 months ago

I agree with you, Frank. Both A and B will give the same result.

upvoted 0 times

...

Frank

2 months ago

I think the correct answers are A and B.

upvoted 0 times

...

Gladys

2 months ago

I'm going with Option B. It's a bit more concise and still gives the same result.

upvoted 0 times

Cherry

1 months ago

User 2

upvoted 0 times

...

Gladys

1 months ago

User 1

upvoted 0 times

...

Abel

2 months ago

Yeah, Option B seems to be the most straightforward choice.

upvoted 0 times

...

Otis

2 months ago

I think Option B is the correct one.

upvoted 0 times

...

Aleisha

2 months ago

I'm not sure, but I think option D could also be correct.

upvoted 0 times

...

Jackie

2 months ago

Option C looks good to me. The conditions are clear and straightforward.

upvoted 0 times

Nicolette

23 days ago

I see your point, option D does seem to be more precise in its conditions.

upvoted 0 times

...

Rodolfo

27 days ago

Actually, I believe option D is the correct one. It uses the AND operator for the member_id conditions.

upvoted 0 times

...

Gary

1 months ago

I agree with you, option A is the correct choice.

upvoted 0 times

...

Elden

1 months ago

I think option A is correct. It includes both conditions in parentheses.

upvoted 0 times

...

Tora

2 months ago

I agree with Wilford, option A seems to be the right choice.

upvoted 0 times

...

Wilford

3 months ago

I think the correct answer is A.

upvoted 0 times

...