【单选题】设员工表中有工号(文本型)和部门(文本型)等字段,将所有工号以Y打头的员工部门改为“运营部”,正确的SQL语句是( )。
A.
UPDATE 工号="Y*" SET 部门="运营部"
B.
UPDATE 员工 WHERE 部门="运营部" WHERE 工号 Like "Y%"
C.
UPDATE 员工 SET 部门="运营部" WHERE 工号 Like "Y*"
D.
UPDATE 员工 SET 部门="运营部" WHERE 工号 Like "Y%"
【单选题】工厂里的所有设备都是中国制造的。
A.
All the equipment in the factory is made China.
B.
All the equipment in the factory are made in China.
C.
All the equipment in the factory is made in China.
D.
All the equipment in the factory are made China.
【单选题】设“员工”表中有“工号”(文本型)和“部门”(文本型)等字段,将所有工号以“Y”打头的员工部门改为“运营部”,正确的SQL语句是()。
A.
Update 员工 Set 部门="运营部" Where 工号 Like "Y%"
B.
Update 工号="Y*" Set 部门="运营部"
C.
Update 员工 Where 部门="运营部" Where 工号 Like "Y%"
D.
Update 员工 Set 部门="运营部" Where 工号 Like "Y*"
【单选题】设员工表中有工号(文本型)等字段,删除所有工号第2、3位为18的员工信息,正确的SQL语句是( )。
A.
DELETE FROM 员工 WHERE 工号 Like "%18*"
B.
DELETE FROM 员工 WHERE 工号 Like "*18*"
C.
DELETE FROM 员工 WHERE 工号 Like "*18%"
D.
DELETE FROM 员工 WHERE 工号 Like "%18%"