单项选择题
根据关系模型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职称="助教"WHERE职称="讲师"
B:UPDATE Teacher SET职称="讲师"WHERE职称="助教"
C:UPDATE SET职称="助教"WHERE职称="讲师"FROMTeacher
D:UPDATE SET职称="讲师"WHERE职称="助教"FROMTeacher -
单项选择题
删除表Teacher中编号为070041的记录,应为()
A:DELETE FROM Teacher WHERE编号="070041"
B:DELETE FROM Teacher 编号="070041"
C:DELETE编号="070041"FROMTeacher
D:DELETE FROM Teacher WHERE编号IS"070041" -
单项选择题
根据关系模型Teacher(编号,职称)下列SQL语句正确的是()
A:INSERT INTO Teacher(编号,职称)VALUES("070041","助教")
B:INSERT INTO Teacher("070041","助教")VALUES(编号,职称)
C:INSERT INTO VALUES(编号,职称)Teacher("070041","助教")
D:INSERT INTO VALUES("070041","助教")Teacher(编号,职称
