《实用综合教程》第一册课后练习答案

TEXT(A) B C D C C

课后练习ABCBC DABAC

1.You should be focused on study.

2.For young people, education does count.

3.We study many subjects in this vocational school.

4.To my surprise, the senior citizens still study English at such an old age.

5.When we want knowledge as badly as we want to breathe, then we shall be wise and

learned.

Unit 2

TEXT(A) C D A C D

课后练习C C B B C B D D A A

1.What he says hurts his friend’s feelings.

2.John means a lot to Bill because he often helped him a lot.

3.We all have sympathy for her.

4.Mary likes to share her happiness with her friends.

5.I look forward to meeting him again.

Unit 3

TEXT(A) D C A D A

课后练习C C B BC C D A C A

1.When you visit your foreign teacher, you may present him with a small cultural gift.

2.You can give the host a bottle of wine as a gift only when you know that the host drinks wine.

3.I received many beautiful gifts at one time when I celebrated my birthday last year.

4.The girl came across a flower shop and bought her grandmother some flowers there.

5.We should give our parents some small gifts to show our love for them.

Unit 4

TEXT(A) A B D A B

课后练习A A D A A B A C A B

1.Mickey Mouse is my favorite cartoon character.

2.Chinese movies are quite popular in American and European countries now.

3.Animated films bring people amusement and laughter.

4.She has begun to appear in many screen roles at the age of six.

5.The fans were very excited when the movie star appeared in public.

Unit 5

TEXT(A) D D C A D

课后练习C A C C C D A A D D

1.As far as we know, the earth is the only planet where people can live.

2.The field was covered with a thin layer of snow.

3.The fact that there are too many cars in big cities pollutes the air seriously.

4.The children protect their mother earth in their own ways.

5.Even a small thing we do can make a difference to the environment.

TEXT(A) A B C A B

课后练习C A B A D B A B D C

1.I worked at a factory during the summer vacation and the boss gave me a free lunch.

2.He is in charge of the company’s website.

3.The restaurant is in need of several waiters.

4.We study at school and at the same time do part-time jobs in shops or companies.

5.Students often earn some money by working as a tutor.

Unit 7

TEXT(A) C C C B C

课后练习B A B A D D A B B D

1.My father now pays great attention to his weight.

2.Be sure to eat a good balance of different foods if you want to stay healthy.

3.Aerobic exercise is fit for many people.

4.My grandparents are quite healthy and they travel from time to time.

5.Experts believe that fitness walking is good for people in many ways.

Unit 8

TEXT(A) D D C D A

课后练习B A C D D A B A B B

1.Although on one appreciated Schultz’s artwork, he was sure of his ability.

2.Before the first Harry Potter was published, it had been rejected many times.

3.Alice didn’t lose heart. She made up her mind to become a real artist.

4.That ordinary man did something unusual and became famous.

5.It was Anne’s belief that the good will win out in the long run.

(完整版)大英第一册课后练习答案

