多做题,通过考试没问题!

IBM认证考试

睦霖题库>其他计算机考试>IBM认证考试

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%
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题