题目内容

要爱护实验室的模型、标本和仪器设备。不得蓄意破坏,如有损坏应及时报告实验老师,根据情况照价赔偿并做好记录。

A. 对
B. 错

查看答案
更多问题

发现事故,应及时向实验老师报告,立即采取有效措施控制影响范围,并根据情况逐级上报。

A. 对
B. 错

查询语句SELECT *FROM StudentWHERE Sdept = 'CS'EXCEPTSELECT *FROM StudentWHERE Sage <= 19;可以等价为:( )

A. SELECT * FROM Student WHERE Sdept = 'CS' AND Sage > 19;
B. SELECT * FROM Student WHERE Sdept = 'CS' AND Sage <= 19;
C. SELECT * FROM Student WHERE Sdept = 'CS' OR Sage <= 19;
D. SELECT * FROM Student WHERE Sdept = 'CS' OR Sage > 19;

选择题:在所有学生中查询比计算机系学生平均年龄大的学生姓名,可以使用的查询语句是:

A. SELECT SnameFROM StudentWHERE Sage > (SELECT AVG(Sage)FROM Student);WHERE Sdept = 'CS'
B. SELECT SnameFROM StudentWHERE Sage > AVG(SELECT SageFROM StudentWHERE Sdept = 'CS');
C. SELECT SnameFROM StudentWHERE Sage > (SELECT AVG(Sage)FROM StudentWHERE Sdept = 'CS');
D. SELECT SnameFROM StudentWHERE AVG(Sage) > (SELECT SageFROM StudentWHERE Sdept = 'CS');

查询所有未达60分的选课记录,要求显示出该学生的姓名、该门课程的名称和分数,不正确的查询语句是:( )

A. SELECT Student.Sname, Course.Cname, SC.GradeFROM SC, Student, CourseWHERE SC.Sno = Student.SnoAND SC.Cno = Course.CnoAND SC.Grade < 60;B.SELECT Student.Sname, Course.Cname, SC.GradeFROM StudentLEFT JOIN SCON SC.Sno = Student.SnoLEFT JOIN CourseON SC.Cno = Course.CnoWHERE SC.Grade < 60;
B. SELECT Student.Sname, Course.Cname, SC.GradeFROM SCLEFT JOIN StudentON SC.Sno = Student.SnoLEFT JOIN CourseON SC.Cno = Course.CnoWHERE SC.Grade < 60;
C. SELECT Student.Sname, Course.Cname, SC.GradeFROM StudentLEFT JOIN SCON SC.Sno = Student.SnoLEFT JOIN CourseON SC.Cno = Course.CnoWHERE SC.Grade < 60;
D. SELECT Student.Sname, Course.Cname, SC.GradeFROM CourseLEFT JOIN SCON SC.Cno = Course.CnoLEFT JOIN StudentON SC.Sno = Student.SnoAND SC.Grade < 60;

答案查题题库