Unit One Growing up Language Focus Vocabulary I (p12) 1. 1) respectable 2) agony 3) put down 4) sequence 5) hold back 6) distribute 7) off and on 8) vivid 9) associate 10) finally 111) turn in 12) tackle 2. 1) has been assigned to the newspaper’s Paris office 2) was so extraordinary that I did not know whether to believe him or not. 3) a clear image of how she would look in twenty years’ time. 4) gave the command the soldiers opened fire. 5) buying bikes we’ll keep turning them out. 3. 1) reputation; rigid; to inspire 2) and tedious; What’s more; out of date ideas 3) compose; career; avoid showing; hardly hold back Vocabulary II (p14) 1. compose 2. severe 3. agony 4. extraordinary 5. recall 6. command 7. was violating 8. anticipate Vocabulary III (p15) 1. at 2. for 3. of 4. with 5. as 6. about 7. to 8. in; in 9. from 10. on/upon Comprehensive Exercises (p16) I. Cloze 1. Text-related 1) hold back 2)tedious 3) scanned 4) recall 5) vivid 6) off and on 7) turn out/in 8) career 2. Theme-related 1) last 2) surprise 3) pulled 4) blowing 5) dressed 6) scene 7) extraordinary 8) image 9) turn 10) excitement II Translation 1) As it was a formal dinner party, I wore formal dress, as Mother told me to. 2) His girlfriend advised him to get out of / get rid of his bad habit of smoking before it took hold. 3) Anticipating that the demand for electricity will be high during the next few months, they have decided to increase its production. 4) It is said that Bill has been fired for continually violating the company’s safety rules. ? Bill is said to have been fired for continually violating the company’s safety rules. 5) It is reported that the government has taken proper measures t o avoid the possibility of a severe water shortage. ? The local government is reported to have taken proper measures to avoid the possibility of a severe water shortage. Translation 2 (p18) Susan lost her legs in a car accident. For a time, she didn’t know how to face up to the fact that she would never be able to walk again. One day, while scanning through some magazines, a true story caught her eye. It gave a vivid description of how a disabled girl became a writer. Greatly inspired, Susan began to feel that she, too, would finally be able to lead a useful life. Comprehension Check (pp22-23) 1-6 cacdbd Language Practice (pp23-24) 1. 1) – 8) b. d, a. f, c, g, h, e 2. 1) resigned 2) expectation 3) have maintained 4) represents 5) exception 6) was awarded 7) plus 8) make it 9) delicate 10) innocent 11) compare to 12) significance

数据库期中试卷及参考答案

《数据库原理与应用》 一．单项选择题（每题1分，共20分） 1.目前市场上常见的DBMS 90%以上都是基于（ C ）数据模型的。 A．层次B．网状C．关系D．面向对象 2.E-R图是在数据库设计中用来表示（ A ）的一种常用方法。 A．概念模型B．逻辑模型C．物理模型D．面向对象模型 3.（ C ）是数据库中全体数据的逻辑结构和特征的描述，是所有用户的公共数据视图。 A．外模式B．内模式C．模式D．概念模式 4.（ B ）也称存储模式，是数据库物理结构和存储方式的描述，是数据在数据库内部的表示方式。 A．外模式B．内模式C．模式D．概念模式 5．数据库的概念模型独立于（ A ）。 A．具体的机器和DBMS B．E-R图C．信息世界D．现实世界 6.在数据库中存储的是（ C ）。 A．数据B．数据库模型C．数据以及数据之间的联系D．信息 7．规范化理论是关系数据库进行逻辑设计的理论依据，根据这个理论，关系数据库中的关系必须满足：其每一个属性都是（ B ）。 A．互不相关的B．不可分解的C．长度可变得D．互相关联的 8.在数据模型中有“型”和“值（或实例）”两个对应的概念。其中数据库的模式是一个（ D ）的概念，是一个相对（）的概念，而数据库在某一时刻的状态则是一个（）的概念，是一个相对（）的概念。 A．型；变化；值；不变B．值；不变；型；变化 C．值；变化；型；不变D．型；不变；值；变化 9.关系表A的属性个数为5，元组个数为10；关系表B的属性个数为6，元组个数为20. 则A与B的笛卡尔积A×B的属性有（ D ）个，元组个数有（）个。 A．30；200B．11；30 C．30；30D．11；200 10.父亲和子女的亲生关系属于（ B ）的关系。 A．1：1B．1：n C．m：n D．不一定 11.在SQL语言中，删除关系表中的一个属性列，要用动词（ D ），删除关系表中的一行或多行元组，要用动词（）。 A．delete，delete B．drop，drop C．delete，drop D．drop，delete 12.在SQL语言中，为关系模式增加一个属性要用动词（B）,为关系表增加一行或多行元组要用动词（）。 A．insert，insert B．add，insert C．insert，add D．add，add 13.实体完整性约束和SQL语言中的（ A ）相对应。 A．primary key B．foreign key C．check D．都不是 14.参照完整性约束和SQL语言中的（ B ）相对应。 A．primary key B．foreign key C．check D．都不是 15.在我们的学生-课程数据库中，SC表上建立了两个外码约束，被参照表是Student表和Course表，则最适当的说法是： A．Student表中的学生号Sno不能随意取值B．Course表中的课程号Cno不能随意取值 C．SC表中学生号Sno不能随便D．SC表中学生号Sno、课程号Cno均不能随意取值 16.如果在学生-课程数据库中的SC表上建立了参照完整性约束： Foreign Key （Sno）References Student（Sno）， Foreign Key （Cno）References Course（Cno）， 则（ D ）操作可能会违背该完整性约束。 A．在Student表上增加一行记录B．在Course表上增加一行记录 C．在SC表上删除一行记录D．更新SC表上的记录 17.关系R（X，Y，Z），函数依赖集FD={Y→Z，XZ→Y}，则关系R是（ C ）。 A．1NF B．2NF C．3NF D．BCNF 18、表之间一对多关系是指_B_____。 A．一张表与多张表之间的关系B．一张表中的一个记录对应另一张表中的多个记录 C．一张表中的一个记录对应多张表中的一个记录D．一张表中的一个记录对应多张表中的多个记录 19、SQL的SELECT语句中，“HAVING条件表达式”用来筛选满足条件的（D） A．列B．行C．关系D．分组 20、SQL语言中INSERT、DELETE、UPDA TE实现哪类功能 D 。 A．数据查询B．数据控制C．数据定义D．数据操纵 二．填空题（每空1分，共18分）： 1.从历史发展看来，数据管理技术经历了人工管理、文件管理和数据库管理三个阶段。 2.在SQL语言中，用符号—代表单个字符，用符号% 代表0到多个字符。 3.在SQL语言中，为了使查询的结果表中不包含完全相同的两个元组，应在select的后面加上关键词distinct 。 4、在SQL语句中，与表达式“工资BETWEEN 1210 AND 1240”功能相同的表达式是工资>=1210 and 工资<=1240 。 第 1 页/共 4 页

