问题 填空题

设有如下说明,请回答(11)~(13)小题:
有3个数据库表:
金牌榜.DBF 国家代码C(3),金牌数I,银牌数I,铜牌数I
获奖牌情况.DBF 国家代码C(3),运动员名称C(20),项目名称C(30),名次I
国家.DBF 国家代码C(3),国家名称C(20)
"金牌榜"表中一个国家一条记录;"获奖牌情况"表中每个项目中的各个名次都有一条记录,名次只取前3名,例如:

国 家 代 码运动员名称项 目 名 称名 次
001刘翔男子110米栏1
001李小鹏男子双杠3
002菲尔普斯游泳男子200米自由泳3
002菲尔普斯游泳男子400米个人混合泳1
001郭晶晶女子三米跳板1
001李婷/孙甜甜网球女子双打1

答案

参考答案:ON

解析: SQL中实现联接的命令格式为:SELECT…FROM<表名>INNER JOIN<表名>ON<联接表达式>。 “WHERE…国家周家代码=获奖牌情况.国家代码”是联接表达式,所以前面应写ON。

填空题
问答题

Part 1


·Read the following passages, eight sentences have been removed from the article.
·Choose.from the sentences A-H the one which fits each gap.
·For each gap (1-8) mark one letter (A-H) on the Answer Sheet.
·Do not mark any letter twice.
Today’s career assumptions are you can get a lot of development, challenge and job satisfaction and not necessarily be in a management role.
A new malady is running rampantly in corporate America: management phobia. (1)
" I hated all the meetings," says a 10-year award-winning manager, "and I found the more you did for people who worked for you, the more they expected." (2)
With technology changing in a wink, you can never slack off these days if you’re on the technical side. (3)
In addition, the Dilbert factor is at work. With Scott Adams’s popular cartoon character— as well as many television sitcoms — routinely portraying managers as morons or enemies, they just don’t get much respect anymore.
Supervising others was always a tough task, but in the past that stress was offset by hopes for career mobility and financial rewards. (4)
But in today’s global, more competitive arena, a manager sits on an insecure perch. (5) There are far fewer rungs on the corporate ladder for managers to climb. In addition, managerial jobs demand more hours and headaches than ever before but offer slim, if any, financial paybacks and perks.
Furthermore, managers now must supervise many people who are spread over different locations, even over different continents. (6)
In an age of entrepreneurship, when the most praised people in business are those launching something new, management seems like an invisible, thankless role. (7)
Management layoffs have done much to erode interest in managerial jobs, of course. (8)
A. Many people don’t want to be a manager — and many people who are managers are, frankly, itching to jump off the management track — or have already.
B. It’s a rare person who can manage to keep up on the technical side and handle a management job, too.
C. Restructuring have eliminated layer after layer of management as companies came to view their organizations as collections of competencies rather than hierarchies.
D. They must manage across functions with, say, design, finance, marketing and technical people reporting to them.
E. I was a counselor, motivator, financial adviser and psychologist.
F. Employers are looking for people who can do things, not for people who make other people do things.
G. American Management Association surveys say three middle managers are laid off for every one being hired.
H. Along with a sizable pay raise, people chosen as managers would begin a nearly automatic climb up the career ladder to lucrative executive perks: stock options, company cars, club memberships, plus the key to the executive washroom.