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

5 days ago

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

upvoted 0 times

...

Franklyn

7 days ago

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

upvoted 0 times

...

Barney

9 days 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

19 days ago

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

upvoted 0 times

...

Glory

21 days ago

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

upvoted 0 times

...

Frank

23 days ago

I think the correct answers are A and B.

upvoted 0 times

...

Gladys

23 days ago

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

upvoted 0 times

Abel

6 days ago

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

upvoted 0 times

...

Otis

7 days ago

I think Option B is the correct one.

upvoted 0 times

...

Aleisha

24 days ago

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

upvoted 0 times

...

Jackie

27 days ago

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

upvoted 0 times

...

Tora

28 days ago

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

upvoted 0 times

...

Wilford

1 months ago

I think the correct answer is A.

upvoted 0 times

...