赞题库-背景图
单项选择题

删除表s中字段c的SQL命令是

A.ALTER TABLE s DELETE c
B.ALTER TABLE s DROP c
C.DELETE TABLE s DELETE c
D.DELETE TABLE s DROP c
<上一题 目录 下一题>
热门试题

单项选择题设有学生表student(学号,姓名,性别,出生日期,院系)、课程表course(课程号,课程名,学时)和选课表score(学号,课程号,成绩),删除学号为“20091001”且课程号为“C1”的选课记录,正确命令是

A.DELETE FROM score WHERE 课程号="C1" AND 学号="20091001"
B.DELETE FROM score WHERE 课程号="C1" OR 学号="20091001"
C.DELETE FORM score WHERE 课程号="C1" AND 学号="20091001"
D.DELETE score WHERE 课程号="C1" AND 学号="20091001"

单项选择题正确的SQL插入命令的语法格式是

A.INSERT IN...VALUES...
B.INSERT TO...VALUES
C.INSERT INTO...VALUES...
D.INSERT...VALUES...