成考
Student participation（参与）in the classroom is not only accepted but also expected of the student in many courses.Some professors base part of the final grade on the student′s oral participation.Although there are formal lectures during which the student ha
题目
A professor′s teaching method is another factor（因素）that determines the degree and type of student participation.Some professors prefer to control discussion while others prefer to guide the class without controlling it.Many professors encourage students to question their ideas.Students who object to the professor′s point of view should be prepared to prove their positions.
In the teaching of science and mathematics,the controlling mode of instruction is generally traditional,with teachers presenting formal lectures and student staking notes.However,new educational trends have turned up in the humanities and social sciences in the past twenty years.Students in education,society,and history classes,for example,are often required to solve problems in groups,design projects,make presentations,and examine case studies.Since some college or university courses are"practical"rather than theoretical,they pay more attention to"doing"for themselves.
From the passage we know that education in the humanities and society
B.pay attention to students'studying instead of teachers'teaching
C.is much more important than that of science and mathematics
D.has become more practical than theoretical
相似问题和答案
第1题：
The STUDENT_GRADES table has these columns:STUDENT_ID NUMBER(12)SEMESTER_END DATEGPA NUMBER(4,3)The registrar requested a report listing the students‘ grade point averages (GPA) sorted from highest grade point average to lowest.Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar? （）
A. SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;
B. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;
C. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;
D. SELECT student_id, gpa FROM student_grades ORDER BY gpa;
E. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;
F. SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
第2题：
试题基于如下三个关系，其中学生关系student的主码是sno，课程关系course的主码是cno，选课关系SC的主码是（sno，cno）。
查找学生姓名及其所选修课程的课程号和成绩，正确的SQL语句是（ ）。
A）SELECT sname FROM student,SELECT cno,grade FROM sc
WHERE student.sno＝sc.sno
B）SELECT sname, cno,grade FROM student,course
WHERE student.sno＝course.cno
C）SELECT sname, cname,grade FROM student,course, sc
WHERE student.sno＝sc.Snoand sc.cno＝course.cno
D）SELECT sname,cno, grade FROM student,sc
WHERE student.sno＝sc.sno
要查询学生姓名，选修课程号及对应成绩，在同一SELECT子句后应包含这三个字段，故选项A)错误；而学生学号是用来关联sc与student表，故在where子句中应有“student.sno＝sc.sno”，故选项B)错误；对于选项C)，它没有查询课程号，而是查询的课程名，所以错误。
第3题：
（40）查找学生姓名及其所选修课程号和成绩，正确的 SQL 语句是
A）SELECT sname FROM student, SELECT cno,grade FROM sc WHERE student.sno =sc.sno
B） FROM sname,cno,grade FROM student,course WHERE student.sno =course.cno
C） SELECT sname ,canme,grade FROM student,course,sc WHERE student.sno =sc.sno and sc.c
no=course.cno
D） SELECT sname ,cno,grade FROM student,sc WHERE student.sno =sc.sno
（40）【答案】C)
【解析】题意中要求查找学生姓名。课程号的成绩。这一个属性可以查找两个关系表
student 和 se,通过条件 student，so=sc.so 进行连接。
第4题：
Many teachers believe that the responsibilities for learning lie with the student._________(51) a long reading assignment is given,instructors expect students to be familiar with the_________(52) in the reading even if they do not discuss it in class or take an examination.The__________(53) student is considered to be one who is motivated（激励）to learn for the sake of_________(54),not the one interested only in getting high grades.Sometimes homework is returned________(55)brief written comments but without a grade.Even if a grade is not given,the student is_________(56) for learning the material assigned.When research is________(57),the professor expects the student to take it actively and to complete it with minimum guidance.It is the_________(58)responsibility to find books, magazines,and articles in the library.Professors do not have the time to explain _________(59)a university library works;they expect students,______(60)graduate students,to be able to exhaust the reference sources in the library.Professors will help students who need it,but_________(61)that their students should not be too dependent on them. In the United States professors have many other duties________(62)teaching,such as administrative or research work.________(63),the time that a professor can spend with student outside of class is_________(64).If a student has problems with classroom work,the student should either approach a professor during office hour_________(65)make an appointment.
A:hate
B:dislike
C:like
D:prefer
information“信息”。advice“建议”。context“上下文，背景”。abstract“摘要”。只有information符合句子意思。
ideal“理想的”。poor“差的”。average“普通的，平均的”。disappointed“使人失望的”。只有ideal符合句子意思。
该句是说明理想学生是什么样子。An ideal student is considered to be one who is motivated（激励）to learn for the sake of learning,not the one interested only in getting high grades．理想的学生应该是为了学习而学习，而不是只对得高分感兴趣。
with brief written comments这里表示作业被老师返还回去时，上面写上了简短的评语，表达伴随状态，这里选with最合适。
be responsible for sth.“对······负责任”，是固定搭配。
assign“布置”。collect“收集”。distribute“分配”。finish“完成”。When research is assigned的意思是“当教授给学生布置研究任务时”。
上一句中说：…the professor expects the student to take it actively and to complete it with minimum guidance．教授希望学生积极参与，在尽可能少的指导下完成。因此这里说的查阅书籍、杂志和图书馆文献这些事情都是学生的职责。
how a university library works“大学图书馆如何运作”。只有how意思合适。
particularly“尤其是”。essentially“基本上”。apparently“明显地”。rarely “很少”。…they expect students, particularly graduate students, to be able to exhaust the reference sources in the library······他们希望学生尤其是研究生能够充分利用图书馆的各种参考资料。
prefer that sb.should not do sth.“宁愿某人不要做某事”。只有prefer有此用法。
besides“除了······以外还有”。这里是说美国老师除了教学任务之外，还有行政和科研等任务。
前一句中提及的美国老师任务繁多导致的结果就是老师和学生在一起的时间很有限，因此这里选择therefore表达这种因果关系。
limited“有限的”。plentiful“充足的”。irregular“不规则的”。flexible“灵活的”。只有limited符合句子意思。
either do sth.or do sth.“或者······或者······”，这里选择 or和前面的either搭配。
第5题：
在关系SC(student_id,student_name,course_id,grade)中，有 student_id,course_id→grade student_id→student_name 关系SC最高达到______范式。
A．不满足
B．1NF
C．2NF
D．3NF
第6题：
对于数据表：student(sno,sname,sex,age,grade)，查询学习成绩为空的学生的学号和姓名，下面语句正确的是______。
A．SELECT sno,sname FROM student WHERE gade=NULL
B．SELECT sno,sname FROM student WHERE grade IS NULL
C．SELECT sno,age FROM student WHERE grade IS NULL
D．SELECT mo,age FROM student WHERE grade=NULL
解析：A、D选项中，不能写成列名=NULL；C、D选项查询的字段不正确。
第7题：
对于学生信息表：student(sno，sname，sex，age，grade)，查询学习成绩为空的学生的学号和姓名，下面语句正确的是
A．SELECT sno，sname FROM student WHERE grade=NULL
B．SELECT sno，sname FROM student WHERE grade IS NULL
C．SELECT sno，age FROM student WHERE grade IS NULL
D．SELECT sno，age FROM student WHERE grade=NULL
解析：A)，D)选项中，不能写成列名=NULL；C)，D)选项查询的字段不正确。
第8题：
Ⅲ. Reading
Comprehension
从下列每篇短文的问题后所给的四个选择项中选出一个最佳答案。
Passage One
Questions 21 to 25 are based on the following passage.
Many teachers believe that the responsibility for learning lies with the students. If a long reading assignment is given，instructors expect students to be familiar with the information in the reading even if they do not discuss it in class or give an examination. (Courses are not designed merely for students to pass exams). The ideal student is considered to be one who is motivated to learn for the sake of learning，not the one interested only in getting high grades. Grade-conscious students may be frustrated with teachers who do not believe it is necessary to grade every assignment. Sometimes homework is returned with brief written comments but without a grade. Even if a grade is not given，the student is responsible for learning the material assigned.
When research is assigned，the professor expects the student to take the initiative and to complete the assignment with minimal guidance. It is the student's responsibility to find books，periodicals，and articles in the library. Professors do not have the time to explain how a university library works，they expect students，particularly graduate students，to be able to exhaust the reference sources in the library.
Professors will help students who need it，but prefer that their students not be overly dependent on them. (This differs from teacher-student relationships in other countries. )In the United States，professors have other duties besides teaching. Often they are responsible for administrative work within their departments. In addition，they may be obliged to publish articles and books. Therefore the time that a professor can spend with a student outside of class is limited. If a student has problems with classroom work，the student should either approach a professor during office hours or make an appointment.
“Courses are not designed merely for students to pass exams. ”This means teachers______.
A. want students to fail exams
B. care only about exam grades
C. believe that passing exams is not the only purpose of a course
D. design courses for lectures only
[解析] 课程的设计不仅仅是用来让学生通过考试，选项C与此意相符。
第9题：
Teaching and Learning
Many teachers believe that the responsibilities for learning lie with the student.If a long reading assignment is given,instructors expect students to be familiar with the ______(1)in the reading even if they do not discuss it in class or take an examination.The ______(2) student is considered to be one who is motivated to learn for the sake of______(3) ,not the one interested only in getting high grades.Sometimes homework is returned ______(4) brief written comments but without a grade.
Even if a grade is not given,the student is ______(5) for learning the materi al assigned.When research is______(6), the professor expects the student to take it actively and to complete it with______(7) guidance.
It is the student's responsibility to find books,maga-zines,and articles in the library.Professors do not have the time to explain______(8) a university library works；they expect students______(9) graduate students to exhaust the reference______(10) in the library.Professors will help students who need it,but______(11) that their students should not be______(12)dependent on them.In the United States professors have many other duties______(13)teaching,such as administrative or research work.Therefore, the time that a professor can spend with a student outside of class is______(14).
If a student has problems with classroom work,the student should either______(15)a professor during office hours or make an appointment.
A:suggestion
B:context
C:abstract
D:information
此句大意为“有理想的学生是为了学习而学习”，只有ideal最符合要求，故选B。
本文讲的是与学生学习相关的内容，A,B,D项均不合文意及句意，故排除。
此处要区分几个介词的含义，be returned with一般有“带着……回来”之意，此句意为“有时，被发回来的作业上只有简短的评价，并无分数”。be returned by意为“被……带回来”，而for,in于此搭配不当，所以答案选D。
be responsible for是固定搭配，表示“对……负责任”。其他选项放在此处都不合上下文含意。
此句意思是“当选定了一项研究课题时，教授们期望学生积极对待”。A和 D不合题意，最大的干扰项B意思为“分配，分布”，一般指一个整体被分散给许多个体，与之相比，C选项更为合适。
老师肯定希望学生能够在尽可能少的指导下完成研究。只有B选项意为 “最小的”，为正确答案。
首先排除B选项，因为此处需要一个关系副词充当宾语从句的状语，而 what是关系代词，之后要看整句的意思，“教授们没有时间去给学生解释一个大学图书馆是怎样运作的”。A和C虽然符合语法要求，但放此处意思不通，故选D。
A项“尤其”,B项“本质上”，C项“明显地”,D项“很少地，难得”。此处强调研究生，A选项较为合适。
此句意为“教授们期望学生，尤其是研究生阅尽图书馆中的文献资源”。A 项意为“选集”,B项为“集合”，两者一般都指文学作品的“集合”，而此处是学术界的文献。C 与D选项都有“来源，源头”的意思，但D选项侧重于“起源，开端”，C项更侧重于“原始资料”, 所以C项为正确答案。
根据下文意思，A和B选项可直接排除，教授们肯定是喜欢学生不依赖他们。D选项的含义比C选项更递进了一步，符合题意，故选D。
dependent是形容词，前面不能与such, much搭配，D选项more放在此处构成比较级，但前文并无原级与之相比较，因此只剩下A为答案，此句意为“教授们愿意帮助那些需要帮助的学生，但更希望学生不要太过依赖他们”。
此题重点在于区分三个有“除……之外”含义的介词。A选项一般翻译成 “而不是，并不是”,B选项意为“除去……之外”,D选项意为“除去……之外还……”，此句意思为“美国的教授除了教书之外还有许多其他的职责”，故D为答案。
根据上文含义，一个教授能花在学生身上的时间一定是有限的，A,C,D项不合题意，直接排除，B选项为正确答案。
此题还是承接上文含义，正因为教授时间有限，因此学生若想与之沟通，定要等教授在学校的时候，或是提前约好。C选项意为“接近，靠近”，为正确答案，A项“问候”, B项“使……厌恶”,D项“依附，伴随，添加”，意思均与文意不符。
第10题：
Many teachers believe that the responsibilities for learning lie with the student._________(51) a long reading assignment is given,instructors expect students to be familiar with the_________(52) in the reading even if they do not discuss it in class or take an examination.The__________(53) student is considered to be one who is motivated（激励）to learn for the sake of_________(54),not the one interested only in getting high grades.Sometimes homework is returned________(55)brief written comments but without a grade.Even if a grade is not given,the student is_________(56) for learning the material assigned.When research is________(57),the professor expects the student to take it actively and to complete it with minimum guidance.It is the_________(58)responsibility to find books, magazines,and articles in the library.Professors do not have the time to explain _________(59)a university library works;they expect students,______(60)graduate students,to be able to exhaust the reference sources in the library.Professors will help students who need it,but_________(61)that their students should not be too dependent on them. In the United States professors have many other duties________(62)teaching,such as administrative or research work.________(63),the time that a professor can spend with student outside of class is_________(64).If a student has problems with classroom work,the student should either approach a professor during office hour_________(65)make an appointment.
A:student's
B:professor's
C:assistant's
D:librarian's
information“信息”。advice“建议”。context“上下文，背景”。abstract“摘要”。只有information符合句子意思。
ideal“理想的”。poor“差的”。average“普通的，平均的”。disappointed“使人失望的”。只有ideal符合句子意思。
该句是说明理想学生是什么样子。An ideal student is considered to be one who is motivated（激励）to learn for the sake of learning,not the one interested only in getting high grades．理想的学生应该是为了学习而学习，而不是只对得高分感兴趣。
with brief written comments这里表示作业被老师返还回去时，上面写上了简短的评语，表达伴随状态，这里选with最合适。
be responsible for sth.“对······负责任”，是固定搭配。
assign“布置”。collect“收集”。distribute“分配”。finish“完成”。When research is assigned的意思是“当教授给学生布置研究任务时”。
上一句中说：…the professor expects the student to take it actively and to complete it with minimum guidance．教授希望学生积极参与，在尽可能少的指导下完成。因此这里说的查阅书籍、杂志和图书馆文献这些事情都是学生的职责。
how a university library works“大学图书馆如何运作”。只有how意思合适。
particularly“尤其是”。essentially“基本上”。apparently“明显地”。rarely “很少”。…they expect students, particularly graduate students, to be able to exhaust the reference sources in the library······他们希望学生尤其是研究生能够充分利用图书馆的各种参考资料。
prefer that sb.should not do sth.“宁愿某人不要做某事”。只有prefer有此用法。
besides“除了······以外还有”。这里是说美国老师除了教学任务之外，还有行政和科研等任务。
前一句中提及的美国老师任务繁多导致的结果就是老师和学生在一起的时间很有限，因此这里选择therefore表达这种因果关系。
limited“有限的”。plentiful“充足的”。irregular“不规则的”。flexible“灵活的”。只有limited符合句子意思。
either do sth.or do sth.“或者······或者······”，这里选择 or和前面的either搭配。