第2题
A.使用了右外连接
B.检索教师编号,教师姓名,教师讲授的课程号三列信息
C.On关键字可以替换为Where
D.即使某教师没有讲授过任何一门课程,他的信息也会显示出来
第3题
A.join
B.left join
C.right join
D.inner join
第7题
A.Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student Where SC.Sno=Student.Sno
B.Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC Join Student On SC.Sno=Student.Sno
C.Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From Student Join SC On SC.Sno=Student.Sno
D.Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student On SC.Sno=Student.Sno
第8题
A.SELECT * FROM erexam NATURAL LEFT OUTER JOIN exampaper;
B.SELECT * FROM erexam NATURAL LEFT JOIN exampaper;
C.SELECT * FROM erexam NATURAL JOIN exampaper;
D.SELECT * FROM erexam OUTER JOIN exampaper;
E.SELECT * FROM erexam NATURAL OUTER JOIN exampaper;
F.SELECT * FROM erexam LEFT OUTER JOIN exampaper;
第9题
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!