大学英语综合教程1课后习题答案

Unit 1 Part Ⅱ Reading Task Vocabulary Ⅰ1. 1)respectable 2)agony 3)put down 4)sequence 5)hold back 6)distribute 7)off and on 8)vivid 9)associate 10)finally 11)turn in 12)tackle 2. 1)has been assigned to the newspaper’s Paris office. 2)was so extraordinary that I didn’t know whether to believe him or not. 3)a clear image of how she would look in twenty years’time. 4)gave the command the soldiers opened fire. 5)buying bikes we’ll keep turning them out. 3. 1)reputation; rigid; to inspire 2)and tedious; What’s more; out of date ideas 3)compose; career; avoid showing; hardly hold back Ⅱviolating Ⅲ;in upon Comprehensive Exercises ⅠCloze back; tedious; scanned; recall; vivid; off and on; turn out/in; career ; surprise; pulled; blowing; dressed; scene; extraordinary; image; turn; excitement ⅡTranslation As it was a formal dinner party, I wore formal dress, as Mother told me to. 2)His girlfriend advised him to get out of /get rid of his bad habits of smoking before it took hold. 3)Anticipating that the demand for electricity will be high during the next few months, they have decided to increase its production. 4)It is said that Bill has been fired for continually violating the company’s safety rules. /Bill is said to have been fired for continually violating the company’s safety rules. 5)It is reported that the government has taken proper measures to avoid the possibility of a severe water shortage. /The local government is reported to have taken proper measures to avoid the possibility of a severe water shortage. 2.Susan lost her legs because of/in a car accident. For a time, she didn’t know how to face up to the fact she would never (be able to) walk again. One day, while scanning (through) some magazines, a true story caught her eye/she was attracted by a true story. It gave a vivid description of how a disabled girl became a writer. Greatly inspired, Susan began to feel that she, too, would finally be able to lead a useful life. Unit 2 Part ⅡReading Task Vocabulary Ⅰ1. 1)absolutely 2)available 3)every now and then 4)are urging/urged 5)destination 6)mostly 7)hangs out 8)right away 9)reunion 10)or something 11)estimate 12)going ahead 2. 1)in the examination was still on his mind. 2)was completely choked up by the sight of his team losing in the final minutes of the game. 3)was so lost in study that she forgot to have dinner. 4)has come up and I am afraid I won’t be able to accomplish the project on time. 5)of equipping the new hospital was estimated at﹩2 million. 3. 1)were postponed; the awful; is estimated 2)reference; not available; am kind of 3)not much of a teacher; skips; go ahead Ⅱ;on Ⅲor less of/sort of 4. kind of/sort of 5. more or less 6. or something Comprehensive Exercises ⅠCloze up; awful; practically; neighborhood; correspondence; available; destination; reunion; Mostly; postponing; absolutely ; savings; embarrassment; phone; interrupted; touch; envelope; signed; message; needed ⅡHalf an hour had gone by, but the last bus hadn’t come yet. We had to walk home. 2)Mary looks as if she is very worried about the Chinese exam because she hasn’t learned the texts by

