下面是小编整理的简单回答题解析（共含8篇），欢迎大家阅读分享借鉴，欢迎大家分享。同时，但愿您也能像本文投稿人“十动不拒绫人”一样，积极向本站投稿分享好文章。
1月考题
一个英语教师的标准是什么？是不是只要是a native english speaker就可以了呢？a native english speaker是否就比a non-native english speaker强呢？该篇短文对比了对英语教师过去和现在的职业要求和资格评价的情况，介绍了现在对本族语英语教师和非本族语英语教师一视同仁的变化。
第一题 the selection of english teachers used to be mainly based on ________.
题解：本题的重要线索是题干中的“used to”。文章的第二段提到“十年前，……只要是a native english speaker，你就足以成为一名英语教师了”。换句话说，就是过去选择英语教师的标准就是看你是不是a native english speaker。所以本题的正确答案可以是：…whether they were english speakers。
要点：（1）注意答案是作“on”宾语，后面又有“是否……”，答案应该用由whether引导的名词性从句；
（2）题干中的“used to”告诉我们答案中也要用过去时态；如果信手写成whether they are english speakers是要扣0.5分的；
（3）题干中的“english teachers”是一个复数，答案中也要用复数。如果信手写成whether he was english speakers是要扣0.5分的；
请参考其它的评分标准：
l 可得2.0分的回答：
1) their nationality
2) whether they were native speakers or not
3) the language the teachers had as mother tongue
4) the job applicants’ nationality
5) where they came from and their mother tongue
l 可得1.5分的回答：
1) whether is a native speaker or not
从句中缺主语，语法错误扣0.5分。
2) their citizenship, whether the job applicants were english speakers or not.
超词，共11个词，扣0.5分。 l 可得1分的回答
1) being a native speaker was enough to get you employed
照抄原文，扣0.5分。与所补充句子语法不搭配，扣0.5分。
2) they were native speakers or not and whether professional status
“whether…or not”句式表达错误，扣0.5分。部分内容与问题无关，扣0.5分。
l 可得0.5分的回答：
1) nation. a english man is enough to be a english teacher.
回答不全面，仅包含部分正确内容，扣0.5分。语法错误（应为，时态错误应为过去时）扣0.5分。
2) speaking. you should being a native speaker.
回答不全面，包含部分正确内容，得1 分。语言错误，扣0.5分。
l 可得0分的回答：
1) their professional status and skills
2) a personal level
3) a native english speaker
4) the knowledge, the skills and the attitudes.
没有回答出正确内容，不得分。
第二题 what did non-native english teachers deserve but seldom enjoy?
题解：本题有较明确的线索，在第三段中有“something they have always deserved but seldom enjoyed”，本题的答案显然是这个“something”，那么它究竟指的是什么呢？答案很简单，在something的前面有一个破折号，去找一找前面的名词短语就是了，所以答案是：the same status as their native counterparts。
要点：问题是以what进行的提问而且问的是事物，所以要以名词的形式作答。由于本题较简单，扣分也比较狠。
l 可得2.0分的回答：.
1) the status that/which the native counterparts have.
2) the same status as the native english teachers
3) having the same status as those native speakers.
l 可得1.5分的回答：
1) same status as their native counterparts. 语法错误，应为the same status，扣0.5分。
2) there shouldn’t be linguistic discrimination. 问题以what提问，应回答具体事物，但句子内容基本切合题义，因此扣0.5分。
3) raising them to the same status as the native speakers. 语态错误，应为被动语态，扣0.5分。
4) they were at the same status as the native english teachers. 时态错误，应为现在时，扣0.5分。
l 可得1分的回答：
1. recognition of professional status and skills and a job. 回答包含部分答案，但不全面也不清楚，扣1分。
2. the result that they have the same status as their native counterparts. 问题问的是没有享受到的事物，回答中用the result，不太合题意，扣0.5分。超词，扣0.5分。
l 可得0.5分的回答：
1) raising of their status. 仅提到地位的提升，但提升到什么程度这一关键内容没有涉及，因此扣1.5分。
2) they can teach english like native english teachers.
仅提到象本族语教师一样讲课，但在什么方面一样没有涉及，忽略了关键部分，扣1.5分。
l 可得0分的回答：
1) linguistic discrimination.
2) like their native counterparts.
3) the chances to be an english teacher.
4) the native english teacher
完全答非所问，不得分。
第三题 what kind of people can now find a job as an english teacher?
题解： 本题有两处重要线索，只要找到一处，即能找到正确答案。这两处线索分别是：第三段的第一句话说，现在雇主们只去注意那些……的人，省略号的部分即是答题的关键。另一处线索是第四段的第二句话，“只要他们能……”，能答出此处，也是正确的。
要点： （1）问题是“什么样的人”，因此本题的作答应该是名词短语，最好用定语从句。
（2）题干中的“can”表明这是现在时，这是一个重要的线索。
其它的评分标准：
标准答案：
those who are qualified.
those who can teach english effectively.
l 可得2分的回答：
1) those who have good skills and attitudes to teach effectively.
2) both qualified native english speakers and non-native speakers.
3) whoever has the knowledge, the skills and the right attitudes.
l 可得1.5分的回答：
1) having the knowledge, the skill and teaching english effectively.
问题中问的是哪种人能找到教师工作，回答与提问不对应，仅提到应具备的素质，因此扣分。
2) those who have knowledge and skills, can teach english effectively. 语言错误，应为，扣分。
3) who can teach and have the required level of english. 语言错误，应添加，才能具有名词性，扣分。
l 可得1分的回答：
1) people who has knowledge, the skills and attitudes to teach english effectively. 语言错误，应为have，扣分。超词，扣分。
2) the knowledgeable, skillful people who have the required english level.
错误使用knowledgeable，该词意思是“渊博的”，与答案内容无关，扣0.5分。若具体回答成为一个英语教师的条件，应为the knowledge, the skills, and the right attitudes，回答中仅提到the skill一项，扣0.5分。
l 可得0.5分的回答：
1) the people who had the required level of english. 答案关键内容缺失较多，扣1分。时态错误，扣0.5分。
2) a people who have the attitudes to teacher english effectively. 句中语言错误较多，扣0.5分。句子语意与原文意义相差较远，扣1分。
l 可得0分的回答：
1) he’s the knowledge, the skills, attitudes to teach english effectively.
2) people can teach english effectively.
！！特别提示：
这两个回答看上去与问题毫不相关。但稍加改动即为正确答案：
1) he who has the knowledge … (1.5分)
2) people who can teach… (2分)
也许写下这两个回答的考生已经理解了文章，但由于他们严重错误的表达，他们的回答变得答非所问，不能得分。这一点请大家务必注意。
第四题what is the result of the “new form of discrimination”(line 5, para.4)?
题解： 这是类似于阅读理解中词义判断的题，但与做阅读理解不同的是，在阅读理解中存在两种词汇题，其一是考查学生利用上下文猜单词的能力，其二是考查根据上下文对（主要是熟悉的）词语的理解能力。而在简答题中，考查的对象主要是第二点。
就本题而言，原文中已经在括号中给出了不认识的单词的汉语意思，因此，这是不猜测词义的题，而是要求根据上下文判断这外短语在本文中的所指，是一道理解的题。
在找到第四段中的这个短语后，可以发现在“a new form of discrimination”的破折号之后的部分内容就是答案。稍微组织一下，可以全面的回答为 it singled out the unqualified and liberated the linguistically oppressed。
如果确实理解了这句话，可以看出它的意思是“它剔除了不合格的（教师），解放了以前在语言上受压迫的（教师）”。
要点： 问题是“……的结果”，应该用完整的句子作答。
其它的评分标准：
l 标准答案：
the linguistically oppressed are liberated.
unqualified english teachers are singled out.
l 可得2分的回答：
1) the result is that the linguistically oppressed were liberated.
2) singling out the unqualified, liberating the linguistically oppressed.
3) the unqualified teachers are singled out while the qualified liberated.
4) it liberated the non-native english teachers linguistically oppressed.
5) it selected the qualified teachers and singled out the unqualified.
l 可得1.5分的回答：
1) the inqualified english teachers are singled out. 语言错误，扣0.5分。
2) it single out the unqualified liberated ^ linguistically oppressed. 多处语言错误，扣0..5分。
3) to liberate the linguistically oppressed 不定式表将来，问题问的是已产生的后果，时间不符，扣0.5分。
l 可得1分的回答：
1) qualification may be more important. 句子意义与短文内容不贴切，扣1分。
2) the non-native teachers replace those unqualified native teachers.
回答不准确，什么样的非本族语教师没有说清楚，这恰恰是答案的重要部分，扣1分。
3) the unqualified native english teachers will be fired.
句子时态错误，扣0.5分。句子含义不准确，扣0.5分。
l 可得0.5分的回答：
the non-natives could also become an english teacher.
与短文意义相差太远，扣1.5分。
l 得0分的回答：
1) teachers are justified if they were qualified.
2) it will improve the teachers’ all kinds of level.
3) the non-native speaks are liberate.
完全答非所问，不得分。
第五题 the phrase “the linguistically oppressed”(line 6, para. 4) refers to those who were_________.
题解： 本题的短文中的位置与第四题在同一句话中，但答题的线索却不相同。它的线索其实是基于对全文的理解。本文主要是就英语教师的问题，将过去和现在人们对native english speakers和non-native english speakers的英语教师的态度和评判的标准加以对比。在第二段（问题的第一题）指出在过去，只要是native english speaker，你就能是英语教师了，这暗示人们对native english speaker的盲目倾向；第三段指出了人们现在评判英语教师的标准（第二题），最后一句说，“non-natives are happy--- linguistic discrimination（语言上的歧视）is a thing of the past”，言外之意是过去non-natives 在过去是受歧视的。那么“受歧视的”与“受压迫的”明显指的是同一种人，所以本题的答案很简单，就是non-native english speakers 的英语教师，可以用英语表达为：non-native teachers of english。
但本题中有一个陷阱，就是前面的it singled out the unqualified。在过去受压迫的non-native teachers of english中肯定也有合格的和不合格的，所以显然不是所有的non-native teachers of english都被解放了，那些不合格的还是被剔除了。所以如果只答出non-native teachers of english的话，只是理解对了一半，最终本题的正确答案应该是在non-native teachers of english前加上qualified一词。
要点： （1）问题中要填的是定语从句的表语部分，表示“什么样的人”，因此本题的作答应该是名词短语而不要用句子。
（2）题干中的“who were”表明这是过去时，这是一个重要的线索。
l 标准答案：
qualified non –native teachers of english.
l 可得2分的回答：
1) qualified in teaching english but were non-native speakers.
2) good english teachers but were non-natives.
3) non-native english teachers who could teach english effectively.
l 可得1.5分的回答：
1) non-native speakers but have the ability to teach well.
回答中没有明确讲教什么课程教的好，与短文意义略有差异，扣0.5分。如果是“teach english”的话，就对了。
2) able to teach english but not a native english speaker.
回答中没有指明英语教学的质量好坏，不太符合短文意义，扣0.5分。
3) the non-native speakers who are qualified for the job.
问题原句是过去时，回答中用现在时，时态不符，扣0.5分。
l 可得1分的回答：
1) non-native english teachers
短文中对的定义中包含两方面的定义：1. non-native ，2. qualified。回答中只涉及定义的一方面，扣1分。
2) non-native english teachers but had the required level of english.
回答不全面，扣1分。回答中提到的英语水平仅是英语教师资格要求中的一条，并不能代表有资格(qualified)。
3) qualified but unemployed for their being non-native speakers
回答中既有qualified又有nonnative，本应意义完整，但qualified后所跟unemployed，与原文意思矛盾，且qualified与unemployed两词意义也有矛盾之处，因此，扣1分。
l 可得0.5分的回答：
1) non-native english teachers without right treatment. 回答不全面，且有部分内容有语言错误，扣1.5分。
2) non-native english speaker and have the required level of english.回答不全面，且有语言错误，扣1.5分。
l 得0分的回答：
1) employed as a teacher.
2) the native speakers
3) employers who have required level but a non-native.
回答答非所问或完全理解错误，不得分。
196月考题
文章导读
有了孩子的妇女是否应该出去工作？这是许多人常常争论的话题。本文作者先是剖析了妇女工作的原因—为了挣钱，然后分别用事实（第一段）和讲道理（二、三段）说明这得不偿失。第一段引用了一个丈夫的话算了一笔账，证明妇女工作划不来；第二段指出经济因素并不是最重要的，家庭成员的感情需要才是最重要的。第三段先退一步，指出许多妇女呆的家里感到厌烦，但也有许多人从家务活中获得了最大的乐趣。最后一段以自己的亲身感受指出妇女进行工作是个草率的决定，暗示说她们的家里也许会得到更多。
第一题 which word in the first two paragraphs best explains why many women have to work?
题解： 本题为主旨类题，要求考生总结出妇女工作的原因。在这两段中都提到了survive，可以知道妇女出去工作主要是为了生存。所以本题的答案应该是名词survive。当然，也可以理解为她们是为了挣钱来生存，所以economy或economics也可以算作正确答案。
要点： 注意问题中的which word，因此本题的答案应为一个单词，而不要答成“they must work to survive”一类的话。
第二题 why did marge and her husband think it an extravagance for marge to go back to work?
题解： 此题属于细节类问题。文章第二段：玛基和她丈夫认为她重新外出工作对全家来说是一种奢望。他们有两个学龄前的孩子。如果把雇人照看孩子的费用、交通费用和增加的税款加在一起， 那么算下来将不但赚不到钱，收入实际上还可能减少。
要点： （1）本题所问内容从玛基和她丈夫的角度讲是没有发生的事情。即回答的内容与事实相反。故答案均采用与事实相反的虚拟语气形式。否则是要扣分的。
（2）问题是why，回答时最好用because开头（尽管省略because也不扣分）。
答案： because they might end up with less money.
或 because they would spend more than their earnings.
或 because their earnings wouldn’t cover the spending.
或 because they couldn’t afford the extra payments of double-worker family.
或 because going back to work might cost more money.
第三题 what are the two major considerations in deciding whether women should go out to work?
题解： 题干中的consideration是寻找答案的关键词。从文章中可以在第三段找到consider一词，这一句明确地说“economic factors are usually the first to be considered”，所以这里的economic factors肯定是答案的一个方面。但问题是“the two major considerations”，所以还有另一方面。根据这句话的下一句话，“the most important aspects of the decision have to do with the emotional needs of each member of the family”可以挑出来，即“the emotional needs”。
要点： 注意组织答案要规范和完善，如果economic factors, emotional needs 为答案的话就不规范， 肯定不会得满分。
答案： economic factors and emotional needs(of each family member)
或one is economic factors, the other is emotional needs.
或they are economic factors and emotional needs.
第四题 some women would rather do housework and take care of their children than pursue a career because they feel______ .
题解： 本题较为简单，从第四段的对比论述可以知道答案在其最后一句话，即homemaking gives them the deepest satisfaction。
要点： 本题只答出从句部分即为正确答案，不要画蛇添足。
答案： satisfied with homemaking
或 that homemaking gives them the deepest satisfaction
或that homemaking and being with children give them deepest satisfaction
第五题 if given a second chance, the writer would probably choose to ______ .
题解： 此题属于推断类题。在第五段里，作者通过自身的体验总结说，不要轻易放弃家庭生活，她对自己迫不及待地出去工作表示后悔，并表示但愿能享受一下与自己的孩子在一起看世界的快乐。由此可断定， 若有机会她宁愿与女儿即家人呆在一起， 所以答案为stay home with her little girl 或 stay home and enjoy family life.
1月
文章导读
为什么会产生交通事故？是不是因为车辆的速度太快了？本文第一段借英国公路交通法有关速度限制方面的发展与变更来影射这个回答。第二段指出超速是现在英国最普遍的机动车违规，并列举了三种违规现象。那么在多大程度上限速能减少交通事故呢？第三段列举了不同历史时期的数字加以佐证。文章最后一段提出了另一种看法，即在美国， 事故数字的减少被归因于交通密度的增加。
第一题 during which period could british motorists drive without speed limits?
题解 这一题要求综合第一段的第3、4、5三句来解答。第三句说到1930“speeding restrictions were done away with altogether”，接下来又说，“for five years motorists were free to drive at whatever speeds they liked”，因此可知，无速度限制的时间是从1930年起（包括1930年），延续了5年，即是1930、1931、1932、1933、1934这五年。最后一句“then in 1935 the road traffic act imposed a 30 m. p. h. speed limit in built-up areas”，说明到了1935年，speed limit又实行了。
要点： 提问是“during which period”，答案中只要给出一个时间的表达式就可以了，没有必要以整句作答，以免言多有失。有一位考生这样回答：during 1930 and 1935 could british motorists drive without speed limits. 姑且字数多了一个不说，这个倒装也有点问题。松一点的评委给1.5分，严一点的给1分，你说亏不亏？
答案： from 1930 to 1935.
或between 1930 and 1935
或1930、1931、1932、1933、1934。
第二题 what measures were adopted in 1935 in addition to the speeding restrictions?
题解 题干中的1935是寻找答案的明确线索，明显应在第一段的最后一句话“then in 1935 the road traffic act imposed a 30m. p. h. speed limit in built-up areas, along with the introduction of driving tests and pedestrian crossings”。题干中的speed restrictions对应于这句话中的a 30 m. p. h. speed limit in built-up areas，剩下的自然就是the introduction of driving tests and pedestrian crossings。
要点 本题只要回答出what measures即可，没有必要再加上谓语部分。
答案 driving tests and pedestrian crossings.
或 the introduction of driving tests and pedestrian crossings.
第三题 speeding is a motoring offense a driver commits when he __________.
题解 从题干中的“motoring offense”出现在第二段的第一句话。这句话也就是第二段的主题句。它总领了后面对三种speeding的描述，在这三种情况中，speeding都是exceeding the … (speed) limit。
要点 空格中要求填的是谓语，用动词来解释speeding这个词，因此必须填动词的形式。同时要注意第三人称单数和时态。
答案 exceeds the speed limits. 或 drives over the speed limit 或 breaking the speeding laws.
第四题what is the opinion of british authorities concerning speeding laws?
题解 题干中的british authorities即是指第三段第二句话中的the ministry of transport，而这句话中的maintain一词则是引述中常用的一个词，常表示“……认为”的意思，那么它后面的内容就是本题的答案了。
要点 （1）本题较好回答，但要注意避免原文照抄，否则会被扣掉0.5分。其实只要将“the ministry of transport maintains”改成“they maintain”（注意单复数）就行了。
（2）简练作答的话，要注意把宾语从句的引导词“that”舍掉，否则显得有些多余，弄不好会丢分。
答案 speed limits reduce accidents. 或speed limits help reduce accidents.
第五题 what reason do americans give for the reduction in traffic accidents?
题解 在四级考试中，也有很多送分的题。本题中的“americans”告诉我们它的答案肯定在最后一段。其实，只要大体上读懂第四段的第一句话，看出其中的“due（rather）to”是表示原因的即能做出正确答案，即“the increase in traffic density”。
要点 注意与问题所问的方式一致， 否则要扣分。
1.外出务工经商的人申请入党，应该如何提出申请?
外出务工经商人员申请入党，若其有相对固定的工作单位或地点，应向现工作单位或经商地工商行政管理部门的党组织提出人党申请。否则，应向其原所在单位党组织或其户口所在地党组织提出入党申请。其原单位党组织或其户口所在地党组织要热情接收外出务工经商人员的入党申请，并负责对其进行培养、教育和考察，经常督促他们的学习，了解和掌握他们在外出期间的工作、学习和生活情况，积极进行帮助。当他们具备了共产党员条件后，外出务工经商所在地党组织要征求原单位党组织或其户口所在地党组织的意见，及时将他们吸收到党内来。外出务工经商人员也要经常、主动地向党组织汇报思想、工作和学习情况，积极接受党组织的培养教育和考察，争取早日加入党组织。
2.借调到外单位工作的同志要求入党，应向哪里的党组织提出申请?
临时或短期(两年以内)借调到外单位工作的同志要求入党，入党申请应向原所在单位党组织提出，并由该党组织负责对其进行培养、教育和考察。如果借调时间超过两年的，入党申请应向现在单位党组织提出，并由现在单位党组织负责对其培养、教育和考察。借调单位和原单位党组织均应主动关心这些同志的思想、工作等情况，并保持一定联系。在被借调同志中发展党员时，借调单位党组织一定要主动征询其原单位党组织的意见。
3.待业或自谋职业的人要求人党，向哪里的党组织提出申请?
由于待业或自谋职业的人一般归街道负责管理，所以，他们的人党申请应向居住地街道党组织提出，并由街道党组织负责对其进行培养、教育和考察;参加了个体劳动者协会的人要求入党，可向个体劳动者协会或其主管部门党组织提出申请。接受申请的党组织负责对他们进行培养、教育和考察，在他们具备党员条件时，适时地吸收他们人党。
4.归侨、侨眷能否申请入党?
归侨、侨眷能够申请人党。党组织对待积极申请入党的归侨、侨眷，应和国内其他申请入党的人一样，按照党章规定，积极进行培养教育，成熟一个，发展一个。对于他们在国外的历史、家庭和社会关系都要做历史的、具体的分析。他们能否入党，主要看其本人的政治立场、思想觉悟和实际表现是否具备党员条件。
5.应当怎样对待在重大政治斗争中犯过一般性错误的人申请入党?
对在重大政治斗争中犯过错误的人申请入党，党组织要历史地、全面地进行具体分析。既不能因其犯过错误就拒绝他的入党要求，也不能不看其所犯错误的性质、程度以及对待错误的态度和改正情况，而轻率地吸收其人党。对犯有一般性错误的人，经过党组织的教育，对所犯错误检查、认识深刻，并经过较长时间考验，证明其已经改正了错误，能够在政治上同党中央保持一致，自觉贯彻执行党的路线、方针、政策，确已具备党员条件的，可以吸收其入党。
6.申请入党的人工作调动后，是否还要再写入党申请书?
申请入党的人工作调动后，原单位党组织要及时将他的入党申请书，连同其他有关材料一并转给调入单位党组织，以便于新单位党组织了解申请人的情况，对其继续培养、教育和考察。在这种情况下，申请入党的人一般不必再重新递交入党申请书。申请人要主动向新调入单位党组织汇报自己的思想及有关情况。如因某种原因，新调入单位党组织未收到申请人的入党申请书及有关材料，申请人可以向新单位党组织重新递交入党申请书。
7.提出入党申请后，党组织长时间没有讨论怎么办?
在遇到这种情况时，申请入党人应持积极态度，相信党组织，多从自己身上找原因，而且要做到信念不变，积极争取。信念不变，就是要求入党的人决心不能动摇，对党的信任不能改变，要珍重和保持自己的政治热情;党组织没有及时讨论自己的入党问题，其原因是多方面的，可能主要是因为自己身上存在着不成熟的地方，应当经受住党组织的长期考验。积极争取，就是要在学习、工作和社会生活各个方面，继续用共产党员的标准严格要求自己。主动向党组织汇报自己的思想和工作情况，克服缺点、弱点和错误，及时取得党组织的帮助教育，使自己早日成为一名合格的共产党员。
1. 债权和债务的最大区别是什么答案：一个容易记住一个最不容易记住
2. 什么飞机常常没有明确的目的地答案：纸飞机
3. 地球上哪一部分绝对照不到太阳答案：任何地方都照不到太阳因为地球不发光
4. 看书最怕的是什么答案：中间被人弄去几页
5. 请解释擒贼先擒王。答案：丢了东西先驱找姓王的
6. 你知道不可救药的成语是如何产生的吗答案：当药店发生火灾时只能先救人再救药
7. 地球上什么地方温度最高答案：地球的中心
8. 街上那么多的人是从哪来的答案：各自的家中
9. 人到世界上看见的第一个人是谁答案：接生的人
10. 喝牛奶时用哪只手搅拌会比较卫生答案：用那只手都不卫生还是用勺子好
1. 小王和小张两家M,两家又没有电话,小王想找小张又不想出门,怎么办答案：小王可以喊小张
2. 小平平时嘴闭不住,为什么现在一声不吭答案：小平睡着了
3. 亮亮语文和数学共考了分,结果静静得了第一,为什么答案：他们不在同一个班
4. 一个鸭梨,咬哪一部分最甜答案：随便咬的第一口最甜
5. 小明家很富裕,可他想买玩具时却从不向母亲要一分钱,为什么答案：他向他爸爸要钱一分钱也买不到什么玩具
6. 什么虎吓人但不吃人答案：壁虎
7. 永远不能做饭的锅是什么锅答案：罗锅
8. 小明睡觉的时候,妈妈最怕什么答案：小明尿床
9. 什么人永远无忧无虑答案：死了的人.
10. 你每天做作业时先干什么答案：打开本子.
11. 一个人在太阳下走路却看不见自己的影子,为什么答案：因为他撑了一把伞
12. 世界上哪儿的大象最小答案：书上的
13. 小明可以让地球停止或倒转,可能吗答案：可能是个玩具地球
14. 为什么妈妈几个月都不给孩子吃饭可孩子仍然长的很好答案：因为这个孩子还是个胎儿.
15. 如何防止被狗咬答案：不要跑在狗的前面.
16. 谁是世界上最有恒心的画家答案：爱化妆的女人
17. 兔子比什么可以绝对赢乌龟答案：仰卧起做.
18. 什么时候被骗得高兴答案：祝你长生不老呀
19. 如果有一台电脑能替你干一半活,你将怎么办答案：买两台
20. 上次汤姆过生日是七岁,下次他过生日是九岁,这是怎么回事答案：今天他是过八岁生日.
106. Examine the data inthe LIST_PRICE and MIN_PRICE columns of the PRODUCTS table:
LIST_PRICE MIN_PRICE
10000 8000
0
30000 30000
Which two expressionsgive the same output? (Choose two.)
A. NVL(NULLIF(list_price, min_price), 0)
B. NVL(COALESCE(list_price,min_price), 0)
C.NVL2(COALESCE(list_price, min_price), min_price, 0)
D.COALESCE(NVL2(list_price, list_price, min_price), 0)
Answer:BD
解析：
引用官方文档：
NULLIF compares expr1 and expr2. If theyare equal, then the function returns null.
If they are not equal, then the functionreturns expr1. You cannot specify the literal
NULL for expr1
NVL lets you replace null (returned as ablank) with a string in the results of a query. If
expr1 is null, then NVL returns expr2. Ifexpr1 is not null, then NVL returns expr1.
COALESCE returns the first non-null expr inthe expression list. You must specify at
least two expressions. If all occurrencesof expr evaluate to null, then the function
returns null.
NVL2 lets you determine the value returned bya query based on whether a specified
expression is null or not null. If expr1 isnot null, then NVL2 returns expr2. If expr1
is null, then NVL2 returns expr3.
107. View the Exhibitand examine the structure and data in the INVOICE table.
Which two SQL statementswould execute successfully? (Choose two.)
A. SELECT AVG(inv_date )
FROM invoice;
B. SELECTMAX(inv_date),MIN(cust_id)
FROM invoice;
C. SELECTMAX(AVG(SYSDATE - inv_date))
FROM invoice;
D. SELECT AVG( inv_date- SYSDATE), AVG(inv_amt)
FROM invoice;
Answer:BD
解析：
引用官方文档：
This function takes as an argument anynumeric data type or any nonnumeric data
type that can be implicitly converted to anumeric data type. The function returns the
same data type as the numeric data type ofthe argument.
所以A错
A later date is considered greater than anearlier one. For example, the date equivalent
of '29-MAR-' is less than that of'05-JAN-' and '05-JAN-2006 1:35pm' is greater
than '05-JAN-2005 10:09am'.
Oracle compares VARCHAR2 values usingnonpadded
comparison semantics.
所以B正确
C选项中avg得到单一结果，无法使用max函数
所以C错误
D选项中inv_date-sysdate得到数字，所以能使用avg
所以D正确
108. Which twostatements are true regarding the COUNT function? (Choose two.)
A. The COUNT functioncan be used only for CHAR, VARCHAR2, and NUMBER data types.
B. COUNT(*) returns thenumber of rows including duplicate rows and rows containing NULL value in
any of the columns.
C. COUNT(cust_id)returns the number of rows including rows with duplicate customer IDs and NULL
value in the CUST_IDcolumn.
D. COUNT(DISTINCTinv_amt)returns the number of rows excluding rows containing duplicates and
NULL values in theINV_AMT column.
E. A SELECT statementusing the COUNT function with a DISTINCT keyword cannot have a
WHERE clause.
Answer:BD
解析：
A选项，count还可以用在date等数据类型的行上
B选项，如果count不指定distinct的话，就会返回所有的重复行
C选项，count不会计算列为空的
D选项，明确指定了distinct，就不会返回重复行，当然也不会返回空行
E选项，当然可以使用where，测试：
scott@ORCL>select count(distinct comm)from emp where sal>1000;
COUNT(DISTINCTCOMM)
-------------------
4
109. Examine thestructure of the MARKS table:
name Null Type
STUDENT_ID NOT NULLVARCHAR2(4)
STUDENT_NAMEVARCHAR2(25)
SUBJECT1 NUMBER(3)
SUBJECT2 NUMBER(3)
SUBJECT3 NUMBER(3)
Which two statementswould execute successfully? (Choose two.)
A. SELECT student_name,subject1
FROM marks
WHERE subject1 >AVG(subject1);
B. SELECTstudent_name,SUM(subject1)
FROM marks
WHERE student_name LIKE'R%';
C. SELECTSUM(subject1+subject2+subject3)
FROM marks
WHERE student_name ISNULL;
D. SELECT SUM(DISTINCTNVL(subject1,0)), MAX(subject1)
FROM marks
WHERE subject1 >subject2;
Answer:CD
解析：
A选项，不能在where后使用聚集函数
B选项，这里没有分组，无法使用sum
C，D正确
110. View the Exhibitand examine the structure of the CUSTOMERS table.
Using the CUSTOMERStable, you need to generate a report that shows the average credit limit for
customers in WASHINGTONand NEW YORK.
Which SQL statementwould produce the required result?
A. SELECT cust_city,AVG(cust_credit_limit)
FROM customers
WHERE cust_city IN('WASHINGTON','NEW YORK')
GROUP BYcust_credit_limit, cust_city;
B. SELECT cust_city,AVG(cust_credit_limit)
FROM customers
WHERE cust_city IN('WASHINGTON','NEW YORK')
GROUP BYcust_city,cust_credit_limit;
C. SELECT cust_city,AVG(cust_credit_limit)
FROM customers
WHERE cust_city IN('WASHINGTON','NEW YORK')
GROUP BY cust_city;
D. SELECT cust_city,AVG(NVL(cust_credit_limit,0))
FROM customers
WHERE cust_city IN('WASHINGTON','NEW YORK');
Answer:C
解析：
这里考察和上题的B选项一样，需要分组，才能使用avg()函数
所以正确答案为C选项
111. View the Exhibitand examine the structure of the CUSTOMERS table.
Which statement woulddisplay the highest credit limit available in each income level in each city inthe
CUSTOMERS table?
A. SELECT cust_city,cust_income_level, MAX(cust_credit_limit )
FROM customers
GROUP BY cust_city,cust_income_level, cust_credit_limit;
B. SELECT cust_city,cust_income_level, MAX(cust_credit_limit)
FROM customers
GROUP BY cust_city,cust_income_level;
C. SELECT cust_city,cust_income_level, MAX(cust_credit_limit)
FROM customers
GROUP BYcust_credit_limit, cust_income_level, cust_city ;
D. SELECT cust_city,cust_income_level, MAX(cust_credit_limit)
FROM customers
GROUP BY cust_city,cust_income_level, MAX(cust_credit_limit);
Answer:B
解析：
这里也和上题考察的知识点一样，需要分组，并以cust_city和cust_income_level
所以正确答案为B选项
Answer:B
112. View the Exhibitand examine the structure of the PROMOTIONS table.
Evaluate the followingSQL statement:
SQL>SELECTpromo_category, AVG(promo_cost) Avg_Cost, AVG(promo_cost)*.25 Avg_Overhead
FROM promotions
WHEREUPPER(promo_category) IN ('TV', 'INTERNET','POST')
GROUP BY Avg_Cost
ORDER BY Avg_Overhead;
The above querygenerates an error on execution.
Which clause in theabove SQL statement causes the error?
A. WHERE
B. SELECT
C. GROUP BY
D. ORDER BY
Answer:C
解析：
Group by 后面不能用分组函数
所以C正确
113. Examine the structureof the ORDERS table:
Name Null Type
ORDER_ID NOT NULLNUMBER(12)
ORDER_DATE NOT NULLTIMESTAMP(6)
CUSTOMER_ID NOT NULLNUMBER(6)
ORDER_STATUS NUMBER(2)
ORDER_TOTAL NUMBER(8,2)
You want to find thetotal value of all the orders for each year and issue the following command:
SQL>SELECTTO_CHAR(order_date,'rr'), SUM(order_total)
FROM orders
GROUP BYTO_CHAR(order_date,'yyyy');
Which statement is trueregarding the outcome?
A. It executessuccessfully and gives the correct output.
B. It gives an errorbecause the TO_CHAR function is not valid.
C. It executessuccessfully but does not give the correct output.
D. It gives an errorbecause the data type conversion in the SELECT list does not match the datatype
conversion in the GROUPBY clause.
Answer:D
解析：
To_char需要前后转换格式一样，测试：
scott@ORCL>select to_char(hiredate,'rr') from emp group byto_char(hiredate,'yyyy')
2 ;
selectto_char(hiredate,'rr') from emp group by to_char(hiredate,'yyyy')
*
第 1 行出现错误:
ORA-00979: 不是 GROUP BY 表达式
114. View the Exhibitand examine the structure of the SALES table.
The following query iswritten to retrieve all those product ID s from the SALES table that have morethan
55000 sold and have beenordered more than 10 times.
SQL>SELECT prod_id
FROM sales
WHERE quantity_sold >55000 AND COUNT(*)>10
GROUP BY prod_id
HAVING COUNT(*)>10;
Which statement is trueregarding this SQL statement?
A. It executessuccessfully and generates the required result.
B. It produces an errorbecause COUNT(*) should be specified in the SELECT clause also.
C. It produces an errorbecause COUNT(*) should be only in the HAVING clause and not in the WHERE
clause.
D. It executessuccessfully but produces no result because COUNT(prod_id) should be usedinstead of
COUNT(*).
Answer:C
解析：
Where后面不能用分组函数
所以C选项正确
115. View the Exhibitand examine the structure of the CUSTOMERS table.
Evaluate the followingSQL statement:
SQL>SELECTcust_city, COUNT(cust_last_name)
FROM customers
WHERE cust_credit_limit>1000
GROUP BY cust_city
HAVING AVG(cust_credit_limit)BETWEEN 5000 AND 6000;
Which statement is trueregarding the outcome of the above query?
A. It executessuccessfully.
B. It returns an errorbecause the BETWEEN operator cannot be used in the HAVING clause.
C. It returns an error becauseWHERE and HAVING clauses cannot be used in the same SELECT
statement.
D. It returns an errorbecause WHERE and HAVING clauses cannot be used to apply conditions on the
same column.
Answer:A
解析：
Group by 后面可以用分组函数
所以A选项正确
116. Examine the data inthe ORD_ITEMS table:
ORD_NO ITEM_NO QTY
1 111 10
1 222 20
1 333 30
2 333 30
2 444 40
3 111 40
You want to find out ifthere is any item in the table for which the average maximum quantity is morethan
50.
You issue the followingquery:
SQL>SELECT AVG(MAX(qty))
FROM ord_items
GROUP BY item_no
HAVINGAVG(MAX(qty))>50;
Which statement is trueregarding the outcome of this query?
A. It executessuccessfully and gives the correct output.
B. It gives an errorbecause the HAVING clause is not valid.
C. It executessuccessfully but does not give the correct output.
D. It gives an errorbecause the GROUP BY expression is not valid.
Answer:B
解析：
Having后不能使用嵌套分组函数，测试:
scott@ORCL>selectavg(max(sal)) from emp group by empno having avg(max(sal));
select avg(max(sal))from emp group by empno having avg(max(sal))
*
第 1 行出现错误:
ORA-00935: 分组函数的嵌套太深
117. Which statementsare true regarding the WHERE and HAVING clauses in a SELECT statement?
(Choose all that apply.)
A. The HAVING clause canbe used with aggregate functions in subqueries.
B. The WHERE clause canbe used to exclude rows after dividing them into groups.
C. The WHERE clause canbe used to exclude rows before dividing them into groups.
D. The aggregatefunctions and columns used in the HAVING clause must be specified in the SELECTlist
of the query.
E. The WHERE and HAVINGclauses can be used in the same statement only if they are applied to
different columns in thetable.
Answer:AC
解析：
Group by后可以使用聚集函数，而where 后不可以使用
Group by后使用的聚集函数不用首先在select中指定
所以A，C正确
118. View the Exhibitand examine the structure of the PROMOTIONS table.
Examine the followingtwo SQL statements:
Statement 1
SQL>SELECTpromo_category,SUM(promo_cost)
FROM promotions
WHEREpromo_end_date-promo_begin_date >30
GROUP BY promo_category;
Statement 2
SQL>SELECTpromo_category,sum(promo_cost)
FROM promotions
GROUP BY promo_category
HAVINGMIN(promo_end_date-promo_begin_date)>30;
Which statement is trueregarding the above two SQL statements?
A. statement 1 gives anerror, statement 2 executes successfully
B. statement 2 gives anerror, statement 1 executes successfully
C. statement 1 andstatement 2 execute successfully and give the same output
D. statement 1 andstatement 2 execute successfully and give a different output
Answer:D
解析：
都无语法错误，statement 1先筛选行，再进行分组排列
Statement 2 先分组，再筛选，测试：
scott@ORCL>select job,sum(sal) from emp where sysdate-hiredate>11700group by job;
JOB SUM(SAL)
--------- ----------
CLERK 968
SALESMAN 5600
PRESIDENT 6300
MANAGER 8749.24
scott@ORCL>selectjob,sum(sal) from emp group by job having min(sysdate-hiredate)>11700;
JOB SUM(SAL)
--------- ----------
SALESMAN 5600
PRESIDENT 6300
MANAGER 8749.24
119. Examine the data inthe ORD_ITEMS table:
ORD_NO ITEM_NO QTY
1 111 10
1 222 20
1 333 30
2 333 30
2 444 40
3 111 40
Evaluate the followingquery:
SQL>SELECT item_no,AVG(qty)
FROM ord_items
HAVING AVG(qty) >MIN(qty) * 2
GROUP BY item_no;
Which statement is trueregarding the outcome of the above query?
A. It gives an errorbecause the HAVING clause should be specified after the GROUP BY clause.
B. It gives an errorbecause all the aggregate functions used in the HAVING clause must be specifiedin
the SELECT list.
C. It displays the itemnos with their average quantity where the average quantity is more than doublethe
minimum quantity of thatitem in the table.
D. It displays the itemnos with their average quantity where the average quantity is more than doublethe
overall minimum quantityof all the items in the table.
Answer:C
解析：
没有语法错误，得到item_no, AVG(qty)并且AVG(qty) >MIN(qty) * 2
所以C选择正确
120. View the Exhibitsand examine the structures of the PRODUCTS, SALES, and CUSTOMERS
tables.
You issue the followingquery:
SQL>SELECTp.prod_id,prod_name,prod_list_price,
quantity_sold,cust_last_name
FROM products p NATURALJOIN sales s NATURAL JOIN customers c
WHERE prod_id =148;
Which statement is trueregarding the outcome of this query?
A. It executessuccessfully.
B. It produces an errorbecause the NATURAL join can be used only with two tables.
C. It produces an errorbecause a column used in the NATURAL join cannot have a qualifier.
D. It produces an errorbecause all columns used in the NATURAL join should have a qualifier.
Answer:C
解析：
引用官方文档：
When specifying columnsthat are involved in the natural join, do not qualify
the column name with atable name or table alias.
所以C选项正确
121. Which twostatements are true regarding the USING clause in table joins? (Choose two .)
A. It can be used tojoin a maximum of three tables.
B. It can be used torestrict the number of columns used in a NATURAL join.
C. It can be used toaccess data from tables through equijoins as well as nonequijoins.
D. It can be used tojoin tables that have columns with the same name and compatible data types.
Answer:BD
解析：
引用官方文档：
When you are specifyingan equijoin of columns that have the same
name in both tables, theUSING column clause indicates the columns to be used. You
can use this clause onlyif the join columns in both tables have the same name. Within
this clause, do notqualify the column name with a table name or table alias.
Restriction on the USINGcolumn Clause
■ Within this clause, donot qualify the column name with a table name or table
alias.
■ You cannot specify aLOB column or a collection column in the USING column
clause.
■ You cannot specify thisclause with a NATURAL outer join.
122. View the Exhibit forthe structure of the STUDENT and FACULTY tables.
You need to display thefaculty name followed by the number of students handled by the faculty at the
base location.
Examine the followingtwo SQL statements:
Statement 1
SQL>SELECTfaculty_name,COUNT(student_id)
FROM student JOINfaculty
USING (faculty_id,location_id)
GROUP BY faculty_name;
Statement 2
SQL>SELECTfaculty_name,COUNT(student_id)
FROM student NATURALJOIN faculty
GROUP BY faculty_name;
Which statement is trueregarding the outcome?
A. Only s tatement 1executes successfully and gives the required result.
B. Only statement 2executes successfully and gives the required result.
C. Both statements 1 and2 execute successfully and give different results.
D. Both statements 1 and2 execute successfully and give the same required result.
Answer:D
解析：
USING (faculty_id,location_id)和NATURAL JOIN效果一样
123. View the Exhibitsand examine the structures of the PRODUCTS, SALES, and CUSTOMERS
tables.
You need to generate areport that gives details of the customer's last name, name of the product, and
the quantity sold forall customers in ' Tokyo' .
Which two queries givethe required result? (Choose two.)
A. SELECTc.cust_last_name,p.prod_name, s.quantity_sold
FROM sales s JOINproducts p
USING(prod_id)
JOIN customers c
USING(cust_id)
WHEREc.cust_city='Tokyo';
B. SELECTc.cust_last_name, p.prod_name, s.quantity_sold
FROM products p JOINsales s JOIN customers c
ON(p.prod_id=s.prod_id)
ON(s.cust_id=c.cust_id)
WHEREc.cust_city='Tokyo';
C. SELECT c.cust_last_name,p.prod_name, s.quantity_sold
FROM products p JOINsales s
ON(p.prod_id=s.prod_id)
JOIN customers c
ON(s.cust_id=c.cust_id)
AND c.cust_city='Tokyo';
D. SELECTc.cust_id,c.cust_last_name,p.prod_id, p.prod_name, s.quantity_sold
FROM products p JOINsales s
USING(prod_id)
JOIN customers c
USING(cust_id)
WHEREc.cust_city='Tokyo';
Answer:AC
解析：
A选项，使用USING(prod_id)连接 sales比表和product表 使用USING(prod_id)连接sales表和customers表
C选项，ON(p.prod_id=s.prod_id)和ON(s.cust_id=c.cust_id)与A选项中的using效果一样
124. View the Exhibitand examine the structure of the PROMOTIONS, SALES, and CUSTOMER tables.
You need to generate areport showing the promo name along with the customer name for all products
that were sold duringtheir promo campaign and before 30th October .
You issue the followingquery:
SQL>SELECTpromo_name,cust_name
FROM promotions p JOINsales s
ON(time_id BETWEENpromo_begin_date AND promo_end_date)
JOIN customer c
ON (s.cust_id =c.cust_id) AND time_id < '30-oct-2007';
Which statement is true regardingthe above query?
A. It executessuccessfully and gives the required result.
B. It executessuccessfully but does not give the required result.
C. It produces an errorbecause the join order of the tables is incorrect.
D. It produces an errorbecause equijoin and nonequijoin conditions cannot be used in the same SELECT
statement.
Answer:B
解析：
题目要求：
showing the promo namealong with the customer name for all products
that were sold duringtheir promo campaign and before 30th October 2007
不应该在连接表的时候就加上条件，应该在把条件最后面
125. Examine thestructure of the CUSTOMERS table:
name Null Type
CUSTNO NOT NULLNUMBER(3)
CUSTNAME NOT NULLVARCHAR2(25)
CUSTADDRESS VARCHAR2(35)
CUST_CREDIT_LIMITNUMBER(5)
CUSTNO is the PRIMARYKEY in the table. You want to find out if any customers' details have been
entered more than onceusing different CUSTNO, by listing all the duplicate names.
Which two methods canyou use to get the required result? (Choose two.)
A. self-join
B. subquery
C. full outer-join withself-join
D. left outer-join withself-join
E. right outer-join withself-join
Answer:AB
解析：
find out if any customers'details have been
entered more thanonce using different CUSTNO, by listing all the duplicate names.
需要用自连接比较names
需要使用子查询得到customers'details have beenentered more than once using different CUSTNO
126. View the Exhibitand examine the data in the PROJ_TASK_DETAILS table.
The PROJ_TASK_DETAILStable stores information about tasks involved in a project and the relation
between them.
The BASED_ON columnindicates dependencies between tasks. Some tasks do not depend on the
completion of any othertasks.
You need to generate areport showing all task IDs, the corresponding task ID they are dependent on,and
the name of the employeein charge of the task it depends on.
Which query would givethe required result?
A. SELECT p.task_id,p.based_on, d.task_in_charge
FROM proj_task_details pJOIN proj_task_details d
ON (p.based_on =d.task_id);
B. SELECT p.task_id,p.based_on, d.task_in_charge
FROM proj_task_details pLEFT OUTER JOIN proj_task_details d
ON (p.based_on =d.task_id);
C. SELECT p.task_id,p.based_on, d.task_in_charge
FROM proj_task_details pFULL OUTER JOIN proj_task_details d
ON (p.based_on =d.task_id);
D. SELECT p.task_id,p.based_on, d.task_in_charge
FROM proj_task_details pJOIN proj_task_details d
ON (p.task_id =d.task_id);
Answer:B
解析：
showing all task IDs,the corresponding task ID they are dependent on, and
the name of the employeein charge of the task it depends on.
题目的意思不管是否有depend on 都需要排列出来，这时候就需要左外连接
引用官方文档：
■ A left outer joinreturns all the common column values from the left table in the
FROM clause.
■ A right outer joinreturns all the common column values from the right table in the
FROM clause.
■ A full outer joinreturns all the common column values from both joined tables.
127. Examine the data inthe CUSTOMERS table:
CUSTNO CUSTNAME CITY
1 KING SEATTLE
2 GREEN BOSTON
3 KOCHAR SEATTLE
4 SMITH NEW YORK
You want to list allcities that have more than one customer along with the customer details.
Evaluate the followingquery:
SQL>SELECTc1.custname, c1.city
FROM Customers c1__________________ Customers c2
ON (c1.city=c2.city ANDc1.custnamec2.custname);
Which two JOIN optionscan be used in the blank in the above query to give the correct output? (Choose
two.)
A. JOIN
B. NATURAL JOIN
C. LEFT OUTER JOIN
D. FULL OUTER JOIN
E. RIGHT OUTER JOIN
Answer:AE
解析：
引用官方文档：
■ A left outer joinreturns all the common column values from the left table in the
FROM clause.
■ A right outer join returns all the common column valuesfrom the right table in the
FROM clause.
■ A full outer join returns all the common column valuesfrom both joined tables.
128. View the Exhibitsand examine the structures of the CUSTOMERS, SALES, and COUNTRIES
tables.
You need to generate areport that shows all country names, with corresponding customers (if any) and
sales details (if any),for all customers.
Which FROM clause givesthe required result?
A. FROM sales JOINcustomers USING (cust_id)
FULL OUTER JOINcountries USING (country_id);
B. FROM sales JOINcustomers USING (cust_id)
RIGHT OUTER JOINcountries USING (country_id);
C. FROM customers LEFTOUTER JOIN sales USING (cust_id)
RIGHT OUTER JOINcountries USING (country_id);
D. FROM customers LEFTOUTER JOIN sales USING (cust_id)
LEFT OUTER JOINcountries USING (country_id);
Answer:C
解析：
引用官方文档：
■ A left outer joinreturns all the common column values from the left table in the
FROM clause.
■ A right outer join returns all the common column values from the righttable in the
FROM clause.
129. View the Exhibitsand examine the structures of the PROMOTIONS and SALES tables.
Evaluate the followingSQL statement:
SQL>SELECTp.promo_id, p.promo_name, s.prod_id
FROM sales s RIGHT OUTERJOIN promotions p
ON (s.promo_id =p.promo_id);
Which statement is trueregarding the output of the above query?
A. It gives the detailsof promos for which there have been sales.
B. It gives the detailsof promos for which there have been no sales.
C. It gives details ofall promos irrespective of whether they have resulted in a sale or not.
D. It gives details ofproduct ID s that have been sold irrespective of whether they had a promo ornot.
Answer:C
解析：
引用官方文档：
■ A left outer joinreturns all the common column values from the left table in the
FROM clause.
■ A right outer join returns all the common column values from the righttable in the
FROM clause.
130. View the Exhibitand examine the data in the EMPLOYEES table:
You want to display allthe employee names and their corresponding manager names.
Evaluate the followingquery:
SQL>SELECTe.employee_name “EMP NAME”, m.employee_name “MGR NAME”
FROM employees e______________ employees m
ON e.manager_id =m.employee_id;
Which JOIN option can beused in the blank in the above query to get the required output?
A. o nly inner JOIN
B. only FULL OUTER JOIN
C. only LEFT OUTER JOIN
D. only RIGHT OUTER JOIN
Answer:C
解析：
引用官方文档：
■ A left outer joinreturns all the common column values from the left table in the
FROM clause.
■ A right outer join returns all the common column values from the righttable in the
FROM clause.
131. View the Exhibitand examine the structure of the PRODUCT, COMPONENT, and PDT_COMP
tables.
In PRODUCT table, PDTNOis the primary key.
In COMPONENT table,COMPNO is the primary key.
In PDT_COMP table,(PDTNO,COMPNO) is the primary key, PDTNO is the foreign key referencing
PDTNO in PRODUCT tableand COMPNO is the foreign key referencing the COMPNO in COMPONENT
table.
You want to generate areport listing the product names and their corresponding component names, ifthe
component names andproduct names exist.
Evaluate the followingquery:
SQL>SELECTpdtno,pdtname, compno,compname
FROM product _____________pdt_comp
USING (pdtno)____________ component USING(compno)
WHERE compname IS NOTNULL;
Which combination ofjoins used in the blanks in the above query gives the correct output?
A. JOIN; JOIN
B. FULL OUTER JOIN; FULLOUTER JOIN
C. RIGHT OUTER JOIN; LEFTOUTER JOIN
D. LEFT OUTER JOIN;RIGHT OUTER JOIN
Answer:C
解析：
题意：if the componentnames and product names exist. 存在就列出来
引用官方文档：
■ A left outer joinreturns all the common column values from the left table in the
FROM clause.
■ A right outer joinreturns all the common column values from the right table in the
FROM clause.
132. View the Exhibitand examine the structure of the SALES and PRODUCTS tables.
In the SALES table,PROD_ID is the foreign key referencing PROD_ID in the PRODUCTS table,
You want to list eachproduct ID and the number of times it has been sold.
Evaluate the followingquery:
SQL>SELECT p.prod_id,COUNT(s.prod_id)
FROM products p_____________ sales s
ON p.prod_id = s.prod_id
GROUP BY p.prod_id;
Which two JOIN optionscan be used in the blank in the above query to get the required output? (Choose
two.)
A. JOIN
B. FULL OUTER JOIN
C. LEFT OUTER JOIN
D. RIGHT OUTER JOIN
Answer:BC
解析：
题意：You want to listeach product ID and the number of times it has been sold，需要列出每个product id 所以需要将 products表中全部列查询
引用官方文档：
■ A left outer joinreturns all the common column values from the left table in the
FROM clause.
■ A right outer joinreturns all the common column values from the right table in the
FROM clause.
■ A full outer joinreturns all the common column values from both joined tables.
133. Which twostatements are true regarding subqueries? (Choose two.)
A. A subquery canretrieve zero or more rows.
B. Only two subqueriescan be placed at one level.
C. A subquery can beused only in SQL query statements.
D. A subquery can appearon either side of a comparison operator.
E. There is no limit onthe number of subquery levels in the WHERE clause of a SELECT statement.
Answer:AD
解析：
引用官方文档：
A subquery answers multiple-partquestions 所以A选项正确
B选项，可以有多个子查询在同一级上 所以B选项错误
C选项，create table zbcxy as select * from emp wheresal>(select avg(sal) from emp );
所以C选项错误
D选项 在运算符那一边结果一样 所以正确
E选项，引用官方文档：A subquery can contain another subquery. Oracle Databaseimposes no limit on the number of subquery levels in the FROM clause of the top-levelquery. You can nest up to 255 levels of subqueries in the WHERE clause.
所以E选项错误
134. Where cansubqueries be used? (Choose all that apply.)
A. field names in theSELECT statement
B. the FROM clause inthe SELECT statement
C. the HAVING clause inthe SELECT statement
D. the GROUP BY clausein the SELECT statement
E. the WHERE clause inonly the SELECT statement
F. the WHERE clause inSELECT as well as all DML statements
Answer:ABCF
解析：
D选项，group by 后面只能用列名
F选项，很明显不一样
135. Which threestatements are true regarding subqueries? (Choose three.)
A. Subqueries cancontain GROUP BY and ORDER BY clauses.
B. Main query andsubquery can get data from different tables.
C. Main query and subquerymust get data from the same tables.
D. Subqueries cancontain ORDER BY but not the GROUP BY clause.
E. Only one column orexpression can be compared between the main query and subquery.
F. Multiple columns orexpressions can be compared between the main query and subquery.
Answer:ABF
解析：
C选项，select * from dept where deptno=(select deptno from empwhere empno=7788);
D选项，select * from emp where deptno in (select deptno from empgroup by deptno);
E选项，select * from emp where deptno in (select deptno from empgroup by deptno);
136. View the Exhibitand examine the structure of the PRODUCTS table.
Which two tasks wouldrequire subqueries? (Choose two.)
A. Display the minimumlist price for each product status.
B. Display all supplierswhose list price is less than 1000.
C. Display the number ofproducts whose list price is more than the average list price.
D. Display the totalnumber of products supplied by supplier 102 and have product status as'obsolete'.
E. Display all productswhose minimum list price is more than the average list price of products andhave
the status 'orderable'.
Answer:CE
解析：
C选项，查询平均价格作为子查询
E选项，the average list price of products and have the status'orderable'需要作为子查询
137. View the Exhibitsand examine PRODUCTS and SALES tables.
You issue the followingquery to display product name and the number of times the product has been
sold:
SQL>SELECTp.prod_name, i.item_cnt
FROM (SELECT prod_id,COUNT(*) item_cnt
FROM sales
GROUP BY prod_id) iRIGHT OUTER JOIN products p
ON i.prod_id =p.prod_id;
What happens when theabove statement is executed?
A. The statementexecutes successfully and produces the required output.
B. The statementproduces an error because ITEM_CNT cannot be displayed in the outer query.
C. The statement producesan error because a subquery in the FROM clause and outer-joins cannot be
used together.
D. The statementproduces an error because the GROUP BY clause cannot be used in a subquery inthe
FROM clause.
Answer:A
解析：
将 SELECT prod_id, COUNT(*) item_cnt
FROM sales
GROUP BY prod_id
的查询结果作为一张表和product表右外连接 ，可以得到product中每个产品的销售次数
138. Which statement istrue regarding subqueries?
A. The LIKE operatorcannot be used with single- row subqueries.
B. The NOT IN operatoris equivalent to IS NULL with single- row subqueries.
C. =ANY and =ALLoperators have the same functionality in multiple- row subqueries.
D. The NOT operator canbe used with IN, ANY, and ALL operators in multiple- row subqueries.
Answer:D
解析：
A选项，测试： scott@ORCL>select * from emp where ename like (selectename from emp where empno=7788);
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ------------------- ---------- -------- ---------- ---------- ----------
7788 SCOTT ANALYST 7566 19-04-87 1850 20
B选项，不相等，not in 如果不处理子查询中的空值，就会全部返回为空
C选项，功能不一样，any表示已任意一个，all表示全部
139. Which threestatements are true about multiple-row subqueries? (Choose three.)
A. They can contain asubquery within a subquery.
B. They can returnmultiple columns as well as rows.
C. They cannot contain asubquery within a subquery.
D. They can return onlyone column but multiple rows.
E. They can containgroup functions and GROUP BY and HAVING clauses.
F. They can containgroup functions and the GROUP BY clause, but not the HAVING clause.
Answer:ABE
解析：
C选项，子查询可以嵌套
应用官方文档：
A subquery can containanother subquery. Oracle Database imposes no limit on the
number of subquerylevels in the FROM clause of the top-level query. You can nest up
to 255 levels ofsubqueries in the WHERE clause
D选项，可以返回多列多行
F选项，测试：
scott@ORCL>select *from emp where job in(select job from emp group by job having job like 'S%');
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ------------------- ---------- -------- ---------- ---------- ----------
7844 TURNER SALESMAN 7698 08-09-81 1500 0 30
7654 MARTIN SALESMAN 7698 28-09-81 1250 1400 30
7521 WARD SALESMAN 7698 22-02-81 1250 500 30
7499 ALLEN SALESMAN 7698 20-02-81 1600 160 30
140. Examine thestructure of the PRODUCTS table:
name Null Type
PROD_ID NOT NULLNUMBER(4)
PROD_NAME VARCHAR2(20)
PROD_STATUS VARCHAR2(6)
QTY_IN_HAND NUMBER(8,2)
UNIT_PRICE NUMBER(10,2)
You want to display thenames of the products that have the highest total value for UNIT_PRICE *
QTY_IN_HAND.
Which SQL statementgives the required output?
A. SELECT prod_name
FROM products
WHERE (unit_price *qty_in_hand) = (SELECT MAX(unit_price * qty_in_hand)
FROM products);
B. SELECT prod_name
FROM products
WHERE (unit_price *qty_in_hand) = (SELECT MAX(unit_price * qty_in_hand)
FROM products
GROUP BY prod_name);
C. SELECT prod_name
FROM products
GROUP BY prod_name
HAVING MAX(unit_price *qty_in_hand) = (SELECT MAX(unit_price * qty_in_hand)
FROM products
GROUP BY prod_name);
D. SELECT prod_name
FROM products
WHERE (unit_price *qty_in_hand) = (SELECT MAX(SUM(unit_price * qty_in_hand))
FROM products)
GROUP BY prod_name;
Answer:A
解析：
(SELECT MAX(unit_price* qty_in_hand) FROM products) 得到unit_price *qty_in_hand的最大值
SELECT prod_name
FROM products
WHERE (unit_price* qty_in_hand) = (SELECT MAX(unit_price * qty_in_hand)
FROM products);
(unit_price *qty_in_hand) =最大值 所以能得到正确的结果
回答
北岛
卑鄙是卑鄙者的通行证，
高尚是高尚者的墓志铭。
看吧，在那镀金的天空中，
飘满了死者弯曲的倒影。
冰川纪过去了，
为什么到处都是冰凌?
好望角发现了，
为什么死海里千帆相竞?
我来到这个世界上，
只带着纸、绳索和身影，
为了在审判之前，
宣读那些被判决的声音：
告诉你吧，世界
我──不──相──信!
纵使你脚下有一千名挑战者，
那就把我算做第一千零一名。
我不相信天是蓝的;
我不相信雷的回声，
我不相信梦是假的;
我不相信死无报应。
如果海洋注定要决堤，
就让所有的苦水都注入我心中;
如果陆地注定要上升，
就让人类重新选择生存的峰顶。
新的转机和闪闪星斗，
正在缀满没有遮拦的天空，
那是五千年的象形文字
那是未来人们凝视的眼睛。
注：这首诗写于1976年“四五”运动之中，是以“我”为代表的觉醒的一代，对“世界”即十年**的中国的“回答”。
1.这首诗表达了作者怎样的思想感情?
__________________________________
2.作者尖锐而有力地概括和嘲讽了十年**所造成的荒谬现实的诗句是
__________________________________
3.作者连用四个“我不相信”组成的排比，表达了作者怎样的思想感情?
____________________________________
4.虽然诗人在文中宣布“我不相信”，但是并没有在对现实的怀疑和否定中陷入虚无，而是选择了自觉地承担改造世界的使命。你从哪些诗句中可以感悟出来?
____________________________________
5.你认为“我”有可能代表着怎样一种人?请你联系实际生活加以简单的评价。
_____________________________________
6.请你再抄一首北岛的诗歌，体会其诗歌的艺术特色。
____________________________________
1.表达了作者对“_”、对假丑恶的极端愤慨，对即将出现的转机、对真善美的热情讴歌，同时也表现出作者的自我奉献精神和沉重的历史责任感。
2.看吧，在那镀金的天空中，/飘满了死者弯曲的倒影。
3.表现了作者要对恶势力进行挑战的决心和信心。
4.如果海洋注定要决堤，/就让所有的苦水都注入我心中;/如果陆地注定要上升，/就让人类重新选择生存的峰顶。
5.诗中的“我”可能是一个被恶势力判决的但又义无反顾的向恶势力挑战的勇敢者。生活中正需要像“我”这样爱憎分明又有勇气的人。譬如面对坏人坏事，我们应该勇敢地与其作斗争，人民英雄徐洪刚就是这样的人。但是，如果对任何事都叛逆，不加任何分析，从而全盘否定它们，就会陷入一种虚无主义之中，这是不足取的。(大意正确即可)
6.例如：《一切》一切都是命运/一切都是烟云/一切都是没有结局的开始/一切都是稍纵即逝的追寻/一切欢乐都没有微笑/一切苦难都没有泪痕/一切语言都是重复/一切交往都是初逢/一切爱情都在心里/一切往事都在梦中/一切希望都带着注释/一切信仰都带着呻吟/一切爆发都有片刻的宁静/一切死亡都有冗长的回声 清醒的思辨与直觉思维产生的隐喻、象征意象相结合，是北岛诗显著的艺术特征，具有高度概括力的悖论式警句，造成了北岛诗独有的振聋发聩的艺术力量。
面试怎样回答这些题
怎样对待自己的失败？
回答提示：我们大家生来都不是十全十美的，我相信我有第二个机会改正我的错误，
你为什么愿意到我们公司来工作？
回答提示：对于这个问题，你要格外小心，如果你已经对该单位作了研究，你可以回答一些详细的原因，像“公司本身的高技术开发环境很吸引我。”、“我同公司出生在同样的时代，我希望能够进入一家与我共同成长的公司。”、“你们公司一直都稳定发展，在近几年来在市场上很有竞争力。”、“我认为贵公司能够给我提供一个与众不同的.发展道路。”这都显示出你已经做了一些调查，也说明你对自己的未来有了较为具体的远景规划。
对这项工作，你有哪些可预见的困难？
回答提示：①不宜直接说出具体的困难，否则可能令对方怀疑应聘者不行。②可以尝试迂回战术，说出应聘者对困难所持有的态度——工作中出现一些困难是正常的，也是难免的，但是只要有坚忍不拔的毅力、良好的合作精神以及事前周密而充分的准备，任何困难都是可以克服。
如果录用了你，你将怎样开展工作？
回答提示： ①如果应聘者对于应聘的职位缺乏足够的了解，最好不要直接说出自己开展工作的具体办法，
②可以尝试采用迂回战术来回答，如“首先听取领导的指示和要求，然后就有关情况进行了解和熟悉，接下来制定一份近期的工作计划并报领导批准，最后根据计划开展工作。”。
分析：这个问题的主要目的也是了解应聘者的工作能力和计划性、条理性，而且重点想要知道细节。如果向思路中所讲的迂回战术，面试官会认为回避问题，如果引导了几次仍然是回避的话，此人绝对不会录用了。
你希望与什么样的上级共事？
回答提示：①通过应聘者对上级的“希望”可以判断出应聘者对自我要求的意识，这既上一个陷阱，又是一次机会。②最好回避对上级具体的希望，多谈对自己的要求。③如“做为刚步入社会的新人，我应该多要求自己尽快熟悉环境、适应环境，而不应该对环境提出什么要求，只要能发挥我的专长就可以了。
分析：这个问题比较好的回答是，希望我的上级能够在工作中对我多指导，对我工作中的错误能够立即指出。总之，从上级指导这个方面谈，不会有大的纰漏。
自己在面试中（面的是行政）碰到过这样被问的一个问题：“如果你是客服组的一员，有用户用言语不停的诋毁、骚扰。如果此时，领导强烈要求你‘骂回去’。你会不会骂？”求分析一下面试官考察的角度；以及如果实际碰到这种问题应该怎么处理的最好方式。
[面试客服，这道题怎么回答？]
★ 文言文真题解析
★ 金刚经经题解析
