Answer Happy

A table named INVENTORY was created by executing the SQL statement shown below:CREATE TABLE inventory (part_no INTEGER, quantity INTEGER, price DECIMAL(7,2), status CHAR(2));If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY to zero, which SQL statement updates the INVENTORY table to indicate that all items with part numbers below 150 are out of stock?

A. UPDATE inventory SET status = 'NULL', quantity = 0 WHERE part_no < 150
B. UPDATE inventory SET status = NULL, SET quantity = 0 WHERE part_no < 150
C. UPDATE inventory SET (status, quantity) = ('NULL', 0) WHERE part_no < 150
D. UPDATE inventory SET (status, quantity) = (NULL, 0) WHERE part_no < 150