Oracle Database SQL 12c 1z0-071 Exam Practice Test 3

Question : 6 of 50

Marks: +1, -0

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?

MEMBER_ID = '';
MEMBER_ID = NULL;
MEMBER_ID IS NULL;
MEMBER_ID = "";

Validate

Go to Question:

Prev Question

Next Question