A.一个UPDATE命令一次只能对一个表进行修改
B.一个UPDATE命令同时能对多个表进行修改
C.UPDATE命令不能对表进行修改
D.以上说法均不正确
第1题
A:DELETE FROM Student WHERE生日Between #80-01-01#And#80-12-31#
B:DELETE FROM Student WHERE生日Between("80-01-01"And"80-12-31")
C:DELETE FROM Student WHERE生日Between("80.01.01"And"80.12.31")
D:DELETE FROM Student WHERE生日Between #80.01.01#And#80.12.31#
第3题
A:INSERT INTO Teacher(编号,职称)VALUES("070041","助教")
B:INSERT INTO Teacher("070041","助教")VALUES(编号,职称)
C:INSERT INTO VALUES(编号,职称)Teacher("070041","助教")
D:INSERT INTO VALUES("070041","助教")Teacher(编号,职称
第4题
A:DELETE FROM Teacher WHERE编号="070041"
B:DELETE FROM Teacher 编号="070041"
C:DELETE编号="070041"FROMTeacher
D:DELETE FROM Teacher WHERE编号IS"070041"
第5题
A:UPDATE Teacher SET职称="助教"WHERE职称="讲师"
B:UPDATE Teacher SET职称="讲师"WHERE职称="助教"
C:UPDATE SET职称="助教"WHERE职称="讲师"FROMTeacher
D:UPDATE SET职称="讲师"WHERE职称="助教"FROMTeacher
第6题
A:INSERT INTO Teacher VALUES("070044","付强")
B:INSERT INTO Teacher(学号,姓名)
C:INSERT("070044","付强")INTO Teacher
D:INSERT(学号,姓名)INTO Teacher
第7题
A:将Student表中的所有记录的补助均增加1.2
B:将Student表中的当前记录的补助增加1.2
C:将Student表中的所有记录的补助均设置为1.2
D:将Student表中的当前记录的补助设置为1.2
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!