The modern age of science and technology has witnessed an increased combination of the
A.innovate
B.involve
C.classify
D.translate
A.innovate
B.involve
C.classify
D.translate
A.S
B.SC,C
C.S,SC
D.S,C,SC
设教学数据库中,有两个基本表:
学生表:S(S#,SNAME,AGE,SEX)
学习表:SC(S#,C#,GRADE)
现有一个SQL语句:
SELECT SEX,AGE,AVG(GRADE)
FROM S,SC
WHERE S.S# = SC.S#
GROUP BY SEX,AGE
ORDER BY 3 DESC;
试写出与此语句等价的汉语查询语句。
假定学生关系S(s#,SNAME,SEX,AGE),课程关系是C(C#,CNAME,TEACHER),学生选课关系是SC(S#,C#,GRADE),要查找“成绩大于75”的男学生的姓名将涉及的关系()。
A.S
B.C,SC
C.S,SC
D.S,C,SC
A.SELECTS#FORMSCWHEREC#=‘C2’ANDGRADE>=ALL(SELECTGRADEFORMSCWHEREC#=‘C2’)
B.SELECTS#FORMSCWHEREC#=‘C2’ANDGRADENOTIN(SELECTGRADEFORMSCWHEREC#=‘C2’)
C.SELECTS#FORMSCWHEREC#=‘C2’ANDGRADEIN(SELECTGRADEFORMSCWHEREC#=‘C2’)
D.SELECTS#FORMSCWHEREC#=‘C2’ANDGRADE>=(SELECTGRADEFORMSCWHEREC#=‘C2’)
Some people hate everything that is modern. They cannot imagine how anyone can really like modern music; they
find it hard to accept the new fashions in clothing; they think that all modern painting is ugly; and they seldom
have a good word for the new buildings that are being built everywhere in the world. Such people look for
perfection in everything, and they take their standards of perfection from the past. They are usually impatient
with anyone who is brave enough to experiment with new or to express himself or the age in materials original
ways. It is, of course, true that many artists do not succeed in their work and instead produce works that can
only be considered as failures. If the work of art is a painting, the artist’s failure concerns himself alone, but if
it is a building, his failure concerns others too, because it may damage the beauty of the whole place. This does
sometimes happen, but it is completely untrue to say, as some people do, that modern architecture is nothing.
We can’t judge every modern building by the standards of the ancient time, even though we admire the ancient
buildings. Technologically, the modern buildings are more advanced. The modern architect knows he should learn
from the ancient works, but with his greater resources of knowledge and materials, he will never be content to
imitate the past. He is too proud to do that.
Some people hate everything that is modern because _______.
A. they are aged
B. they find it hard to accept modern things
C. they take their standards of perfection from the Greek
D. they look at things by the standards of the past
设有如下所示的关系: 学生关系S(S#,SNAME,AGE,SEX) 课程关系C(C#,CNAME,TEACHER) 学生选课关系SC(S#,C#,GRADE) 其中:S#为学号, SNAME 为姓名, AGE 为年龄, SEX 为性别;C#为课程号, CNAME 为课程名, TEACHER为教师, GRADE 为成绩。 请根据要求写出关系代数表达式。 (1) 检索“张三”老师所授课程的课程号和课程名。 (2) 检索年龄大于 21的男学生学号和姓名。 (3) 检索选修“张三”老师所授全部课程的学生姓名。 (4) 检索“李四”同学不学课程的课程号。 (5) 检索选修课程包含“张三”老师所授课程之一的学生学号。 (6) 检索选修课程名为“C语言”的学生学号和姓名。 (7) 检索全部学生都选修的课程的课程号和课程名。 (8) 检索学号为3学生所学课程的课程名与任课教师名。 (9) 检索选修课程包含学号为2的学生所修课程的学生学号。 (10) 检索既选修课程号为K1又选修课程号为K5的学生学号。 (11) 检索至少选修两门课程的学生学号。
设教学数据库中有三个关系: 学生关系 S(S#,SNAME,AGE,SEX) 选课关系 SC(S#,C#,GRADE) 课程关系 C(C#,CNAME,TEACHER) 用SQL语句实现下面查询: 1.查询不学C2课的学生姓名与年龄。 2.求刘老师所授课程的每门课程的平均成绩。 3.求年龄大于女同学平均年龄的男学生姓名和年龄。 4.检索学习全部课程的学生姓名; 即在表S中找学生,要求这个学生学了全部课程。换言之,在S表中找学生,在C中不存在一门课程,这个学生没有学。 5.往关系C中插入一个课程元组(‘C8’,‘VC++’,‘BAO’)
Today all that has changed. On many modern farms machines now supply 96 percent of the power, human labor 3 percent, and horses 1 percent. Modern farms are enterprising businesses which keep only the livestock that can pay its way. The children go to school by bus every morning, the parents work on the farm or in the house, and hired help is seldom needed. Their work has been replaced by a whole army of farm machines.
Farmers in the machine age also use the new fertilizers, new sprays, new feeds, new hybrid seeds, and other helps developed by farm sciences. As a result the farmers are able to produce more food with less labour. This means fewer but larger farms and fewer but more prosperous farmers.
In old days, most of the work on a farm was done by______.
A.all the farm family
B.livestock
C.farm machines
D.both A and B
According to the passage, visitors from space may have landed on the earth ______.
A.long before man had dreamed of it
B.long before there were human beings
C.in the last few hundred years
D.after the space age began
People 【B4】______ hobbies because these activities 【B5】______ enjoyment, knowledge and relaxation. Anyone can follow a satisfying hobby, 【B6】______ his age, position or income. Hobbies can help a person's 【B7】______ or physical health. Doctors have found that hobbies are valuable 【B8】______ helping patients 【B9】______ from illnesses. Hobbies can provide patients with interests that keep them 【B10】______ thinking about themselves. Many hospitals treat patients by having them 【B11】______ up interesting hobbies.
【B12】______ modern times, people were too busy 【B13】______ a living to have hobbies. But some people who had 【B14】______ did enjoy hobbies. They have had more time than 【B15】______ for hobbies since automation began to reduce the 【B16】______ time they spent 【B17】______ jobs. Hobbies provide 【B18】______ for workers who do the 【B19】______ tasks all day along. Those who have 【B20】______ hobbies never need to worry about what to do when they have leisure hours.
A.raise
B.feed
C.watch
D.hunt
There is apparent generation gap between the young and the old nowadays. The younger generation is essentially different from the older generation. The young people live in a new age completely different from the old. They have grown up more happily and are not so dependent on adults as their parents were. They are better educated and enjoy more freedom. They easily accept new things and new ideas. They are more concerned with the present and the future, whereas the world of the older people has vanished, and they do not understand all of the problems of the modern world. They grew up in a world which was different from today's world. They often talk about "the good old days" and tend to assert old things and ideas. They don't like to feel that their beliefs and values are being questioned and threatened. They would like the young to learn from them, but the young refuse to accept their values. They cannot understand why the young complain about the conventional things and old systems and why they want to make changes in these things to fit the needs of modern society, As a result, the old people think the young are not what they were, and most young people are unable to learn from the parents and elders who they will never be.
In order to reconcile the differences, both generation should realize that the world has changed, and that new responses are necessary for many of the problems of society. Besides, some forms of organizations should be established to help the young and the old exchange their ideas and strengthen their mutual understanding so as to bridge the gap.
One important reason for the difference existing between the young and the old is that ______.
A.they live in different ages
B.they live in different countries
C.they live in separate planets
D.they hate each other