题目
A.select count(*) from sc
B.select count(sno) from sc
C.select count(distinct sno) from sc
D.select count(cno) from sc
第1题
A.student.sno=sc.sno and sc.cno=course.cno and cname='Java程序设计'
B.cname='Java程序设计'
C.student.sno=sc.sno and cname='Java程序设计'
D.sc.cno=course.cno and cname='Java程序设计'
第2题
A.默认值
B.有效性规则
C.索引
D.表之间的关系
第3题
A.select sname from student where sdept=’CS‘ and sage>20
B.select sname from student where sdept=’CS‘ intersect select sname from student where sage>20
C.select sname from student where sdept=’CS‘ except select sname from student where sage<=20
D.select sname from student where sdept=’CS‘ union select sname from student where sage>20
第4题
A.select sname from student where sdept=’CS‘ except select sname from student where sage<=20
B.select sname from student where sdept=’CS‘ intersect select sname from student where sage>20
C.select sname from student where sdept=’CS‘ and sage>20
D.select sname from student where sdept=’CS‘ union select sname from student where sage>20
第5题
A.update CS_student set sdept='IS' where sno='200215123' 1
B.delete from CS_student where sno='200215123' 2
C.insert into CS_student values('200215128','Tom','男',21,'MA') 3
D.insert into CS_student values('200215129','Mike','男',20,'CS') 4
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!