Examice

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

Go to Exam

Question 206

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' 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' OR member_id IN ('A101', 'A102');

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

Correct Answer: B, E

The two WHERE conditions that give the same result are those that correctly account for the logical grouping of the conditions. Option B correctly groups the member_id conditions with parentheses, ensuring that both member_id conditions must be true when transaction_type is 'RM'. Option E groups the borrowed_date and transaction_type conditions together and then uses OR for the member_id condition, ensuring the logic aligns correctly. Both will yield the same result.

Discussion

yaya32Options: CE

I think CE is correct

lucemqyOptions: CE

CE is correct