Given the following table:
STOCK
————————–
CATEGORY CHAR(1)
PARTNO CHAR(12)
DESCRIPTION VARCHAR(40)
QUANTITY INTEGER
PRICE DEC(7,2)
If items are indicated to be out of stock by setting DESCRIPTION to NULL and QUANTITY and PRICE to zero, which of the following statements updates the STOCK table to indicate that all items except those with CATEGORY of ‘S’ are temporarily out of stock?
A. UPDATE stock SET description = ‘NULL’, quantity = 0, price = 0 WHERE category ‘S’
B. UPDATE stock SET description = NULL, SET quantity = 0, SET price = 0 WHERE category ‘S’
C. UPDATE stock SET (description, quantity, price) = (‘null’, 0, 0) WHERE category ‘S’
D. UPDATE stock SET (description, quantity, price) = (NULL, 0, 0) WHERE category ‘S’
|
Download Printable PDF. VALID exam to help you PASS. |
 |