A. chmod -R o-s /application
B. chmod -R ug-s /application
C. chmod -R -s -o /application
D. chmod -R -s -ug /application
第1题:
查询选修课程号为"101"课程得分最高的同学,正确的SQL语句是
A.SELECT学生.学号,姓名FROM学生,选课WHERE学生.学号=选课.学号 AND课程号="101”AND成绩>=ALL(SELECT成绩FROM选课)
B.SELECT学生.学号,姓名FROM学生,选课WHERE学生.学号;选课.学号 AND成绩>=ALL(SELECT成绩FROM选课WHERE课程号="101")
C.SELECT学生.学号,姓名FROM学生,选课WHERE学生.学号二选课.学号 AND成绩>=ANY(SELECT成绩FROM选课WHERE课程号="101")
D.SELECT学生.学号,姓名FROM学生,选课WHERE学生.学号=选课.学号AND课程号="101" AND成绩>=ALL(SELECT成绩FROM选课WHERE课程号 ="101")
第2题:
查询平均成绩良好,也就是≥80分的考生人数,查询语句就可以写成()。
A.WITH avgach (eeid,avgachieve) AS (SELECT eeid,AVG(achieve) FROM eeexam GROUP BY eeid ) SELECT COUNT(*) FROM avgach WHERE avgachieve>=80;#B.WITH avgach (eeid,avgachieve) (SELECT eeid,AVG(achieve) FROM eeexam GROUP BY eeid ) SELECT COUNT(*) FROM avgach WHERE avgachieve>=80;#C.SELECT COUNT(*) FROM (SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid )AS avgach (eeid,avgachieve) WHERE avgachieve>=80;#D.SELECT COUNT第3题:
50、查询平均成绩良好,也就是≥80分的考生人数,查询语句就可以写成()。
A.WITH avgach (eeid,avgachieve) AS (SELECT eeid,AVG(achieve) FROM eeexam GROUP BY eeid ) SELECT COUNT(*) FROM avgach WHERE avgachieve>=80;#B.WITH avgach (eeid,avgachieve) (SELECT eeid,AVG(achieve) FROM eeexam GROUP BY eeid ) SELECT COUNT(*) FROM avgach WHERE avgachieve>=80;#C.SELECT COUNT(*) FROM (SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid )AS avgach (eeid,avgachieve) WHERE avgachieve>=80;#D.SELECT COUNT第4题:
( 33 )查询选修课程号为 “ 101 ” 课程得分最高的同学,正确的 SQL 语句是
A) SELECT 学生 . 学号 , 姓名 FROM 学生 , 选课 WHERE 学生 . 学号 = 选课 . 学号
AND 课程号 = "101" AND 成绩 >=ALL(SELECT 成绩 FROM 选课 )
B) SELECT 学生 . 学号 , 姓名 FROM 学生 , 选课 WHERE 学生 . 学号 = 选课 . 学号
AND 成绩 >=ALL(SELECT 成绩 FROM 选课 WHERE 课程号 = "101" )
C) SELECT 学生 . 学号 , 姓名 FROM 学生 , 选课 WHERE 学生 . 学号 = 选课 . 学号
AND 成绩 >=ANY(SELECT 成绩 FROM 选课 WHERE 课程号 = "101" )
D) SELECT 学生 . 学号 , 姓名 FROM 学生 , 选课 WHERE 学生 . 学号 = 选课 . 学号
AND 课程号 = "101"AND 成绩 >=ALL(SELECT 成绩 FROM 选课 WHERE 课程号 = "101" )
第5题:
3、查询平均成绩良好,也就是≥80分的考生人数,查询语句就可以写成()。
A.WITH avgach (eeid,avgachieve) AS (SELECT eeid,AVG(achieve) FROM eeexam GROUP BY eeid ) SELECT COUNT(*) FROM avgach WHERE avgachieve>=80;#B.WITH avgach (eeid,avgachieve) (SELECT eeid,AVG(achieve) FROM eeexam GROUP BY eeid ) SELECT COUNT(*) FROM avgach WHERE avgachieve>=80;#C.SELECT COUNT(*) FROM (SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid )AS avgach (eeid,avgachieve) WHERE avgachieve>=80;#D.SELECT COUNT第6题:
42、查询平均成绩良好,也就是≥80分的考生人数,查询语句就可以写成()。
A.WITH avgach (eeid,avgachieve) AS (SELECT eeid,AVG(achieve) FROM eeexam GROUP BY eeid ) SELECT COUNT(*) FROM avgach WHERE avgachieve>=80;#B.WITH avgach (eeid,avgachieve) (SELECT eeid,AVG(achieve) FROM eeexam GROUP BY eeid ) SELECT COUNT(*) FROM avgach WHERE avgachieve>=80;#C.SELECT COUNT(*) FROM (SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid )AS avgach (eeid,avgachieve) WHERE avgachieve>=80;#D.SELECT COUNT