Which of the following statements regarding the UPDATE command is not correct?​单项选择题

A

The UPDATE clause identifies the table containing the record(s) to be changed.

B

The SET clause is used to identify the column(s) to be changed, and the new value(s) to be assigned to that column.

C

The UPDATE command can perform the update for only one record at a time.

D

The optional WHERE clause identifies the specific row(s) to be changed by the UPDATE command.

登录即可查看完整答案

我们收录了全球超50000道真实原题与详细解析,现在登录,立即获得答案。

类似问题

The correct SQL code to complete the task of giving all staff a 2% salary increase is __.

Candy Database            Candy  ( CandyType char(15),                Cost dec(9,2),                Colour char(10))   People ( Personname char(20),                Age smallint,               Suburb char(20),                  PhoneNumber char(10))   Likes   ( Personname char(20),               CandyType char(15))   Choose the SQL query that will answer the following question using the Candy Database. Update the cost of candy by an additional $2.50, where the last part of the name is the word Nougat ?  

Candy Database            Candy  ( CandyType char(15),                Cost dec(9,2),                Colour char(10))   People ( Personname char(20),                Age smallint,                  Suburb char(20),                  PhoneNumber char(10))   Likes   ( Personname char(20),               CandyType char(15))   Choose the SQL query that will answer the following question using the Candy Database. Update the cost of candy by reducing $1.50, where the first part of the name is the word Caramel ?

What happens if you omit the WHERE clause in an UPDATE statement?

更多留学生实用工具

加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！