搜题请搜索小程序“爱下问搜题”
问题 单项选择题

要从学生表(学号、姓名、性别、出生年月、入校总分、三好生)中查询入校总分最高的3个学生的记录，应使用的SELECT SQL语句是 ______。

A．SELECT*FROM学生表ORDER BY入校总分ASC

B．SELECT FROM学生表ORDER BY入校总分DESC

C．SELECT FROM学生表TOP 3 ORDER BY入校总分ASC

D．SELECT FROM学生表TOP 3 ORDER BY入校总分DESC

答案

参考答案：D

解析： 本题要求是查询入校总分最高的3条记录，所以首先要用到排序语句，而且是降序排序，此外，还要选择记录的范围，即前3条，要有TOP子句，选项A和B没有TOP子句，选项C用的是升序排序，选项D中是按入校总分进行降序排序，并取前3条记录，达到了题目的要求。

填空题



For more than two centuries, American’s colleges and universities have been the backbone of the country’s progress. They have educated the technical, managerial, (1) and provided generation after generation of national leaders. Today educators from around the globe are turning to U. S. institutions of higher learning (2) . They are apt to find many reasons for the excellence of American universities, but (3) stand out as watersheds:
Education (4) : In 1862 Congress enacted the Land-Grant College Act, which essentially extended the opportunity of higher education (5) , including such disenfranchised groups as women and minorities. Each state was permitted to sell large tracts of (6) and use the proceeds to endow at least one public college.
(7) : Over the years, the decentralization and diversity of the America’s colleges and universities have promoted competition for students and resources. Competitive pressure first arose (8) . The academy’s impact really grew after World War II, when (9) commissioned by President Roosevelt argued that it was the federal government’s responsibility to (10) for basic research. Instead of being centralized in government laboratories, scientific research (11) in American universities and generated increasing investment. It also gave graduate students research opportunities and helped (12) far and wide, to the benefit of industry, medicine and society as a whole.
(13) : The end of the World War II saw passage of the Servicemen’s Readjustment Act of 1944. The law, which provided for (14) for returning veterans, made an already democratic higher-education system accessible in ways that were (15) in Europe, opening the doors of the best universities to men and women who had (16) of going to college.
(17) : The creation of federal loan guarantees and subsidy programs, as well as outright grants for college students brought (18) to higher education and further helped to democratize access. Since its founding (19) , the Federal Family Education Loan Program has funded more than 74 million student loans worth more than (20) .
查看答案
单项选择题

根据《中国银行业监督管理委员会行政许可实施程序规定》的要求，申请材料齐全并符合规定要求的，受理机关应在收到完整申请材料之日起（）受理行政许可申请，并向申请人发出受理通知书。

A.15日内

B.3日内

C.10日内

D.5日内
查看答案