单选题
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?（）
发布日期：2020-04-10
UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S%
UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item LIKE S%
UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE 'S%'
UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S%
标签： table definition stock item varchar
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在
CMS专题
CMS专题
其他考试
Koeppe结节
激励和约束的关系是（）。
柴油机比汽油机的经济性好。
com.sgcc.uap.core.utils.exception.StringUtilsException是哪种异常（）
根据《特困人员认定办法》规定，应当认定为本办法所称的无劳动能力的指下列（ ）情形；
风心病主动脉瓣狭窄可引起（）
证券金融公司可以根据化解证券公司违约风险的需要，建立（ ）。
蛛网膜下腔出血的主要CT表现是（ ）
强迫非共振法是研究（）性能有效、普遍、重要的方法。
简述自然美的分类情况。
暂无相关推荐~
Given the following table definition: STOCK: item VARCHAR(30) status CHAR(1) qua...
You need to change the definition of an existing table. The COMMERCIALS table ne...
You need to change the definition of an existing table. The COMMERCIALS table ne...
You need to change the definition of an existing table. The COMMERCIALS table ne...
You need to change the definition of an existing table. The COMMERCIALS table ne...
Since the good sare（）stock，they cannot be supplied（）stock.
Zero stock is the best way for（）
Zero stock is the best way for（）
_____ to get a definition for this word!
Definition of Length：（）