举一反三
- 李约瑟(Joseph Needham)是英国生物化学家、科技史家。
- 李约瑟难题,由英国学者李约瑟(Joseph Needham,1900-1995)提出的。
- Joseph Needham is the world’s ______ scholar of Chinese science. A: foregoing B: foreve C: foremost D: forme
- 英国科学家Joseph Needham对中国道家思想极其推崇,认为道家给予中国人更富吸引力的性格。
- Which of the following Confucianism thoughts did Joseph Needham agree with? A: 知之为知之,不知为不知,是知也。 B: 君君,臣臣,父父,子子。 C: 学而优则仕。 D: 德治,仁治,礼治。
内容
- 0
Where is the woman from Where is the woman from A: Australia. B: B.Canada. C: C.England.
- 1
下列查询中,属于相关子查询的有()。 A: SELECT * FROM student WHERE sno IN (SELECT sno FROM sc WHERE cno='1'); B: SELECT sno, cno FROM SC x WEHRE grade>=(SELECT AVG(grade) FROM SC y WHERE y.sno = x.sno); C: SELECT sname FROM student WHERE EXISTS(SELECT * FROM sc WHERE sno=student.sno AND cno='1'); D: SELECT sname FROM student WHERE NOT EXISTS(SELECT * FROM course WHERE NOT EXISTS(SELECT * FROM sc WHERE sc.sno=student.sno AND sc.cno=course.cno));
- 2
查询所有成绩均大于80分的学生姓名,应执行( )语句 A: SELECT SNAME FROM STUDENT WHERE EXISTS (SELECT *FROM SC WHERE STUDENSNO = SC.SNO AND GRADE> 80); B: SELECT SNAME FROM STUDENT WHERE EXISTS (SELECT *FROM SC WHERE STUDENSNO = SC.SNO AND GRADE C: SELECT SNAME FROM STUDENT WHERE NOT EXISTS (SELECT *FROM SC WHERE STUDENSNO = SC.SNO AND GRADE D: SELECT SNAME FROM STUDENT WHERE NOT EXISTS (SELECT *FROM SC WHERE STUDENSNO = SC.SNO AND GRADE> 80);
- 3
Where is Mr. Brown from? He is from
- 4
查询成绩大于90分的学生的姓名,正确的SQL命令是( ) A: select 姓名 from 学生表 where 学号=(select 学号 from 成绩表 where 成绩>90) B: select 姓名 from 学生表 where 学号 in (select 学号 from 成绩表 where 成绩>90) C: select 姓名 from 学生表 where 学号>(select 学号 from 成绩表 where 成绩>90) D: select 姓名 from 学生表 where 学号90)