Exam 1z0-082 topic 1 question 124 discussion

Actual exam question from Oracle's 1z0-082

Question #: 124
Topic #: 1

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? (Choose two.)

A. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND member_id = 'A101' OR member_id = 'A102');
B. WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN ('A101', 'A102');
C. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND (member_id = 'A101' OR member_id = 'A102'));
D. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' OR menber_id IN ('A101', 'A102'));
E. WHERE (borrowed_date = SYSDATE AND transaction_type - 'RM') OR member_id IN ('A101', VA102');

Show Suggested Answer

Suggested Answer: BE 🗳️

by piontk at March 14, 2023, 11:15 p.m.

Comments

Submit Cancel

psycrotic5

7 months, 1 week ago

but in E, there are mistake VA102, should be A102, this mistake was done on purpose? or its misstype?

upvoted 2 times

...

The AND operator is evaluated earlier, it has higher priority than the OR operator. B and E examples differ only in parentheses, and those parentheses does not change the priority, because the priority of the AND is higher than the priority of the OR operator.

upvoted 2 times

...

ivanadj

1 year, 4 months ago

Selected Answer: BE

https://www.examtopics.com/discussions/oracle/view/8434-exam-1z0-071-topic-1-question-274-discussion/

upvoted 1 times

...

piontk

1 year, 4 months ago

Selected Answer: BE

BE is the correct answer

upvoted 2 times

...

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam

Exam 1z0-082 topic 1 question 124 discussion

Comments

psycrotic5

nautil2

ivanadj

piontk