Q48 Examine the description of the BOOKS_TRANSACTIONS table

Posted on 28/10/202406/03/2025 by Tran Anh

Q48 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?

A. WHERE borrowed_date = SYSDATE AND (transaction_type = ‘RM’ OR member_id IN (‘A101’, ‘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 member_id IN (‘A101’, ‘A102’);
E. WHERE borrowed_date = SYSDATE AND (transaction_type = ‘RM’ AND member_id = ‘A101’ OR member_id = ‘A102’);

Xem thêm:

Bài viết cùng chủ đề:

0 0 đánh giá

Đánh giá bài viết

Theo dõi

0 Góp ý

Phản hồi nội tuyến

Xem tất cả bình luận