皮皮学，免费搜题
登录
搜题
【单选题】
Given the following table definition: STOCK: item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2) If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter "S" are out of stock?（）A.
UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S%
B.
UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item LIKE S%
C.
UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE 'S%'
D.
UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S%
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【简答题】3W（World Wide Web）的中文名称是（）。
【简答题】W3C是指World Wide Web Consortium,中文意思是(__)。[请填写五个中文汉字]
相关题目：