Examine the description of the BOOKS_TRANSACTIONS table:

The correct answer is A. WHERE borrowed_date = SYSDATE AND transaction_type = 'RM*) OR member_id IN ('A101', D. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM* OR member_id IN ('A101'. See the full explanation below for the reasoning.

SQL and PL/SQL

Question

Exhibit

Options

AWHERE borrowed_date = SYSDATE AND transaction_type = 'RM*) OR member_id IN ('A101',
BWHERE borrowed_date = SYSDATE AND {transaction_type = 'RM* AND (raeraber_id =
CWHERE borrowed_date = SYSDATE AND (transaction_ype = 'RM' AND .-neraber_id = 'A101' OR
DWHERE borrowed_date = SYSDATE AND (transaction_type = 'RM* OR member_id IN ('A101',

How the community answered

(27 responses)

A
81% (22)
B
11% (3)
C
7% (2)

Topics

#operator precedence#AND OR logic#WHERE clause#IN clause

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice