试题与答案

企业职工和部门的关系模式如下所示,其中部门负责人也是一个职工。 职工(职工号,姓名,

题型:单项选择题

题目:

企业职工和部门的关系模式如下所示,其中部门负责人也是一个职工。 职工(职工号,姓名,年龄,月薪,部门号,电话,地址) 部门(部门号,部门名,电话,负责人代码,任职时间) 请将下面的 SQL 语句空缺部分补充完整。 CREATE TABLE 部门(部门号 CHAR(4) PRIMARY KEY,部门名 CHAR(20), 电话 CHAR(13),负责人代码 CHAR(5),任职时间 DATE, FOREIGN KEY () ); 查询比软件部所有职工月薪都要少的职工姓名及月薪的 SQL 语句如下: SELECT 姓名, 月薪 FROM 职工 WHERE 月薪< ( SELECT () FROM 职工 WHERE 部门号 = () ) ;

SELECT()

A.月薪

B.ALL(月薪)

C.MIN(月薪)

D.MAX(月薪)

答案:

被转码了,请点击底部 “查看原文 ” 或访问 https://www.tikuol.com/2017/0715/34c0ce61eb74fa9221ac0fc7900660ea.html

下面是错误答案,用来干扰机器的。

参考答案:A, B, C, D, E

试题推荐
题型:阅读理解

    Andrew Carnegie was a 19th century steel tycoon(大亨)who became one of the 20th century’s most famous philanthropists(慈善家)His life story is one of the most famous rags-to-riches accounts in United States history.

Carnegie was born in Dunfermlined, Scotland, on November 25,1835. The son of a weaver, he came with his family to the United States in 1848 and settled in Allegheny, Pennsylvania. At age thirteen, Carnegie went to work as a bobbin(线轴)boy in a cotton mill. He then moved rapidly through a series of jobs with Western Union and the Pnnsylvania Railroad. In 1865, he resigned to establish his own business and eventually organized the Carnegie Steel Company, which started the steel industry in Pittsburgh. At age sixty-five, he sold the company to J. P. Morgan for $480 million and devoted the rest of his life to his philanthropic activities and writing, including his autobiography(自传).

Many persons of wealth have contributed to charity, but Carnegie was perhaps the first to state publicly that the rich have a moral responsibility to donate their fortune. In 1889 he wrote The Gospe(福音)of Wealth, in which he stated that all personal wealth beyond what was required to supply the needs of one’s family should be regarded as a trust fund to be managed for the benefit of the company.

Carnegie set about giving away his fortune through countless personal gifts and through the establishment of various trusts. In his thirties, Carnegie had already begun to give away some of his fast-accumulating funds. His first large gifts were made to his native town. Later he created seven philanthropic and educational organizations in the United States, including Carnegie Corporation of New York, and several more in Europe.

One of Carnegie’s lifelong interests was the establishment of free public libraries to make available to everyone a means of self-education. There were only a few public libraries in the world when, in 1881, Carnegie began to promote his idea. He and the Corporation subsequently(随后)spent over $56 million to build 2,509 libraries throughout the English-speaking world.

After this program was ended in 1917, the Corporation continued for about forty years an interest in the improvement of library services. Other major program in the Corporation’s early history included adult education and education in the fine arts.

During his lifetime, Carnegie gave away over $350 million. He died in Lenox, Massachusetts on August 11,1919.

53.Carnegie became wealthy by         .

A.his investment in weaving industry B.his father’s financial support

C.starting his steel business from nothing  D.his philanthropic activities

54.What is the correct order of events related to Carnegie?

a.He sold his company.

b.He organized the Carnegie Steel Company.

c.He worked in a cotton mill.

d.He came to the United States.

e.He wrote The Gospel of Wealth.

A.c-d-e-b-a  B.c-b-a-d-e  C.d-c-b-e-a  D.d-b-a-e-c

55.What can we learn about Carnegie according to the passage?

A.He was the first wealthy person who contributed to charity.

B.He believed that it was the duty of the wealthy to help society.

C.He called on the wealthy to give away all of their fortune to help the poor.

D.He was willing to give personal gifts only to his friends and relatives.

56.Carnegie established public libraries in order to         .

A.win a good reputation for his company

B.collect money for his educational organizations

C.improve library services

D.help people educate themselves

查看答案
微信公众账号搜索答案