Oracle
1Z0-071 · Question #307
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.)
The correct answer is B. WHERE (borrowed_date = SYSDATE AND transaction_type = `RM') OR member_id IN (`A101', C. WHERE borrowed_date = SYSDATE AND (transaction_type = `RM' AND (member_id = A101'. See the full explanation below for the reasoning.
Question
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.)
Exhibit
Options
- AWHERE borrowed_date = SYSDATE AND (transaction_type =
RM' OR member_id IN (A101', - BWHERE (borrowed_date = SYSDATE AND transaction_type =
RM') OR member_id IN (A101', - CWHERE borrowed_date = SYSDATE AND (transaction_type = `RM' AND (member_id = A101'
- DWHERE borrowed_date = SYSDATE AND transaction_type =
RM' OR member_id IN (A101', - EWHERE borrowed_date = SYSDATE AND (transaction_type =
RM' AND member_id =A101'
How the community answered
(48 responses)- A10% (5)
- B83% (40)
- D4% (2)
- E2% (1)
Community Discussion
No community discussion yet for this question.