2014春浙大数据库系统论在线2014春浙大数据库系统概论在线.doc

 PAGE \* MERGEFORMAT14 数据库系统概论在线作业 一、单选题 1.包含在（）中的属性，叫做主属性。  HTMLCONTROL Forms.HTML:Option.1 A 主码  HTMLCONTROL Forms.HTML:Option.1 B 候选码  HTMLCONTROL Forms.HTML:Option.1 C 外码  HTMLCONTROL Forms.HTML:Option.1 D 全码 2.若事务T对数据对象 A 进行读取和修改操作，且其它任何事务都不能访问 A，此时事务 T需对数据对象A加上（ ）。  HTMLCONTROL Forms.HTML:Option.1 A 读锁  HTMLCONTROL Forms.HTML:Option.1 B 死锁  HTMLCONTROL Forms.HTML:Option.1 C 写锁  HTMLCONTROL Forms.HTML:Option.1 D 活锁 3.数据库三级模式体系结构的划分，有利于保持数据库的（ ）。  HTMLCONTROL Forms.HTML:Option.1 A 数据库独立性  HTMLCONTROL Forms.HTML:Option.1 B 数据库安全性  HTMLCONTROL Forms.HTML:Option.1 C 结构规范化  HTMLCONTROL Forms.HTML:Option.1 D 操作可行性 4.1NF（）规范为2NF。  HTMLCONTROL Forms.HTML:Option.1 A 消除非主属性对码的部分函数依赖  HTMLCONTROL Forms.HTML:Option.1 B 消除非主属性对码的传递函数依赖  HTMLCONTROL Forms.HTML:Option.1 C 消除主属性对码的部分和传递函数依赖  HTMLCONTROL Forms.HTML:Option.1 D 消除非平凡且非函数依赖的多值依赖 5.根据SQL标准，要查询表student中平均年龄age小于21的所在系dept及其平均年龄值，下面哪条语句适用？  HTMLCONTROL Forms.HTML:Option.1 A select dept,avg(age) from student where avg(age) 21  HTMLCONTROL Forms.HTML:Option.1 B select dept,avg(age) from student group by dept having avg(age) 21  HTMLCONTROL Forms.HTML:Option.1 C select dept,avg(age) from student having avg(age) 21  HTMLCONTROL Forms.HTML:Option.1 D select dept,avg(age) from student group by dept where avg(age) 21  HTMLCONTROL Forms.HTML:Hidden.1  6.在SQL语言中授权的操作是通过（）语句实现的。  HTMLCONTROL Forms.HTML:Option.1 A CREATE  HTMLCONTROL Forms.HTML:Option.1 B REVOKE  HTMLCONTROL Forms.HTML:Option.1 C GRANT  HTMLCONTROL Forms.HTML:Option.1 D INSERT  HTMLCONTROL Forms.HTML:Hidden.1  7.根据SQL标准，创建一个视图，应该使用下面哪个语句？  HTMLCONTROL Forms.HTML:Option.1 A CREATE TABLE  HTMLCONTROL Forms.HTML:Option.1 B CREATE INDEX  HTMLCONTROL Forms.HTML:Option.1 C CREATE VIEW  HTMLCONTROL Forms.HTML:Option.1 D CREATE DATABASE  HTMLCONTROL Forms.HTML:Hidden.1  8.数据库（DB）、数据库系统（DBS）和数据库管理系统（DBMS）三者之间的关系是（ ）。  HTMLCONTROL Forms.HTML:Opti