单项选择题
A:将Student表中的所有记录的补助均增加1.2 B:将Student表中的当前记录的补助增加1.2 C:将Student表中的所有记录的补助均设置为1.2 D:将Student表中的当前记录的补助设置为1.2
根据关系模型Teacher(编号,姓名),下列语句能完成插入一条新记录的是()A:INSERT INTO Te...
单项选择题根据关系模型Teacher(编号,姓名),下列语句能完成插入一条新记录的是()
A:INSERT INTO Teacher VALUES("070044","付强") B:INSERT INTO Teacher(学号,姓名) C:INSERT("070044","付强")INTO Teacher D:INSERT(学号,姓名)INTO Teacher
将表Teacher中职称字段为"助教"人员改为"讲师",应为()A:UPDATE Teacher SET职称=...
单项选择题将表Teacher中职称字段为"助教"人员改为"讲师",应为()
A:UPDATE Teacher SET职称="助教"WHERE职称="讲师" B:UPDATE Teacher SET职称="讲师"WHERE职称="助教" C:UPDATE SET职称="助教"WHERE职称="讲师"FROMTeacher D:UPDATE SET职称="讲师"WHERE职称="助教"FROMTeacher
删除表Teacher中编号为070041的记录,应为()A:DELETE FROM Teacher WHERE...
单项选择题删除表Teacher中编号为070041的记录,应为()
A:DELETE FROM Teacher WHERE编号="070041" B:DELETE FROM Teacher 编号="070041" C:DELETE编号="070041"FROMTeacher D:DELETE FROM Teacher WHERE编号IS"070041"