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%

17 days ago

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

upvoted 0 times

16 hours ago

I think Option B is the correct one.

upvoted 0 times

...

18 days ago

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

upvoted 0 times

...

21 days ago

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

upvoted 0 times

...

22 days ago

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

upvoted 0 times

...

30 days ago

I think the correct answer is A.

upvoted 0 times

...