发布时间 : 星期日 文章2015年10月自考数据库系统原理(04735)试题及答案解析更新完毕开始阅读645c9ebb5b8102d276a20029bd64783e09127d93
promotion of employment, form a reasonable and orderly pattern of income distribution, build a more fair and sustainable social security systems, medical and health system reform. The plenary, innovation of social governance, must focus on the maintenance of fundamental interests of the overwhelming majority of the people, maximize factors, enhance social development, improving social governance, the interests of national security, ensure that the people live and work, social stability and order. o improve social governance, stimulating social organization, innovative and effective system of preventing and resolving social conflicts, improving the public security system, set up the National Security Council, national security systems and national security strategy to ensure national security. Plenary session, the construction of ecological civilization, you must establish systems of ecological system, using the system to protect the ecological environment. o improve natural resources asset property right system and use control, red line of delimitation of ecological protection, resources paid use system and ecological compensation system in ecological environment protection mnagement system reform. Plenary session, centering on building a listening party command, can win and having a fine style of the people's army, a strong army under the new situation of the party Goals, restricting the development of national defense and army building is solved outstanding contradictions and problems, innovation and development of military theory, enhance military strategic guidance, improve the military strategy in the new period, building a modern military force system with Chinese characteristics. o deepen the adjustment of personnel system reform in the army, military policy and system reform, promote the development of military and civilian integration depth. Plenary session stressed that comprehensive reform must be to strengthen and improve the party's leadership, give full play to the core role of the party commands the overall situation and coordinating all parties, improving the party's leading water ... Margin. Challenged the leadership of the Communist Party of China, Marxism-Leninism and Mao Zedong thought by Deng Xiao-ping's flag, replaced by three representatives and the harmonic society. The former Communist Party spirit and social cohesion point of almost all political makeover. Characteristics of socialism public ownership is shifting to private ownership, planned regulation and market regulation, the proletarian regime controlled by the elite. Of universal equality, fairness and basic principles of distribution system is socialist society, however after economic monopolized by powerful, vested interests growemployers do not have the same status, hardly seems fair social distribution. State key protection of capital interests rather than the interests of citizens, had been hits the bottom of the proletariat 2015年10月高等教育自学考试全国统一命题考试
数据库系统原理 试卷
(课程代码04735)
本试卷共4页，满分100分。考试时间150分钟。 考生答题注意事项： 1．本卷所有试题必须在答题卡上作答。答在试卷上无效，试卷空白处和背面均可作草稿纸。 2．第一部分为选择题。、必须对应试卷上的题号使用2B铅笔将“答题卡”的相应代码涂黑。 3．第二部分为非选择题。必须注明大、小题号，使用0．5毫米黑色字迹签字笔作答o 4．合理安排答题空间，超出答题区域无效。
第一部分 选择题
一、单项选择题(本大题共15小题。每小题2分。共30分)
在每小题列出的四个备选项中只有一个是符合题目要求的，请将其选出并将“答题卡” 的相应代码涂黑。未涂、错涂或多涂均无分。
1．不是数据管理技术进人数据库阶段的标志的20世纪60年代末的三件大事的是 A．1968年美国IBM公司推出层次模型IMS系统 B．1969年美国CODASYL组织发布了DBTG报告
C．1970年美国IBM公司的E．F．Codd连续发表论文 D．1970年James Gray因在数据库领域的成就获得图灵奖 2．关于概念模型的描述，不正确的是
A．概念模型表达了数据的局部逻辑结构
B．概念模型是从用户需要的观点出发，对数据建模 C．概念模型独立于硬件和软件
D．概念模型是数据库设计人员与用户之间进行交流的工具 3．不是数据库的运行与维护阶段任务的工作是
A．数据库的转储和恢复 B．数据库试运行
C．数据库安全性、完整性控制 D．数据库性能的监督、分析和改进 4．在关系模型中，对于关系性质叙述正确的是 A．关系中每一个属性值都是可分解的 B．关系中允许出现重复元组
C．由于关系是一个集合，因此不考虑元组间的顺序，即没有行序 D．元组中的属性在理论上是有序的
5．在讨论关系模式的质量时，关于非形式化的衡量准则，叙述不正确的是 A．关系模式的设计应尽可能只包含有直接联系的属性
B．尽可能使得相应关系中不出现插入、删除和修改等操作异常 C．相应关系中最好放置一些经常为空值的属性
D．尽可能使关系的等值连接在主键和外键的属性上进行 6．“左部不可约依赖”也称为
A．局部依赖 B．完全依赖
C．平凡函数依赖 D．非平凡的函数依赖 7．如题7图，两个关系R1和R2，运算能得到关系R3的是
bviously, face China's Socialist system, the Communist Party is not the party. In that case, political chaos has been very tight. Is remodeling or reconstruction, is a correction or a stove. Whether to turn right or left, is back to the source or put forward new political ideas. This is to determine the road problems in China, is also the key out of the deep water of the reform of the economic system. After 18, the new Central collective leadership attaches great importance to political orientation. First, the \point, starting from the Central Government's self-restraint, which preaches and pro-image, brought fresh feeling to the community. Secondly, before reform and opening up and reform and opening two periods after non-negative, untying the tangle of the society a long time on this issue. Third, a new generation of party leaders on various occasions to Mao Ze-Dong and Mao Ze-Dong's thought of evaluation has room for manoeuvre, through to the ruling ideology of Mao Zedong thought, is the call of the soul to the Socialist Revolution and construction. Empty talks jeopardize national interests and try again, is an affirmation of Deng Xiao-ping's reform ideas. These strong political signal showing a new generation of political leaders is still keeping to the Socialist road. Four is revisiting the \ng to Mao Ze-Dong's historical cycle of\profile anti-corruption and the importance of the Constitution, reorganization is bad style of officialdom, was to civilize people obey the lawwhile improving the color change of the regime of vigilance. Five is to reform into deeper waters and stressed that top-level design, this is a review on the reform and opening up in the past, is also looking for a way out. Six foreign and Russia closer, the flexible attitude on the issue of the Korean peninsula, Sino-Japanese fishing hardline China on the island out of the \ent\ow profile shadow began to gradually plan development. Signs show that the new leadership began to make a left turn in politics. However, as of right now, not only ideological confusion in the community, the new leadership's thinking is messy. New leaders both stressed the need to implement the Constitution, stressed the need to turn off the power in a cage. Also stresses that Mao Zedong thought cannot be lost, 30 years after the reform and opening up 30 years ago can not deny each other. Both advocate democracy and release \n does not speak of\cal constraints. Neither deny the history of the CPC Central Committee on several issues ... Comrades: today brings together members, mainly in order to provide a platform to Exchange and learn from each other in order to facilitate our work. Just now, we focus on taxation, planning and stability, safety, project construction, typical topics such as private facts presentation and interaction, and towns currently exist in the in-depth analysis of the problems to be solved, to explore new methods to solve the problem. It can be said that summing up the achievement, no grandstanding; analysis promotion of employment, form a reasonable and orderly pattern of income distribution, build a more fair and sustainable social security systems, medical and health system reform. The plenary, innovation of social governance, must focus on the maintenance of fundamental interests of the overwhelming majority of the people, maximize factors, nhance social development, improving social governance, the interests of national security, ensure that the people live and work, social stability and order. o improve social governance, stimulating social organization, innovative and effective system of preventing and resolving social conflicts, improving the public security system, set up the National Security Council, national security systems and national security strategy to ensure national security. Plenary session, the construction of ecological civilization, you must establish systems of ecological system, using the system to protect the ecological environment. o improve natural resources asset property right system and use control, red line of delimitation of ecological protection, resources paid use system and ecological compensation system in ecological environment protection management system reform. Plenary session, centering on building a listening party command, can win and having a fine style of the people's army, a strong army under the new situation of the party Goals, restricting the development of national defense and army building is solved outstanding contradictions and problems, innovation and development of military theory, enhance military strategic guidance, improve the military strategy in the new period, building a modern military force system with Chinese characteristics. o deepen the adjustment of personnel system reform in the army, military policy and system reform, promote the development of military and civilian integration depth. Plenary session stressed that comprehensive reform must be to strengthen and improve the party's leadership, give full play to the core role of the party commands the overall situation and coordinating all parties, improving the party's leading water ... Margin. Challenged the leadership of the Communist Party of China, Marxism-Leninism and Mao Zedong thought by Deng Xiao-ping's flag, replaced by three representatives and the harmonic society. The former Communist Party spirit and social cohesion point of almost all political makeover. Characteristics of socialism public ownership is shifting to private ownership, planned regulation and market regulation, the proletarian regime controlled by the elite. Of universal equality, fairness and basic principles of distribution system is socialist society, however after economic monopolized by powerful, vested interests grow, employers do not have the same status, hardly seems fair social distribution. State key protection of capital interests rather than the interests of citizens, had been hits the bottom of the proletariat A．连接 B．笛卡儿积 C．并 D．交
8．设有关系R和S，与R-S等价的元组关系演算表达式是
9．在SQL查询语言中，用于合并查询的谓词是
A．Exists B．All C．Union D．Some
10．设某数据库中一个表S的结构为S(SNAME，CNAME，GRADE)，其中SNAME为学生名，CNAME为课程名，二者均为字符型，GRADE为成绩，数值型，取值范围是0一100，若要把“张一的化学成绩80分”插入S中，则下列语句正确的是 A．ADD INTO S VALUES(ˋ张一ˊ， ˋ化学ˊ， ˋ80ˊ) B．INSERT INTO S VALUES(ˋ张一ˊ，ˋ化学ˊ， ˋ80ˊ) C．ADD INTO S VALUES(ˋ张一ˊ， ˋ化学ˊ， 80) D．INSERT INTO S VALUES(ˋ张一ˊ，ˋ化学ˊ，80) 11．关于事务的故障与恢复，下列说法正确的是 A．事务日志用来记录事务执行的频度 B．任何故障的恢复都由系统自动完成 C．系统故障的恢复只需进行RED0操作
D．对日志文件设置检查点是为了提高故障恢复的效率 12．若事务T1已经给数据A加上了排他锁，则事务T2
A．只能再对数据A加共享锁 B．不能再给数据A加任何锁 C．只能再对数据A加排他锁 D．可以对数据A加任何锁
13．在SQL Server 2000安装时，安装程序会把系统文件存放在启动盘的目录下，存放日志文件的目录是
A．＼Log B．＼Books C．＼Jobs D．＼BackUp 14．PowerBuilder 9．0中，可以对应用程序的0pen、Close、Error等事件编程的画板是 A．数据窗口画板 B．数据管道画板 C．应用画板 D．函数画板 15．一个UML类图，如题l5图所示，表示类的名称的是
A．Faculty B．fno C．salary D．num_teach
第二部分 非选择题
bviously, face China's Socialist system, the Communist Party is not the party. In that case, political chaos has been very tight. Is remodeling or reconstruction, is a correction or a stove. Whether to turn right or left, is back to the source or put forward new political ideas. This is to determine the road problems in China, is also the key out of the deep water of the reform of the economic system. After 18, the new Central collective leadership attaches great importance to political orientation. First, the \point, starting from the Central Government's self-restraint, which preaches and pro-image, brought fresh feeling to the community. Secondly, before reform and opening up and reform and opening two periods after non-negative, untying the tangle of the society a long time on this issue. Third, a new generation of party leaders on various occasions to Mao Ze-Dong and Mao Ze-Dong's thought of evaluation has room for manoeuvre, through to the ruling ideology of Mao Zedong thought, is the call of the soul to the Socialist Revolution and construction. Empty talks jeopardize national interests and try again, is an affirmation of Deng Xiao-ping's reform ideas. These strong political signal showing a new generation of political leaders is still keeping to the Socialist road. Four is revisiting the \ng to Mao Ze-Dong's historical cycle of\profile anti-corruption and the importance of the Constitution, reorganization is bad style of officialdom, was to civilize people obey the lawwhile improving the color change of the regime of vigilance. Five is to reform into deeper waters and stressed that top-level design, this is a review on the reform and opening up in the past, is also looking for a way out. Six foreign and Russia closer, the flexible attitude on the issue of the Korean peninsula, Sino-Japanese fishing hardline China on the island out of the \ent\ow profile shadow began to gradually plan development. Signs show that the new leadership began to make a left turn in politics. However, as of right now, not only ideological confusion in the community, the new leadership's thinking is messy. New leaders both stressed the need to implement the Constitution, stressed the need to turn off the power in a cage. Also stresses that Mao Zedong thought cannot be lost, 30 years after the reform and opening up 30 years ago can not deny each other. Both advocate democracy and release \n does not speak of\cal constraints. Neither deny the history of the CPC Central Committee on several issues ... Comrades: today brings together members, mainly in order to provide a platform to Exchange and learn from each other in order to facilitate our work. Just now, we focus on taxation, planning and stability, safety, project construction, typical topics such as private facts presentation and interaction, and towns currently exist in the in-depth analysis of the problems to be solved, to explore new methods to solve the problem. It can be said that summing up the achievement, no grandstanding; analysis promotion of employment, form a reasonable and orderly pattern of income distribution, build a more fair and sustainable social security systems, medical and health system reform. The plenary, innovation of social governance, must focus on the maintenance of fundamental interests of the overwhelming majority of the people, maximize factors, enhance social development, improving social governance, the interests of national security, ensure that the people live and work, social stability and order. o improve social governance, stimulating social organization, innovative and effective system of preventing and resolving social conflicts, improving the public security system, set up the National Security Council, national security systems and national security strategy to ensure national security. Plenary session, the construction of ecological civilization, you must establish systems of ecological system, using the system to protect the ecological environment. o improve naturalresources asset property right system and use control, red line of delimitation of ecological protection, resources paid use system and ecological compensation system in ecological environment protection management system reform. Plenary session, centering on building a listening party command, can win and having a fine style of the people's army, a strong army under the new situation of the party Goals, restricting the development of national defense and army building is solved outstanding contradictions and problems, innovation and development of military theory, enhance military strategic guidance, improve the military strategy in the new period, building a modern military force system with Chinese characteristics. o deepen the adjustment of personnel system reform in the army, military policy and system reform, promote the development of military and civilian integration depth. Plenary session stressed that comprehensive reform must be to strengthen and improve theparty's leadership, give full play to the core role of the party commands the overall situation and coordinating all parties, improving the party's leading water ... Margin. Challenged the leadership of the Communist Party of China, Marxism-Leninism and Mao Zedong thought by Deng Xiao-ping's flag, replaced by three representatives and the harmonic society. The former Communist Party spirit and social cohesion point of almost all political makeover. Characteristics of socialism public ownership is shifting to private ownership, planned regulation and market regulation, the proletarian regime controlled by the elite. Of universal equality, fairness and basic principles of distribution system is socialist society, however after economic monopolized by powerful, vested interests growemployers do not have the same status, hardly seems fair social distribution. State key protection of capital interests rather than the interests of citizens, had been hits the bottom of the proletariat 二、填空题(本大题共10小题。每小题1分，共10分) 请在答题卡上作答。
16．DBMS总是基于某种数据模型，可以分为层次型、网状型、________和面向对象模 型。
17．概念设计中最著名的方法就是________。
18．在关系模式R中，能函数决定所有属性的属性组称为模式R的________。
19．在对关系R和S做自然连接时，把原该舍弃的元组也保留在新关系中，同时在这些元组 新增加的属性上填上空值，这种操作称为
20．在SQL语言中，对分组查询中指定满足条件的语句是________。
21．视图被用来对无权用户屏蔽数据。用户只能使用视图定义中的数据，而不能使用视图 定义外的其他数据，从而保证了数据________。
22．DBMS的恢复子系统必须在系统重新启动时，对非正常终止的事务进行处理，把数据库 恢复到________状态。
23．SQL Server中，存储过程是存放在服务器上的预先________好的SQL语句。 24．系统树窗口为PowerBuilder开发人员提供了关于________的活动状态视图。 25．ODBC规范定义的驱动程序有两种类型：即单层驱动程序和________。 三、简答题 (本大题共10小题，每小题3分，共30分) 请在答题卡上作答。
五、综合题(本大题共2小题，每小题5分，共10分) 请在答题卡上作答。
41．设有一个商业集团的关系模式R(商品号，商品名，类号，类名，商店号，商店名，地址，售价)，每种商品在每个商店只有一个售价。
bviously, face China's Socialist system, the Communist Party is not the party. In that case, political chaos has been very tight. Is remodeling or reconstruction, is a correction or a stove. Whether to turn right or left, is back to the source or put forward new political ideas. This is to determine the road problems in China, is also the key out of the deep water of the reform of the economic system. After 18, the new Central collective leadership attaches great importance to political orientation. First, the \point, starting from the Central Government's self-restraint, which preaches and pro-image, brought fresh feeling to the community. Secondly, before reform and opening up and reform and opening two periods after non-negative, untying the tangle of the society a long time on this issue. Third, a new generation of party leaders on various occasions to Mao Ze-Dong and Mao Ze-Dong's thought of evaluation has room for manoeuvre, through to the ruling ideology of Mao Zedong thought, is the call of the soul to the Socialist Revolution and construction. Empty talks jeopardize national interests and try again, is an affirmation of Deng Xiao-ping's reform ideas. These strong political signal showing a new generation of political leaders is still keeping to the Socialist road. Four is revisiting the \ng to Mao Ze-Dong's historical cycle of\profile anti-corruption and the importance of the Constitution, reorganization is bad style of officialdom, was to civilize people obey the lawwhile improving the color change of the regime of vigilance. Five is to reform into deeper waters and stressed that top-level design, this is a review on the reform and opening up in the past, is also looking for a way out. Six foreign and Russia closer, the flexible attitude on the issue of the Korean peninsula, Sino-Japanese fishing hardline China on the island out of the \ent\ow profile shadow began to gradually plan development. Signs show that the new leadership began to make a left turn in politics. However, as of right now, not only ideological confusion in the community, the new leadership's thinking is messy. New leaders both stressed the need to implement the Constitution, stressed the need to turn off the power in a cage. Also stresses that Mao Zedong thought cannot be lost, 30 years after the reform and opening up 30 years ago can not deny each other. Both advocate democracy and release \n does not speak of\cal constraints. Neither deny the history of the CPC Central Committee on several issues ...Comrades: today brings together members, mainly in order to provide a platform to Exchange and learn from each other in order to facilitate our work. Just now, we focus on taxation, planning and stability, safety, project construction, typical topics such as private facts presentation and interaction, and towns currently exist in the in-depth analysis of the problems to be solved, to explore new methods to solve the problem. It can be said that summing up the achievement, no grandstanding; analysis
数据库系统原理试卷第 3 页共 6页
promotion of employment, form a reasonable and orderly pattern of income distribution, build a more fair and sustainable social security systems, medical and health system reform. The plenary, innovation of social governance, must focus on the maintenance of fundamental interests of the overwhelming majority of the people, maximize factors, nhance social development, improving social governance, the interests of national security, ensure that the people live and work, social stability and order. o improve social governance, stimulating social organization, innovative and effective system of preventing and resolving social conflicts, improving the public security system, set up the National Security Council, national security systems and national security strategy to ensure national security. Plenary session, the construction of ecological civilization, you must establish systems of ecological system, using the system to protect the ecological environment. o improve natural resources asset property right system and use control, red line of delimitation of ecological protection, resources paid use system and ecological compensation system in ecological environment protection management system reform. Plenary session, centering on building a listening party command, can win and having a fine style of the people's army, a strong army under the new situation of the party Goals, restricting the development of national defense and army building is solved outstanding contradictions and problems, innovation and development of military theory, enhance military strategic guidance, improve the military strategy in the new period, building a modern military force system with Chinese characteristics. o deepen the adjustment of personnel system reform in the army, military policy and system reform, promote the development of military and civilian integration depth. Plenary session stressed that comprehensive reform must be to strengthen and improve the party's leadership, give full play to the core role of the party commands the overall situation and coordinating all parties, improving the party's leading water ... Margin. Challenged the leadership of the Communist Party of China, Marxism-Leninism and Mao Zedong thought by Deng Xiao-ping's flag, replaced by three representatives and the harmonic society. The former Communist Party spirit and social cohesion point of almost all political makeover. Characteristics of socialism public ownership is shifting to private ownership, planned regulation and market regulation, the proletarian regime controlled by the elite. Of universal equality, fairness and basic principles of distribution system is socialist society, however after economic monopolized by powerful, vested interests grow, employers do not have the same status, hardly seems fair social distribution. State key protection of capital interests rather than the interests of citizens, had been hits the bottom of the proletariat (1)写出关系模式R的关键码。 (2)将R规范到2NF。 (3)将R规范到3NF。
42．一个工厂要建立一个管理数据库系统，该系统有部门、职工、设备、零部件、厂商等实体，各实体属性如下：
部门：部门号、部门名、电话、地址； 职工：职工号、职工名、性别、职务； 设备：设备号、名称、价格；
零部件：零部件号、名称、规格、价格； 厂商：单位号、名称、电话、地址。
一个部门有多个职工，但每个职工只能在一个部门工作；一个部门管理多台设备， 每台设备只属于一个部门；一台设备装配多种零部件，每种零部件可以装配在多台设备 上；一个厂商可以提供多种零部件，每种零部件可以由多个厂商提供。 (1)试画出反映上述实体关系的E—R图(可以省略实体的属性)。
(2)转换成关系模式，并指出每个关系模式的主键和外键(如果存在)。
bviously, face China's Socialist system, the Communist Party is not the party. In that case, political chaos has been very tight. Is remodeling or reconstruction, is a correction or a stove. Whether to turn right or left, is back to the source or put forward new political ideas. This is to determine the road problems in China, is also the key out of the deep water of the reform of the economic system. After 18, the new Central collective leadership attaches great importance to political orientation. First, the \point, starting from the Central Government's self-restraint, which preaches and pro-image, brought fresh feeling to the community. Secondly, before reform and opening up and reform and opening two periods after non-negative, untying the tangle of the society a long time on this issue. Third, a new generation of party leaders on various occasions to Mao Ze-Dong and Mao Ze-Dong's thought of evaluation has room for manoeuvre, through to the ruling ideology of Mao Zedong thought, is the call of the soul to the Socialist Revolution and construction. Empty talks jeopardize national interests and try again, is an affirmation of Deng Xiao-ping's reform ideas. These strong political signal showing a new generation of political leaders is still keeping to the Socialist road. Four is revisiting the \ng to Mao Ze-Dong's historical cycle of\profile anti-corruption and the importance of the Constitution, reorganization is bad style of officialdom, was to civilize people obey the lawwhile improving the color change of the regime of vigilance. Five is to reform into deeper waters and stressed that top-level design, this is a review on the reform and opening up in the past, is also looking for a way out. Six foreign and Russia closer, the flexible attitude on the issue of the Korean peninsula, Sino-Japanese fishing hardline China on the island out of the \ent\ow profile shadow began to gradually plan development. Signs show that the new leadership began to make a left turn in politics. However, as of right now, not only ideological confusion in the community, the new leadership's thinking is messy. New leaders both stressed the need to implement the Constitution, stressed the need to turn off the power in a cage. Also stresses that Mao Zedong thought cannot be lost, 30 years after the reform and opening up 30 years ago can not deny each other. Both advocate democracy and release \n does not speak of\cal constraints. Neither deny the history of the CPC Central Committee on several issues ... Comrades: today brings together members, mainly in order to provide a platform to Exchange and learn from each other in order to facilitate our work. Just now, we focus on taxation, planning and stability, safety, project construction, typical topics such as private facts presentation and interaction, and towns currently exist in the in-depth analysis of the problems to be solved, to explore new methods to solve the problem. It can be said that summing up the achievement, no grandstanding; analysis