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?
A. MEMBER_ID = ”;
B. MEMBER_ID = NULL;
C. MEMBER_ID IS NULL;
D. MEMBER_ID = "";
|
Download Printable PDF. VALID exam to help you PASS. |
 |
C