Oracle
1Z0-071 · Question #202
Examine the structure of the BOOKS_TRANSACTIONS table. You want to update this table such that BOOK_ID is set to 'INVALID' for all rows where no MEMBER_ID has been entered. Examine this partial SQL…
The correct answer is C. MEMBER_ID IS NULL. See the full explanation below for the reasoning.
Question
Examine the structure of the BOOKS_TRANSACTIONS table. You want to update this table such that BOOK_ID is set to 'INVALID' for all rows where no MEMBER_ID has been entered. Examine this partial SQL statement:
Which condition must be used in the WHERE clause to perform the required update?
Exhibits
Options
- AMEMBER_ID = '';
- BMEMBER_ID = NULL;
- CMEMBER_ID IS NULL;
- DMEMBER_ID = "";
How the community answered
(36 responses)- A6% (2)
- B14% (5)
- C78% (28)
- D3% (1)
Community Discussion
No community discussion yet for this question.