泛读教程第一册 Unit 4 Food

Unit 4 Food(饮食)--- A Food Tour of the United States Task 1: Discussion 1.Do you know some information about regional feature of Chinese food and some specialties in each region? 2.Do you know what the features of American food are? Do you know how many distinct regions are there in U.S? What are they? (the Northeast; the South; the Mountain States; the Southwest states; and ?) 3.* Why American food is regional in character? (The U.S has a large area. Each place has their unique geographical and climatic condition, so it produces unique food materials, such as the Northeast which borders sea, river and lake is rich in seafood and the Mountain states produce wild games. The similar rule can also be applied in self-cultivation, running a company and governing a country: to find out our own unique talent, our strength; the more loca/nationall, the more international.) Reading- skill questions about the text: 1.What’s text-type? (narration, description, exposition, or argumentation) 2.What’s th e topic and main idea of the text? (Reading skill: distinguish /obtain main idea and discourse topic quickly and efficiently) Topic: food Main idea: American cooking is regional in character./ one feature of American cooking is variety. 3.Which is the topic sentence in Para.1, sentence 1 or sentence 2? Why? 4.Para2.: guess the meaning of the unfamiliar word “ hearty” in “Mixed in an iron pot and …….” (hearty: [attrib]large; eg. eat a hearty breakfast 丰盛的；have a hearty appetite 胃口很好) Task 2 1.Analyzing different types of reading comprehension questions: Q1: testing skimming skills--- to obtain main idea quickly and efficiently Reading strategy/solution: 文体判断为说明文，顾第一段为重要 Q2-8: testing scanning skills--- to find some key words or phrases; figures, percentages quickly Homework: discussion Why do many people want to go into business for themselves rather than work for an already existing organization? What’s the attraction? To be a manager or leader of a company, what are some of the qualities do you think he or she should have? Reading skill testing: 1．He put his milk in a pouch made from a sheep stomach and set off across the desert. What is the meaning of the word “Pouch”? (C) A. milk B. desert C. a container D. a stomach 2．The movement of his camel, the desert heat, and the chemicals in the pouch made the milk separate into curd and whey. The thick part, or curd , was the first cheese. What is the meaning of the word “curd”? A. the camel B. the thick part of the milk C. desert heat D. milk

新概念英语第一册课后练习题答案：Lesson 49

新概念英语第一册课后练习题答案：Lesson 49 Lesson 49 阅读理解 答案与解析 1. 从Class is over.来看，他们是学生。所以，该题要这样回答：They’re students. 2. 从两个孩子的对话来看，他们都在学校里吃午饭。其答案是：They have lunch at school today. 3. 从Sam 说的I have two hamburgers in my bag.和There’re two bottles of orange juice in my bag.我们 知道，该题的答案是：They’re two hamburgers and two bottles of orange juice. 4. Mum gives me two eggs, a cake and some potato chips. They’re all my favourite food.已经告诉我们， 该题理应这样回答：Her favourite food is eggs, cakes and potato chips. 5. 从May 接受了Saw 的饮料来看，他们喝了橙汁。故应回答：They have some orange juice today. 答案与解析 1. D。由第一段第一句：绝大部分人们靠他们的手谋生，可知答案。 2. C。由第二段第三句：在他们的小屋子里，生活着七个人，可知答案。 3. A。由第二段第四句：约翰除了街道没有地方可玩，可知答案。 4. B。约翰除了街道没有地方玩，那他踢足球也只有在街上踢了。

