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题:
You will want two trees about ten feet apart, from _____ to suspend your tent.
(A) there (C) which
(B) them (D) where
选D
可改写为you will want two tress about ten feet apart, to suspend your tent from.
只要有介词摆在空格之前,选项是which, them ,there ,where肯定是which
介词+which+动词不定式,整体做定语
第2题:
查询选修课程号为"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")
第3题:
查询选修课程号为“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”)
第4题:
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第5题:
查询平均成绩良好,也就是≥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题:
You will want two trees about ten feet apart, from _____ to suspend your tent.
(A) there (C) which
(B) them (D) where
选择D
可改写为you will want two tress about ten feet apart, to suspend your tent from.
只要有介词摆在空格之前,选项是which, them ,there ,where肯定是which
介词+which+动词不定式,整体做定语
第7题:
( 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" )
第8题:
International traders often () a longer period for ()of an account.
A、requested,settlement
B、requested,settling
C、request,settlement
D、request,settling
第9题:
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第10题:
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