Q160 Examine the description of the BOOKS_TRANSACTIONS table

Posted on by Tran Anh

Q160 Examine the description of the BOOKS_TRANSACTIONS table:

Name                                                                                                      Null?                       Type

================================== ===========       ==========================

TRANSACTION_ID                                                                                 NOT NULL              VARCHAR2(6)

TRANSACTION_TYPE                                                                                                            VARCHAR2(3)

BORROWED_DATE                                                                                                                               DATE

BOOK_ID                                                                                                                               VARCHAR2(6)

MEMBER_ID                                                                                                                          VARCHAR2(6)

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’ AND member_id = ‘A101’ OR member_id = ‘A102’);
  • B) WHERE borrowed_date = SYSDATE AND (transaction_type = ‘RM’ AND (member_id = ‘A101’ OR member_id = ‘A102’));
  • C) WHERE borrowed_date = SYSDATE AND (transaction_type = ‘RM’ OR member_id IN (‘A101’,‘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’ OR member_id IN (‘A101’,‘A102’);
Xem thêm:

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

0 0 đánh giá
Đánh giá bài viết
Theo dõi
Thông báo của
guest
0 Góp ý
Phản hồi nội tuyến
Xem tất cả bình luận