题目内容

在scores表sno列上添加参照student表sno列的外键约束,正确的SQL语句是()

A. alter table scores add constraint fk_cno foreign key (sno) references student(sno)
B. alter table scores add constraint fk_cno foreign key (sno)
C. alter table scores add foreign key (sno) references student(sno)
D. alter table scores add constraint foreign key (sno)

查看答案
更多问题

在scores表cno列上添加参照course表的cno列的外键约束,正确的SQL语句是()

A. alter table scores add constraint fk_cno foreign key (cno) references course(cno)
B. alter table scores add constraint fk_cno foreign key (cno)
C. alter table scores add foreign key (sno) references student(cno)
D. alter table scores add constraint foreign key (cno)

course表设计如下,通过SQL语句的Insert语句来输入一门课程的信息, 正确的SQL语句是()

A. insert into course values (’0802’,’Oracle数据库技术’,4, ’考试’)
B. insert into course (cno,cname) values (’0802’,’Oracle数据库技术’,4, ’考试’)
C. insert into course (*) values (’0802’,’Oracle数据库技术’,4, ’考试’)
D. insert into course values (0802,’Oracle数据库技术’,’4’, ’考试’)

student表设计如下,通过SQL语句的Insert语句来插入一个学生的信息, 正确的SQL语句是()

A. insert into student values(‘20140101’,’张三’,w,1996-01-01)
B. insert into student values(‘20140101’,’张三’,‘w’,‘1996-01-01’)
C. insert into student values(‘20140101’,’张三’, ‘1996-01-01’, ‘男’)
D. insert student values(‘20140101’,’张三’,‘w’,‘1996-01-01’)

scores表设计如下,通过SQL语句的Insert语句来输入一个学生成绩的信息, 正确的SQL语句是()

A. insert into scores values(‘20140101’,’0802’,87)
B. insert into scores values(’0802’,‘20140101’,87)
C. insert into scores values(’0802’,‘20140101’,’87’)
D. insert into scores (’0802’,‘20140101’,87)

答案查题题库