2024年5月7日发(作者：)

《双(原据数库理 卷

试》)语

《数据库原理（双语）》考试试卷（第一套）

课程号 5807605040

考试时间 100 分钟

适用专业年级（方计算机科学与技术2007级 向）：

闭卷笔试 考试方式及要

求：

总分五四题 号 三二一

得 分

阅卷人

分，将答案填在下表内）分，共一、单项选择题（每题240

10 2 1 7 8 6 5 9 4 3

题号 答案

20 17 18 14 15 16 19 11 12 13 题号 答案1. Physical data

independence(物理数据独立性)（ ）

A． Allows us to access(访问) the physical data independently(独立地)

from all applications(应用程序)

B． Allows us to rewrite(重写) the queries(查询) on the database without

affecting(影响) the physical data

C． Allows us to physically reorganize(重新组织) the data in the database

without affecting the applications running on the database

D． All of the above

2. Which of the following is NOT an advantage（优点） of database

） （systems?

A． Redundant data（冗余的数据）

B． Program-data independence(应用程序与数据相互独立)

C． Better data quality （更好的数据质量）

D． Reduced program maintenance（减少应用程序维护）

3. Which of the following is an example of a database integrity

constraint(完整性约束条件)? （ ）

A． The grade assigned(分配) to a student for a course must be either an A,

B, C, D or F

B． Every course must have a unique(唯一的) value for its course number

C． The name of any student must be less than 30 characters(字母) in length

D． All of the above

4. Customers(顾客), cars, and parts(零件) are examples of （ ）

A． entities(实体) B．attributes(属性) C．relations D．relationships(联系)

5. A(n) _____ is the relationship between a weak entity type and its owner.

（ ）

A． weak relationship B． identifying(识别) relationship

C． non-identifying(非识别) relationship D． owner relationship

6. The relational data model（关系数据模型） consists of(由……组成)

） （)? 组件which components(

A． Data structure（数据结构）

B． Data manipulation（数据操作）

C． Data integrity （完整性约束）

D． All of the above

7. A primary key that consists of more than one attribute is called a（ ）

A． foreign key（外键）

B． composite key（复合键）

C． multivalued key（多值键）

D． candidate key（候选键）

8. A rule that states that each foreign key value must match a primary key

value in the other relation is called the（ ）

A． referential integrity constraint（参照完整性约束）

B． entity integrity constraint（实体完整性约束）

C． domain integrity constraint（域完整性约束）

D． null constraint（空值约束）

9. Which of the following are anomalies（异常） that can be caused by

redundancies(冗余) in tables? （ ）

A． insertion（插入）

B． deletion（删除）

（修改） modification．C．

D． all of the above

10. A candidate key（候选键） must satisfy（满足） all of the following

conditions EXCEPT（除了）（ ）

A． the key must uniquely（唯一地） identify（识别） the row

B． the key must indicate the row's position in the table（表明行在表中的位置）

C． the key must be nonredundant（非冗余的）

D． each nonprime attribute（非主属性） is functionally dependent upon（函数依

赖于） it.

11. The intersection(交集) of two relations R(A,B,C) and S(A,B,C) can be

computed by（ ）

A． R÷S

B． R－(R－S)

C． R∪S

D． all of the above

12. This operation is commutative(可交换的) （ ）

A． Union(并)

B． Intersection(交)

)

笛卡尔积 Cartesian product(．C．

D． all of the above

13. What does the following SQL statement do? （ ）

Alter Table Customer_T Add (Type Varchar (2));

A． Alters the Customer_T table to accept Type 2 Varchars

B． Alters the Customer_T table to be a Type 2 Varchar

C． Alters the Customer_T table, and adds a field called Type

D． Alters the Customer_T table by adding a 2-byte field called Varchar

14. What does the following SQL statement do? （ ）

Update Product_T Set Unit_Price = 775 Where Product_ID = 7

A． Changes the price of a unit called Product_T to 7

B． Changes the unit price of Product 7 to 775

C． Changes the length of the Unit_Price field to 775

D． Updates the Product_T table to have a unit price of 775

15. Assume(假设) we have executed(执行) the following CREATE TABLE

statement：

CREATE TABLE Emp (

Ssn CHAR(9) Primary Key;

SuperSsn CHAR(9) REFERENCES EMP(Ssn)) ;

Which of the following could be used to insert(插入) the first row into the

Emp table? （ ）

)

INSERT INTO Emp(Ssn) VALUES (‘123456789' ．A．

B． INSERT INTO Emp(Ssn, SuperSsn) VALUES (‘123456789',

‘987654321')

C． INSERT INTO Emp(SuperSsn) VALUES (‘987654321')

D． all of the above

16. _____ is a set of commands（命令） used to update and query a

database. （ ）

A． DML

B． DDL

C． DCL

D． DPL

17. In an SQL statement, which of the following finds all groups meeting

stated conditions（符合条件的组）? （ ）

A． Select

B． Where

C． Having

D． Find

18. To eliminate duplicate rows（消除重复行） in a query, the _____

qualifier（限定符） is used in the SQL Select command. （ ）

A． alter

distinct

．B．

C． check

D． specific

19. _________ takes a value of true if a subquery（子查询） returns an

intermediate results(中间结果) table which contains（包含） one or

more rows. （ ）

A． In

B． Having

C． Exists

D． Extents

20. A _________is a temporary table（临时表） used in the FROM clause（子句） of

an SQL query. （ ）

A． correlated subquery（相关子查询）

B． derived table（导出表）

C． view table（视图表）

D． None of the above

二、判断题（每题1分，共10分，正确的填T，错误的填F，将答案填在下表

内）

题

1 2 3 4 5 6 7 8 9

号

答

案．

10

1. We can define(定义) a relation schema(关系模式) R(A1, A2, A3)

where A1 is the primary key(主键) and A3 is a foreign key(外键) that

refers to(参考) R.（ ）

2. A constraint（约束） is a rule in a database system that can be violated（违反）

by users. （ ）

3. The E-R model is used to construct（构建） a conceptual model（概念模型）. （ ）

4. The entity integrity rule（实体完整性规则）states that a primary key

attribute can be null. （ ）

5. The attribute value in a tuple（元组） that makes up（组成） a foreign

key(外键) can be null. （ ）

6. A composite key（复合键） consists of only one attribute. （ ）

7. One property（特征） of a relation is that each attribute within a

relation has a unique（唯一的） name. （ ）

8. The columns of a relation can be interchanged（交换） without

changing the meaning or use of the relation. （ ）