设有学生表 student(sno,sname,sage,smajor) ,各字段的含义分别是学生学号、姓名、年龄和专业。要 求输入一学生记录,学号为 100,姓名为张红,年龄为 20。以下不能完成如上输入要求的语句是 ______。
A.INSERT INTO student VALUES(100," 张红 ",20) ;
B.INSERT INTO student(sno,sname,sage,smajor) VALUES(100," 张红 ",20,NULL) ;
C.INSERT INTO student VALUES(100," 张红 ",20,NULL) ;
D.INSERTINTO student(sno,sname,sage) VALUES(100," 张红 ",20) ;
查看答案
正确答案: A 答案分析:无
包含此试题的试卷:
相关的试题
A.INSERT INTO student VALUES(100," 张红 ",20) ;
B.INSERT INTO student(sno,sname,sage,smajor) VALUES(100," 张红 ",20,NULL) ;
C.INSERT INTO student VALUES(100," 张红 ",20,NULL) ;
D.INSERTINTO student(sno,sname,sage) VALUES(100," 张红 ",20) ;
A.INSERT INTO student VALUES(100," 张红 ",20) ;
B.INSERT INTO student(sno,sname,sage,smajor) VALUES(100," 张红 ",20,NULL) ;
C.INSERT INTO student VALUES(100," 张红 ",20,NULL) ;
D.INSERTINTO student(sno,sname,sage) VALUES(100," 张红 ",20) ;
A.INSERT INTO student VALUES(100," 张红 ",20) ;
B.INSERT INTO student(sno,sname,sage,smajor) VALUES(100," 张红 ",20,NULL) ;
C.INSERT INTO student VALUES(100," 张红 ",20,NULL) ;
D.INSERTINTO student(sno,sname,sage) VALUES(100," 张红 ",20) ;
A.INSERT INTO student VALUES(100," 张红 ",20) ;
B.INSERT INTO student(sno,sname,sage,smajor) VALUES(100," 张红 ",20,NULL) ;
C.INSERT INTO student VALUES(100," 张红 ",20,NULL) ;
D.INSERTINTO student(sno,sname,sage) VALUES(100," 张红 ",20) ;
A.INSERT INTO student VALUES(100," 张红 ",20) ;
B.INSERT INTO student(sno,sname,sage,smajor) VALUES(100," 张红 ",20,NULL) ;
C.INSERT INTO student VALUES(100," 张红 ",20,NULL) ;
D.INSERTINTO student(sno,sname,sage) VALUES(100," 张红 ",20) ;
设有关系模式 SC( Sno, Sname, Sex, Birthday, Cno, Cname, Grade, Tno, Tname)满足函数 依赖集: {Sno→Sname, Sno→Sex, Sno→Birthday, Cno→Cname, (Sno, Cno)→Grade, Tno→ Tname}.SC 的主码和属性集( Sno, Tno)的闭包分别是
A.INSERT INTO student VALUES(100," 张红 ",20) ;
B.INSERT INTO student(sno,sname,sage,smajor) VALUES(100," 张红 ",20,NULL) ;
C.INSERT INTO student VALUES(100," 张红 ",20,NULL) ;
D.INSERTINTO student(sno,sname,sage) VALUES(100," 张红 ",20) ;
A.INSERT INTO student VALUES(100," 张红 ",20) ;
B.INSERT INTO student(sno,sname,sage,smajor) VALUES(100," 张红 ",20,NULL) ;
C.INSERT INTO student VALUES(100," 张红 ",20,NULL) ;
D.INSERTINTO student(sno,sname,sage) VALUES(100," 张红 ",20) ;
A.INSERT INTO student VALUES(100," 张红 ",20) ;
B.INSERT INTO student(sno,sname,sage,smajor) VALUES(100," 张红 ",20,NULL) ;
C.INSERT INTO student VALUES(100," 张红 ",20,NULL) ;
D.INSERTINTO student(sno,sname,sage) VALUES(100," 张红 ",20) ;
A.INSERT INTO student VALUES(100," 张红 ",20) ;
B.INSERT INTO student(sno,sname,sage,smajor) VALUES(100," 张红 ",20,NULL) ;
C.INSERT INTO student VALUES(100," 张红 ",20,NULL) ;
D.INSERTINTO student(sno,sname,sage) VALUES(100," 张红 ",20) ;
A.INSERT INTO student VALUES(100," 张红 ",20) ;
B.INSERT INTO student(sno,sname,sage,smajor) VALUES(100," 张红 ",20,NULL) ;
C.INSERT INTO student VALUES(100," 张红 ",20,NULL) ;
D.INSERTINTO student(sno,sname,sage) VALUES(100," 张红 ",20) ;