5. D。由第一段第二句：约翰靠脚谋生，根据文章可推断后来他成为了一名足球运动员。 英汉翻译 1. Do you want any beef? 2. Do you want potato or tomato? 3. What about some lamb? 4. Give me two pounds of chicken. 5. Children don’t like beef. 6. Do you like grape?

MySQL数据库考试试题及答案

专业：移动通信科目：MySQL数据库 一、单项选择题 1．以下聚合函数求数据总和的是( ) A．MAX B．SUM C．COUNT D．AVG 答案：B 2．可以用( )来声明游标 A．CREATE CURSOR B．ALTER CURSOR C．SET CURSOR D．DECLARE CURSOR 答案：D 3．SELECT语句的完整语法较复杂，但至少包括的部分是( ) A．仅SELECT B．SELECT，FROM C．SELECT，GROUP D．SELECT，INTO 答案：B 4．SQL语句中的条件用以下哪一项来表达( ) A．THEN B．WHILE C．WHERE D．IF 答案：C 5．使用CREATE TABLE语句的( )子句，在创建基本表时可以启用全文本搜索A．FULLTEXT B．ENGINE C．FROM D．WHRER 答案：A 6．以下能够删除一列的是( ) A．alter table emp remove addcolumn B．alter table emp drop column addcolumn C．alter table emp delete column addcolumn D．alter table emp delete addcolumn 答案：B 7．若要撤销数据库中已经存在的表S，可用（）。 A．DELETE TABLE S B．DELETE S C．DROP S D．DROP TABLE S 答案：D

8．查找表结构用以下哪一项( ) A．FIND B．SELETE C．ALTER D．DESC 答案：D 9．要得到最后一句SELECT查询到的总行数，可以使用的函数是( ) A．FOUND_ROWS B．LAST_ROWS C．ROW_COUNT D．LAST_INSERT_ID 答案：A 10．在视图上不能完成的操作是( ) A．查询 B．在视图上定义新的视图 C．更新视图 D．在视图上定义新的表 答案：D 11．UNIQUE惟一索引的作用是( ) A．保证各行在该索引上的值都不得重复 B．保证各行在该索引上的值不得为NULL C．保证参加惟一索引的各列，不得再参加其他的索引 D．保证惟一索引不能被删除 答案：A 12．用于将事务处理写到数据库的命令是( ) A．insert B．rollback C．commit D．savepoint 答案：C 13．查找条件为：姓名不是NULL的记录( ) A．WHERE NAME ! NULL B．WHERE NAME NOT NULL C．WHERE NAME IS NOT NULL D．WHERE NAME!=NULL 答案：C 14．主键的建立有( )种方法 A．一 B．四 C．二 D．三 答案：D 15．在视图上不能完成的操作是( ) A．更新视图数据

新世纪大学英语综合教程1课后答案(全)

2. (1) obtain (2) confident (3) communicate (4) advantage (5) relevant (6) helpful (7) extreme (8) enjoyable (9) means (10) process (11) particularly (12) characters (13) astonished (14) apparently 3. (1) fond of (2) is…related to (3) according to (4) To a certain degree (5) vice versa (6) no doubt (7) rid… of (8) cleare d up (9) or else (10) at all costs (11) sure enough (12) let alone (13) similar to (14) It’s no use (15) in my opinion (16) was worth (II)Increasing Your Word Power 1. (1) c (2) d (3) b (4) b (5) b (6) d 2. (1) highly/very (2) quite/very (3) quite/very/increasingly (4) quite/simply/very 3. 4.No Mistake especial→ especially

