The Department of State, as a ______ organization helps make, execute and monitor Ame

在学籍管理中，设有4个表，关系模式分别为：

ST[JDENT(SNO，SNAME，SEX，BIRTFtDAY，CLASS)

TEAC腿R(1FNO，TNAME．SEX．BIRTHDAY，PROFESSION，DEPARTMENT)

CO[JRSE(CNO，CNAME，TNO)

SCORE(SNO，CNO，DEGREE)

说明：学生关系模式中：SNO：学号；SNAME：姓名；SEX：性别；BIRTHDAY：出生口期；CI．ASS：班级：教师关系模式巾：TNO：教师号；TNAME：姓名；SEX：性别；BIRTHDAY：I叶{生口期；PRO—FESSION：职称；DEPARTMENT：所在系；

课程关系模式中：CNO：课程号；CNAME：课程名；TNO：任课教师号；

成绩关系模式中：SNO：学号；CNO：课程号；DEGREE：分数。

请用SQI。查询语句实现下列操作：

1)显示教师所有的单位，即不重复的DEPARTMENT列。

2)显示STIJDENT表中"95031．'班或性别为“女”的同学记求。

3)以CNO升序，DEGREE降序显示SCORE表的所有记录。

4)显示"9503l”班的学生人数。

5)显示SCORE表中至少有5名学生选修的并I：2 3 H：头的课程号的平均分。

6)显示最低分大于70，最高分小于90的SNO列。

7)显示选修“3一105”课程的成绩高于“109”号同学成绩的所有同学的记录。

8)显示SCORE表中选学多门课程的同学中分数为非最高分成绩的记录。

9)列出学号为“108'’的同学同年出生的所有学生的SNO、SNAME和BIRTHDAY。

10)显示“张三”教师任课的学生成绩。

回答题。

Nowadays,a standard for measuring power has changed．These changes foretell a new standardfor measuring power．No longer will a nation' s political influence be based solely on the strength ofits military forces．Of course, military effectiveness will remain a primary measure of power．But po-litical influence is also closely tied to industrial competitiveness．It' s often said that without its mili-tary the Soviet Union would really be a third-world nation．The new standard of power and influencethat is evolving now places more emphasis on the ability of a country to compete effectively in the e-conomic markets of the world．

America must recognize this new course of events．Our success in shaping world events over thepast 40 years has been the direct result of our ability to adapt technology and to take advantage of thecapabilities of our people for the purpose of maintaining peace．Our industrial prowess(威力) overmost of this period was unchallenged．It is ironic (有讽刺性的)that it is just this prowess that hasenabled other countries to prosper and in turn to threaten our industrial leadership．

The competitiveness of America' s industrial base is an issue bigger than the department of de-fense and is going to require the efforts of the major institutional forces in our society, govemment,industry, and education．That is not to say that the defense department will not be a strong force inthe process．But we simply cannot be, nor should we be, looked upon by others as the savior(救星)of American industry．

Now a nation‘s political influence depends on__________． 查看材料

A.the strength of its military forces

B.its ability to compete in industry

C.economic markets

D.both A and B

A．Accounting Department

B．Finance Department

C．R﹠D Department

D．Production Department

E．After-sales Department

A./

B.an

C.the

A.the director of the department

B.the secretary of the department

C.a new employee of the department

The manager of the customer service department seems ______ . (replace)

A.The Marketing Department

B.The Accounting Department

C.The Human Resources Department

A.生长

B.成功

C.部门

D.被子

A.Security Department

B.Personnal Training Department

C.Engineering Department

D.Finance Department