题目内容

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%

查看答案
更多问题

()是植被的基本单元。

A. 植物群系
B. 植物群丛
C. 植物群落
D. 植物种群

GK1F机车电瓶组为串联接法()

A. 正确
B. 错误

核仁中存在的生物成分为:()

A. rDNA
B. 28SrRNA
C. 16SrRNA
D. RNA聚合酶Ⅱ
E. RNA聚合酶Ⅰ

被誉为“行政学的先驱”的是()

A. 威尔逊
B. 马克斯·韦伯
C. 泰罗
D. 古立克

答案查题题库