necessarily → necessary frequent → frequently No Mistake ea sily → easy No Mistake i ndividually → individual m uch → many h igh → highly a pparently → apparent r emarkably → remarkable p robable → probably No Mistake (III)Grammar Task 1: (1)would/should (2) should/would (3) might (4) would (5) must (6) can’t (7) should would (8) must Task 2: (1)We passed the afternoon very pleasantly, roller-skating in the sun and talking about our childhood under a tree. / The afternoon passed very pleasantly, while we roller-skated in the sun and talked about our childhood under a tree. (2)On entering the lecture hall, I was surprised at the size of the crowd. / When I entered the lecture hall, I was surprised at the size of the crowd. (3)When I was only a small boy, my father took me to Beijing and we had a lot of fun together. (4)To write well, a person must read good books. (IV)Cloze (1) doubt (2) efficient (3) where (4) advantage (5) afford (6) claim (7) fluently (8) qualified (9) extent (10) ridiculous (11) perfect (12) as (13) because (14) individual (V)Translation 1. Translate the sentences (1) The baby can’t even crawl yet, let alone walk. (2) Will claimed he was dining with a group of friends at the time of the murder, but in my opinion he told a lie. (3) To a certain extent the speed of reading is closely related to reading skills; and with reading skills you can cope with outside class reading better. (4) According to the regulation/rule, they both can play the game/participate in the game.

新世纪阅读教程1完整答案

Unit 1 I. Reading for information 1.B 2.D 3.B 4.C 5.A 6.C II. Translation 1. 但是只要说上几句话，他的口音就很容易被辨认出来。 2. 他不会轻易发火，有一颗金子般的心，你很少能从他的嘴里听到攻击和批评别人的话。 3. 常言道：善行胜于善言。父亲的身教对我的影响远远超过了他的言传。 4. 面对生活的沧桑，大布鲁诺怎么能不提高嗓门，怎么能保持心气平和？难道力气这么大的人不该脾气也大吗？ 5. 体育明星和歌星|、影星的确能够鼓舞人心，但是“英雄”这个头衔还是应该留给像我父亲 那样，为了自己所爱的人孜孜不卷地工作的人。 III. Summary 1.hard work, pays off 2.Big Bruno, strong in stature, a gentle spirit 3.most patient, slow to get angry, a heart of gold, a lot of friends 4. a role model, a true friend, a treasure 5.hero, does good, loves everyone, doesn’t expect anything, in return, work tirelessly, the good race I. Skimming question 1 A II. Skimming question 2 A teacher should … 1. be pleasant live and attractive 2. have a genuine capacity for sympathy 3. be both intellectually and morally honest 4. be mentally alert 5. be capable of infinite patience 6. have the kind of mind which always wants to go on learning III. Scanning question 1 4

高中数学必修1课后习题答案完整版

高中数学必修1课后习题答案 第一章 集合与函数概念 1．1集合 1．1．1集合的含义与表示 练习（第5页） 1．用符号“∈”或“?”填空： （1）设A 为所有亚洲国家组成的集合，则：中国_______A ，美国_______A ， 印度_______A ，英国_______A ； （2）若2 {|}A x x x ==，则1-_______A ； （3）若2{|60}B x x x =+-=，则3_______B ； （4）若{|110}C x N x =∈≤≤，则8_______C ，9.1_______C ． 1．（1）中国∈A ，美国?A ，印度∈A ，英国?A ； 中国和印度是属于亚洲的国家，美国在北美洲，英国在欧洲． （2）1-?A 2 {|}{0,1}A x x x ===． （3）3?B 2 {|60}{3,2} B x x x =+-==-． （4）8∈ C ，9.1?C 9.1N ?． 2．试选择适当的方法表示下列集合： （1）由方程2 90x -=的所有实数根组成的集合； （2）由小于8的所有素数组成的集合； （3）一次函数3y x =+与26y x =-+的图象的交点组成的集合； （4）不等式453x -<的解集． 2．解：（1）因为方程2 90x -=的实数根为123,3x x =-=， 所以由方程2 90x -=的所有实数根组成的集合为{3,3}-； （2）因为小于8的素数为2,3,5,7， 所以由小于8的所有素数组成的集合为{2,3,5,7}； （3）由326y x y x =+??=-+?，得14x y =??=? ， 即一次函数3y x =+与26y x =-+的图象的交点为(1,4)，

