Examice

Exam 1z0-082 All QuestionsBrowse all questions from this exam

Go to Exam

Question 124

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.)

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

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

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

WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' OR menber_id IN ('A101', 'A102'));

WHERE (borrowed_date = SYSDATE AND transaction_type - 'RM') OR member_id IN ('A101', VA102');

Correct Answer: A, C

The conditions that will give the same result must ensure they constrain the results based on the logical grouping of the AND and OR operators. In options A and C, the parentheses ensure that the logical groupings are preserved correctly. Option A states that borrowed_date must be SYSDATE, transaction_type must be 'RM', and member_id must be either 'A101' or 'A102', which is logically equivalent to option C where the parentheses also ensure the same AND/OR evaluation order. Hence, both options A and C provide the same result.

Discussion

nautil2Options: BE

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.

piontkOptions: BE

BE is the correct answer

psycrotic5

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

ivanadjOptions: BE

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