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

查询全体主管的姓名(m name)、出生年份(birth)和所在部门(dept)，要求用小写字母表示所有部门名，数据表名为manager实现该功能的语句为 ______。

A．select"m name"，出生年份：，birth,islower(dep from manager

B．select m_name,"出生年份："，birth,islower(depfrom manager

C．selectm_name,"出生年份："，birth，dept from manager

D．selectm_name,"出生年份："，birth,upper(depfrom manager

答案

参考答案：B

解析：[评析] 查询全体主管的姓名(m_name)、出生年份(birth)和所在部门(dept)，要求用小写字母表示所有部门名。数据表为manager实现该功能的语句为： select m name,"出生年份："，birth,islower(dept) from manager；

问答题

Libraries form a vital part of the world’s systems of communication and education.
They make available knowledge accumulated through the ages. People in all walks of life use library resources in their work. People also turn to libraries to satisfy a desire for knowledge or to obtain material for leisure-time activity. In addition, many people enjoy book discussions, concerts, film programs, lectures, story hours, and a variety of other activities provided by libraries. Libraries also play an important role in preserving a society’s cultural heritage(遗产). The library ranks as one of society’s most useful service institutions.
The contents of libraries have changed so much through the years that the word library itself is, in a sense, inaccurate. The word comes from the Latin word liber, which means book. Today’s libraries house many books, of course. However, they also have a wide variety of other materials that communicate, educate, and entertain. These materials include magazines, manuscripts (手稿), newspapers, and computer documents.
Audio and visual materials include CDs, audiocassette tapes, videotapes, films, maps, paintings, and photographs.
In addition to regular books, a library may have large-type books, books for the blind, and tape recordings of books, called talking books. Librarians keep pace with the changing contents of libraries to serve as many people as possible. Their efforts have turned libraries into multimedia resource centers.
The expansion of library contents greatly increases the library’s ability to communicate and educate. For example, people interested in classical music can listen to CDs and read books on the topic. Students of agriculture can read magazines and watch videotapes on farming methods. Many people use magazines and newspapers to find the most up-to-date material on current events.
In addition to expanding contents, librarians have developed many kinds of libraries to serve the needs of different people. The materials of each kind of library are selected to meet the needs of a specific group of patrons. School libraries have collections that provide the information needed by elementary and high school students. Public libraries tailor their collections to the general public. Government library collections are geared chiefly toward serving the needs of government officials. Thousands of special libraries provide information for professional people, such as advertising specialists, bankers, editors, engineers, lawyers, physicians, and scientists.
查看答案
判断题

咖喱粉的使用最早源于中国。( )
查看答案