数据库试题及答案_

笔试样卷一 参考答案 一、简答题（25分） 1．数据库阶段数据管理的主要特点是什么？ 2．解释DB、DBMS、DBS三个概念？ 3．什么是物理数据独立性和逻辑数据独立性？ 4．试说明DBMS的主要功能？ 5．在ER模型转换为关系模型时，联系类型要根据不同的情况作不同的处理，试说明之。 二、计算题（20分） 1．设有关系R和S R： S： A B C A B C 3 6 7 3 4 5 2 5 7 7 2 3 7 3 4 4 4 3 列表计算R∪S、R－S、R×S、π 3,2(S)、δ B<5 (R)。（5分） 2．设有三个关系 S (SNO, SNAME, AGE, SEX, SDEPT) SC (SNO, CNO, GRANDE) C (CNO, CNAME, CDEPT, TNAME) 试用关系代数表达式表示下列查询

（1）检索LIU老师所授课程的课程号、课程名 （2）检索年龄大于23岁的男学生的学号和姓名 （3）检索学号为S3的学生所学课程的课程名和认课教师姓名 （4）检索WANG同学不学的课程的课程号 （5）检索至少选修了两门课程的学生的学号（10分） 三、设有三个基本表（45分） S (SNO, SNAME, AGE, SEX, SDEPT) SC (SNO, CNO, GRANDE) C (CNO, CNAME, CDEPT, TNAME) 1．试用T-SQL的查询语句表达下列查询 （1）检索LIU老师所授课程的课程号、课程名 （2）检索年龄大于23岁的男学生的学号和姓名 （3）检索学号为S3的学生所学课程的课程名和认课教师姓名 （4）检索WANG同学不学的课程的课程号 （5）检索至少选修了两门课程的学生的学号（10分） 2．试用T-SQL的查询语句表达下列查询 （1）统计有学生选修的课程的门数 （2）求选修C4课程的学生的年龄 （3）求LIU老师所授课程的每门课程的学生的平均成绩 （4）统计每门课程的学生选修人数 （5）求年龄大于所有女同学年龄的男学生的姓名和年龄（10分）3．试用T-SQL更新语句完成下列更新操作 （1）往表S中插入一个学生资料（‘S9’, ‘WU’, 18）

综合教程1课后答案

综合教程1课后答案 Unit 1 College Life Enhance Your Language Awareness Words in Action 1. (P.23) 1) deliver 2) polish 3) available 4) latter 5)file 6) thrive 7) undertook 8) practical 9) fulfill 10) perceived 11) accumulated 12) multiplied 2. (P.24) 1)compromise 2) self-induced 3) steered 4) frame 5)demonstrated 6) employ 7) promote 8) impressed 9)contribution 10) deliberately 11) financial 12) economic 3.(P.24) 1)makes a point of 2) refresh my memory 3) lead to 4) at hand 5) working out 6) under pressure 7) Last but not least 8) down 9) In addition to 10) were involved 11) in other words 12) pointed out 13) pay off 4. (P.25) 1) scored 2) scheduled 3) assigned 4) motivated 5) crucial 6) promote 7) perform 8) debate 9) scanned 10) devised 11) advocated 12) clarify 13) priorities 14) compromised 15) context 16) undertook Final sentence: academic excellence Increasing Your Word Power 1.( P.26~27) 1)principal/ major 2) top 3) major 4) top 5)principal 6) major 7) schedule 8)advocate/have advocated 9) top 10) approach 11)blame 12) major/ principal 13) advocate 14) schedule 15)blame 16) approaching 17) pressure 18) pace 19)pressured 20) pace Cloze (P.31) 1)academic 2) priorities 3) conducted 4) principles 5)begin 6) priority 7) compromised 8) addition 9)filling 10) Speaking 11) formula 12)Participation/ Participating 13) based 14) least 15)way 16) pressure