数据库选择判断题（中英文）

1. A primary key is a field (or group of fields) that uniquely describes each record in the database. T

2. Data redundancy improves the integrity of a database.

3. SQL is the language used by relational databases to create objects and to manipulate and retrieve data.

4. A relational database management system does not include tools for backing up & restoring databases.

5. 1，一种主键是一个字段（或字段组）唯一地描述了每个记录在数据库中。Ť

6. 2.数据冗余改善了数据库的完整性。

7. 3，SQL是关系型数据库用于创建对象，并以操作和检索数据的语言。

8. 4.关系数据库管理系统并不包括用于备份和恢复数据库的工具。

9. An attribute is also known as a row in most databases.

10. An association between entities is known as a relationship.

11. Integrity constraints limit the number of entities that can be placed in a table or database.

12. The Entity-Relationship data model is often used in the physical design phase.

13. The concept “relation” in relation model is exactly the same as the concept “relationship” in ER model.

14. 9.一种属性也被称为一个行中大多数数据库。

15. 10.实体之间的关联称为关系。

16. 11.完整性约束限制可以被放置在一个表或数据库实体的数目。

17. 12.实体关系数据模型中经常使用的物理设计阶段。

18. 13.在关系模型的概念'关系'是完全一样的ER模型的概念的“关系”。

19. Most relationship sets in a database system involves two entity sets.

20. The closure of an attribute set contains that attribute set.

21. Lossless decomposition is necessary in a decomposition algorithm.

22. If A → B and C → D hold, then AC → BD also holds.

23. It is not necessary that a legal schedule preserves the order in which the instructions appear in each individual transaction.

24. Update operations in database must be written into log before updating database.

25. 19.大多数关系套在数据库系统中包括两个实体集。

26. 设置属性20.关闭包含的属性设置。

27. 21.无损分解是必要的分解算法。

28. 22.如果A→B和C→d握住，然后AC→BD还持有。

29. 23.这是没有必要，一个法律时间表保留在其中的指令出现在每个单独的事务处理的次序。

30. 在数据库24的更新操作必须写入日志更新数据库之前。

未知答案：

1. At its simplest, a database can be seen as a collection of related data.

2. If a salesperson attempts to order merchandise for a customer not in the customer service database, the database will typically generate an error message. This message indicates that an integrity constraint has been violated.

3. An advantage of using a relational database is to facilitate consistency.

4. With the six basic operations (union, difference, selection, projection, product, and renaming), relational algebra is complete. Other operations are just syntactic sugar and can be derived from the basic operations.

5. Once a transition is committed, the changes it has made to database persist across system crashes, that is, consistency.

6. 1.在其最简单的，数据库可以被看作是相关的数据的集合。

7. 2.如果营业员试图订购商品的顾客不是在客户服务数据库，该数据库将典型地产生一个错误信息。此消息表明完整性约束已经被破坏。

8. 3.使用关系数据库的一个优点是便于一致性。

9. 4.在六种基本操作（集，差，选择，投影，产品和重命名），关系代数完成。其他的操作都只是语法糖，并且可以从基本操作得到的。

10. 5.一旦过渡被提交，已作出的数据库中的改变持续整个系统崩溃，即，一致性。

1. _______ is the most widely used data model

A. relational model B. entity-relationship model

C. object-based data model D. semi-structured data model

是最广泛使用的数据模型

A.关系模型B.实体关系模型

C.基于对象的模型数据D.半结构化的数据模型

一个关系模式是一组_______。

A.元组B.属性C.列D.行

2. A relation schema is a set of _______.

A. tuples B. attributes C. columns D. rows

3.一组属性，这些属性，采取集体，使我们能够唯一标识关系中的一个元组被称为______的。

A.超键B.主键C.候选键D.外键

3. A set of attributes that, taken collectively, allow us to identify uniquely a tuple in the relation is called ______.

A. super key B. primary key C. candidate key D. foreign key

4.应用程序用户在_______级数据交互。

A.物理B.逻辑C.查看D.以上所有的

4. Application users interact with data in the _______ level.

A. physical B. logical C. view D. all of the above

5.关系代数是_____语言

A.程序B.声明C.自然D.商业

5. Relational algebra is a _____ language

A. procedural B. declarative C. natural D. commercial

6.关系代数的基本操作包括________。

A.广义投影，聚合函数，外部联接

B.设置交集，自然连接，分立，转让

C.选择，项目设置工会，设置不同，笛卡尔积，重命名

D.设置路口，设置工会，设置不同的

6. The fundamental operations of relational algebra includes_______.

A. generalized projection, aggregate function, outer join

B. set-intersection, natural join, division, assignment

C. select, project, set-union, set-difference, Cartesian product, rename

D. set-intersection, set-union, set-difference

7.如果表S有M列，表T具有N列，那么S和T的笛卡尔积具有____列。

A.M。* N B. M-N C. M + N D. M + N-1

7. If table S has M columns, table T has N columns, then the Cartesian product of S and T has ____ columns.

A. M*N B. M-N C. M+N D. M+N-1

8.关系代数的______操作需要两个参与关系有属性的数相同。

A.师B.参加C.笛卡尔积D.单位

8. The ______ operation in relational algebra requires the two participating relations have the same number of attributes.

A. division B. join C. Cartesian product D. union

9. _____不包含在SQL语言？

A.查询评估B.完整性C​​.查看D.授权

9. ______is not contained in SQL language?

A. query evaluation B. integrity C. view D. authorization

10. 在SQL语句选择关键字对应关系代数的______操作。

A.选择B.投影C.参与D.鸿沟

10. The SELECT keyword in a SQL statement corresponds to the ______ operation in relational algebra.

A. select B. projection C. join D. divide

11. SQL语言用________语句从数据库中删除表。

A.废除B.删除C.卸下D. DROP

11. SQL language use the ________ statement to remove a table from database.

A. REVOKE B. DELETE C. REMOVE D. DROP

12.使用视图是_______有益的。

A.并发控制B.安全C.故障恢复D.以上所有的

12. Using views is beneficial to _______.

A. concurrency control B. security C. failure recovery D. all of the above

13.触发器可以定义一些要执行的动作______在数据库中的一些事件。

A.C。，代替D.后B之前所有上述

13. A trigger can define some actions to be executed ______ some events in database.

A. before B. after C. instead of D. all of the above

14. ______不是ER模型的基本概念。

A.实体B.关系C.程度D.属性

S的

14. ______ is not the basic notions of the E-R model.

A. entity B. relationship C. degree D. attribute

15.如果映射基数从实体集合S到实体集T是一对多，则T的实体与____实体相关联（实体）

答：一个B.最多一个C.至少一个D.多

15. If the mapping cardinality from entity set S to entity set T is one to many, then an entity of T is associated with ____ entity(entities) of S.

A. one B. at most one C. at least one D. many

16.一种通过该关系被视为更高级别的抽象实体被称为_____。

A.聚集B.泛化C.专业化D.属性继承

16. An abstraction through which relationships are treated as higher-level entities is called _____.

A. aggregation B. generalization C. specialization D. attribute inheritance

17.映射ER图到关系模式可以在该阶段发生______。

A.需求分析B.概念设计

C.逻辑设计D.物理设计

17. Mapping an E-R diagram into relation schemas can happen in the phase of ______.

A. requirement analysis B. conceptual design

C. logical design D. physical design

18. _______关系组表示为与两个参与实体集的主键属性的模式。

A.一到1 B.一到多C.许多对一D.多对许多

18. A _______ relationship set is represented as a schema with attributes for the primary keys of the two participating entity sets.

A. one-to-one B. one-to-many C. many-to-one D. many-to-many

19.从函数依赖集F = {A→B，BC→D，C→ê}，我们可以推断that_____。

A.交流→ABCDE B. BC→ABCDE C. CD→ABCDE D.以上都不是

19. From the functional dependency set F={A→B, BC→D, C→E}, we can infer that_____.

A. AC→ABCDE B. BC→ABCDE C. CD→ABCDE D. none of the above

20. ______消除了可以基于函数依赖发现的所有冗余

A. 1NF B. 2NF C. 3NF D. BCNF

20. ______ eliminates all redundancy that can be discovered based on functional dependencies

A. 1NF B. 2NF C. 3NF D. BCNF

21.我们必须确保______在数据库设计的性能。

A. BCNF B.无损分解C.依赖保鲜D. 3NF

21. We must ensure the property of ______ in database design.

A. BCNF B. lossless decomposition C. dependency preservation D. 3NF

22. _____不是事务的属性

A.积极B.一致性C.隔离D.耐久性

22. _____is not the property of transactions.

A. active B. consistency C. isolation D. durability

23. ____控制并发事务中的交互。

答：查询处理器B.存储管理器

C.并发控制管理器D.数据库管理员

23. ____ controls interactions among concurrent transactions.

A. query processor B. storage manager

C. concurrency control manager D. database administrator

24. _____of以下指令对不冲突。

A.阅读（Q），阅读（Q）B.阅读（Q），写（Q）

C.写（Q），阅读（Q）D.写（Q），写（Q）

24. _____of the following pairs of instructions do not conflict.

A. read(Q), read(Q) B. read(Q), write(Q)

C. write(Q), read(Q) D. write(Q), write(Q)

25.可序列化调度相当于_____串行调度（S）。

A.只有一个B.至少一个C.至多一个D.任何数量的

25. A serializable schedule is equivalent to _____ serial schedule(s).

A. only one B. at least one C. at most one D. any number of

26.如果一个事务T已经在数据项Q上获得共享锁，则T可以______ Q.

A.读取B.写C.读写D.既不会读也不会写

交易的S

26. If a transaction T has obtain a shared lock on data item Q, then T can ______ Q.

A. read B. write C. both read and write D. neither read nor write

27.时间戳比事务T if_____时间戳较小。

答：小号提交之前牛逼犯B. S有于T更少的指令

C. S使用于T D.S。进入系统牛逼以前少的数据项

27. The timestamp of transaction S is smaller than the timestamp of transaction T if_____.（什么情况下事务S的时间戳比事务T的时间戳小）

A. S commits before T commits B. S has fewer instructions than T

C. S uses less data items than T D. S enters the system before T （S比T更早进入系统）

28.在时间戳协议，如果TS（TI）（TJ），串行化顺序is_____。

A.交易钛出现交易TJ前

B.交易TJ出现交易钛前

C.由实际执行确定

D.不能确定

28. In the timestamp protocol, if TS(Ti)j), the serializability order is_____.

A. transaction Ti appears before transaction Tj

B. transaction Tj appears before transaction Ti

C. determined by the actual execution

D. not sure

29.假设交易T22，T23，T24有时间戳5,10,15，分别。如果T22请求由T23持有的数据项，那么T22将等待。如果请求T24 T23所举办的数据项，那么T24将回滚。这种技术被称为______。

A.并行B.饥饿C.等待模D.伤口等待

29. Suppose transactions T22, T23, T24 have timestamps 5,10,15, respectively. If T22 requests a data item held by T23, then T22 will wait. If T24 requests a data items held by T23, then T24 will be rolled back. This technique is called ______.

A. concurrent B. starvation C. wait-die D. wound-wait

30. _____是不是发生时检查站执行的操作。

A.输出到磁盘的所有修改的缓冲块

B.输出到目前居住在主内存中的所有日志记录的稳定存储

C.执行所有的更新操作

D.输出到稳定的存储日志记录<检查点>

30. _____ is not the action to take place when checkpoints are performed.

A. output onto the disk all modified buffer blocks

B. output onto the stable storage all log records currently residing in main memory

C. perform all update actions

D. output onto stable storage a log record

1. A collection of interrelated data and a set of programs to access the data is called

A. Database B. Database system C. File system D. DBMS

2. A major purpose of a database system is to

A. enable users to access data B. provide users with an abstract view of the data

C. assist users to store information D. check the constraints

相互关联的数据的1，一种收集和一组程序来访问数据被称为

A.数据库B.数据库系统C.文件系统D.数据库管理系统

2.数据库系统的一个主要目的是

A.使用户能够访问数据B.为用户提供数据的抽象视图

C.帮助用户存储信息D.检查约束

3. In database, how the data are actually stored is resolved at

A. conceptual level B. view level C. logical level D. physical level

4. The collection of information stored in the database at a particular moment is called

A. database instance B. database scheme C. physical scheme D. data relationship

5. A set of one or more attributes that, taken collectively, allow us to identify uniquely a tuple in the relation is called

A. candidate key B. super key C. primary key D. foreign key

3.在数据库中，数据是如何实际存储在被解析

A.概念B级视图级别C.逻辑层D.物理层

4.在特定时刻存储在数据库中的信息的集合被称为

A.数据库实例B.数据库模式C.物理方案D.数据关系

5.一组中的一个或多个属性的是，采取集体，使我们确定唯一的关系的元组被称为

A.候选键B.超键C.主键D.外键

6. Physical data independence means

A. application programs need not be rewritten if database schema changes

B. in database, data need not to be reorganized if database schema changes

C. application programs do not depend on physical database schema

D. in database, logical schema must be redesigned if physical schema changes

7. Data Definition Language is used to define relational databases, includes

A. define relational table, domain and user-defined types

B. define consistency constraints like domain constraints, referential integrity etc.

C. both A and B D. neither A nor B

8. In following terms, is proper.

A. relation is a table in relational database B. attribute is a row of a table

C. tuple means a column of a table D. each table must has many rows.

6物理数据独立性的手段

A.应用程序不需要，如果数据库架构更改改写

B.在数据库中，数据不需要进行重组，如果数据库架构更改

C.应用程序不依赖于物理数据库架构

D.在数据库中，逻辑模式必须的，如果物理模式的变化重新设计

7.数据定义语言来定义关系数据库，包括

A.定义关系表，域和用户定义类型

B.这样定义域约束，参照完整性等一致性约束

C. A和B D. A和B都

8.下列术语，是正确的。

答关系是在关系数据库B属性的表是一个行的表

C.元组指表D.每个表必须有许多行的一列。

9. A relation r1 may include among its attributes, a subset of attributes named as S, the primary key of another relation r2, is a correct description.

A. S is a foreign key of r2 B. S is a foreign key of r1

C. r1 is referenced relation in this foreign key dependence

D. S is referenced relation in this foreign key dependence

10. Stored Procedure

A. is just the same as Stored Function

B. is a subroutine available to applications that access a relational database system

C. can be executed on database server or called by application server.

D. is a transaction that must be treated as a whole.

9甲关系R1可以包括在其属性，命名为S，另一种关系r2中的主键，属性的子集是一个正确的描述。

答：A .S为R2

B. S的外键是R1的外键

C. R1被引用的关系在这个外键的依赖

D. S被引用的关系，在这个外键的依赖

10.存储过程

答：A是一样的存储函数

B.提供一个子程序访问一个关系数据库系统的应用程序

C.可以数据库服务器上执行或调用应用程序服务器。

D.是必须被视为一个整体的交易。

11. Let A, B, C and D be attributes, in the following relational algebra expressions, is not a relation.

A. R(ABCD) B.R(A) C. R(A,B) D. R(A,B) S(C,D)

12. is not contained in the SQL language?

A. Integrity B. Query execution plan C. Transaction control D. Authorization

13. Among the following sentences about trigger, is wrong.

A. trigger is a special kind of stored procedure

B. trigger is different to stored procedure in that it is auto-executed and with no parameters.

C. triggers can be used to maintain data consistence

D. in triggers, temporary table deleted and inserted can be queried and updated.

11设A，B，C和D是属性，在下面的关系代数表达式，是不是一个关系。

A. R（A B C D）BR（A）C. R（A，B），D。R（A，B） S（C，D）

12.不包含在SQL语言？

A.诚信B.查询执行计划C.事务控制D.授权

13.在有关触发下面的句子，是错误的。

答：触发器是一种特殊类型的存储过程

B.触发不同于存储过程中，它是自动执行，并且不带参数。

C.触发器还可以保持数据的一致性

DIN触发器，临时表中删除和插入可以查询和更新。

14. When a view is created, must be stored in data dictionary.

A. the corresponding select sentence B. the definition of the view

C. the data of the view D. the definition of tables used to define the view

15. In SQL, is an equivalent operator to “NOT IN”

A. <>ALL B. <> SOME C. =ALL D. =SOME

16. In SQL, “CREATE INDEX” is used to create a

A. relation Schema B. virtual relation

C. a secondary table used to accelerate query D. database schema

当创建一个图，必须存储在数据字典。

是的。视图的对应的选择句子B中的定义

C.视图D.用来定义视图表的定义的数据

15.在SQL中，是一个等效操作员“NOT IN”

A.<> ALL B.<> SOME C.= ALL D.=部分

16.在SQL中，“CREATE INDEX”用于创建一个

A.关系模式B.虚拟关系

C.辅助表用于加速查询DI。数据库模式

17. Given the following tables:

Which of the following statements removes the rows from the Stud table that have courses in the SC table?

A. DELETE FROM Stud WHERE S# IN (SELECT Sno FROM SC);

B. DELETE FROM Stud WHERE S# IN (SELECT S# FROM SC);

C. DELETE FROM Stud WHERE Sno IN (SELECT S# FROM SC);

D. DELETE FROM Stud WHERE Sno IN (SELECT Sno FROM SC);

18. A m:n relationship in ER model can be transferred into a relation with its primary key composed of

A. primary key of relation at m side B. primary key of relation at n side

C. attributes of the relationship itself D. primary keys of relation at both sides

以下哪项陈述将删除梭哈表已经在SC表课程行？

A. DELETE FROM梭哈其中S＃IN（SELECT没有来自SC）;

B. DELETE FROM梭哈其中S＃IN（选S＃FROM SC）;

C. DELETE FROM梭哈WHERE斯诺IN（选S＃FROM SC）;

D. DELETE FROM梭哈WHERE斯诺IN（SELECT斯诺FROM SC）;

18. M：N的ER模型关系可以转移到一个关系其组成的主键

关系的关系m的B面的主键为N A面主键

关系本身，在其两侧C.属性关系D.主键

19. In conceptual-design phase, is the most common tools.

A. Relation model B. Network model C. ER model D. OO model

20. In database logical-design phase, must be given.

A. logical schema of database B. inner Schema of database

C. dataflow graph D. user Schema of database

21. Techniques for implementing integrity constraints are

A. declarative integrity constraints B. database triggers

C. data manipulation language D. Both A and B

在概念设计阶段，是最常用的工具。

A.关系模型B.网络模型C. ER模型D.面向对象模型

20.在数据库逻辑设计阶段，必须考虑。

数据库数据库B.内部架构的A.逻辑模式

数据库C.数据流图D.用户模式

21.技术实现完整性约束

A.声明完整性约束B.数据库触发器

C.数据操纵语言D. A和B

22. In database design, Normalization is used to avoid insert exception, delete exception and

A. data inconsistence B. data redundancy C. data lost D. improper schema

23. Relation among Normal Form is

A. 1NF 3NF BCNF B. 3NF 1NF BCNF

C. BCNF 3NF 1NF D. 1NF BCNF 3NF

24 Let R be a relation schema, and Attribute A,BR, AB means relationships between A and B are

A. many-to-1 B. 1-to-many C. many-to-many D. none of A, B and C

在数据库的设计，标准化是为了避免插入异常，删除异常，

A.数据不一致BY。数据冗余C.数据丢失D.不正当模式

范式之中23.关系

A.1NF 3NF BCNFB.3NF 1NF BCNF

C.BCNF 3NF 1NFD.1NF BCNF 3NF

24设R是一个关系模式，而属性A，B R，A B意味着A和B之间的关系是

A.多对1 B.1对多C.多到很多D.无A，B和C

25. In the following rules about functional dependency, is correct.

A. XY if X Y B. WXZ if XY and WYZ

C. XZ, YZ if XYZ D. XY if X Y =

26. is the first state in a life cycle of a transaction.

A. Committed B. Active C. Failed D. Aborted

27. Which of the following pairs of instructions conflict?

A. write(B), write(B) B. read(A), write(B)

C. write(A), read(B) D. read(A), read(A)

28. Which of the following pairs of locks are compatible?

A. Exclusive-lock(B), Shared-lock(B) B. Exclusive-lock(B), Exclusive -lock(B)

C. Shared-lock(A), Exclusive-lock(A) D. Shared-lock(A), Shared-lock(A)

在关于函数依赖以下的规则，是正确的。

如果X ÿB.X X如果X Y和WY ZA.X Y

C.X Z，如果Y ZXY ZD.X Y如果X Y =

26.在一个交易的生命周期的第一状态。

A.承诺B.主动C.失败D.中止

27.下列哪项指令对矛盾？

A.写（B），写（B）B.读取（A），写（B）

C.写（A），读（B）D.读（A），阅读（一）

28.下列哪项对锁的兼容？

A.独占锁（B），共享锁（B）B.独占锁（B），独家-lock（B）

C.共享锁（A），独占锁（A）D.共享锁（A），共享锁（A）

29. is a mythical form of storage that survives all failures.

A. volatile storage B. non-volatile storage C. stable storage D. non-stable storage

30.To authorize query privilege of table s to database user Wang, and permit Wang to authorize the privilege to others, The SQL sentence is

A. GRANT SELECT TO S ON WANG WITH PUBLIC OPTION

B. GRANT SELECT ON S TO WANG WITH PUBLIC OPTION

C. GRANT SELECT ON WANG TO S WITH GRANT OPTION

D. GRANT SELECT ON S TO WANG WITH GRANT OPTION

是存储的神话形式生存所有故障。

答性存储B.非易失性存储C.稳定存储D.非稳定存储

30.To授权表的查询权限的数据库用户王某，并允许王某授权权限给他人，该SQL语句是

A. GRANT选择以S上王与公共选择

B. GRANT SELECT在S王小姐公共选择

C. GRANT SELECT ON王送WITH GRANT OPTION

D. GRANT SELECT ON s到WITH GRANT OPTION王

1. is the only one incorrect description from the followings:

A. R=(R-S)∪(R∩S) B. R-S=R-(R∩S)

C. R∩S=S-(R-S) D. R∩S=S-(S-R)

2. Choose the only one correct expression from the followings: _ ______.

A. ( some) in B. (= all) not in C. exists r r Ø D. X-Y Ø X Y

3. C of the following four expressions of relational algebra is not equivalent to the other three? They are all based on the relations R(A,B) and S(B,C).

A. B. C. D.

1------是从以下的只有一个不正确的说明：

答：R =（R-S）∪（R∩S）B. R-S= R-（R∩S）

C.R∩S= S-（R-S）。D.R∩S= S-（S-R）

2.从以下选择只有一个正确的表达：________。

答：（ 部分） B中（=全部） 不是C.存在ř - [R ØD. XY Ø X ÿ

关系代数以下四个表达式3.不等同于其他三个？它们都是基于关系R（A，B）和S（B，C）。

A B C D。

4. In the following, assume a is an attribute of some character-string type, e.g. CHAR(10), and that it may be NULL.

Q1: SELECT * FROM R WHERE a IS NULL;

Q2: SELECT * FROM R WHERE a NOT LIKE '%';

A.Q1 and Q2 produce the same answer.

B. The answer to Q1 is always contained in the answer to Q2.

C. The answer to Q2 is always contained in the answer to Q1.

D. Q1 and Q2 produce different answers.

5. The Entity-Relationship data model is

A. DBMS dependent B. DBMS independent C. both A and B D. neither A nor B

4在以下，假设一个是一些字符串类型，例如一个属性CHAR（10），并且它可以为NULL。

Q1：SELECT * FROM R，其中a为null;

Q2：SELECT * FROM R其中一个NOT LIKE'％';

A.Q1和Q2产生相同的答案。

B.答案到Q1总是包含在应答到Q2。

C.答案到Q2总是包含在应答到Q1。

D. Q1和Q2产生不同的答案。

5.实体关系数据模型

A. DBMS依赖B. DBMS独立C. A和B D. A和B都

6. In SQL, an UPDATE statement without a WHERE clause:

A. Updates every row in a table. B. Updates no rows in a table.

C. Updates every column in a table. D. Results in a Cartesian product.

7. If a course can be taught by many teachers, and a teacher can teach only one course, then the mapping cardinality from course to teacher is

A. one-to-one B. one-to-many C. many-to-one D. many-to-many

8. If there is a many-to-one relationship between entity A and B, then

A. there exists a functional dependency from the primary key in B to the primary key in A, i.e., PK(B) → PK(A).

B. there exists a functional dependency from the primary key in A to the primary key in B, i.e., PK(A) → PK(B).

C. both A and B. D. neither A nor B

6在SQL中，没有一个WHERE子句的UPDATE语句：

A.更新表中的每一行。 B.在一个表中更新任何行。

C.更新每列在表中。 D.导致笛卡尔乘积。

7.如果一门课程可以由许多老师授课，和老师可以教只有一门课程，则映射基数从课程的老师

A.一到1 B.一到多C.许多对一D.多对许多

8.如果存在实体A和B，然后之间的多对1的关系

A.存在从B中的主键的主键在A，即函数依赖，PK（B）→PK（A）。

B.存在从A中的主键B中的主键，即PK（A）→PK（B）函数依赖。

C. A和B. D. A和B都

9. If a functional dependency AB→R holds on relation R(A, B, C), then (A, B) is definitely a ______ of R.

A. super key B. primary key C. candidate key D. foreign key

10. A relational schema R is in _____ if the domains of all attributes of R are atomic

A. 1NF B. 3NF C. BCNF D. 4NF

11. Which one of the following statement is true?

A. 3NF is more strict than BCNF B. 4NF is more strict than BCNF

C. 1NF is more strict than BCNF D. BCNF is the most strict normal form

9如果一个函数依赖AB→ř持有关系R（A，B，C），然后（A，B）绝对是R的______

A.超键B.主键C.候选键D.外键

10.一个关系模式R是_____若R的所有属性的领域是原子

A.1NF B.3NF C. BCNF D.4NF

11.下列哪项说法是正确的？

A.3NF更严格的比BCNF B.4NF比BCNF更严格

C.1NF比BCNF D. BCNF更严格的是最严格的标准型

12. If a transaction Ti has obtain an exclusive lock on data item Q, then transition Tj can ______.

A. obtain an exclusive lock on data item Q B. obtain a shared lock on data item Q

C. wait for lock granting on data item Q D. read or write Q without a lock

13. If both i start> and i commit> appear in the log after the nearest checkpoint to system crash, then transaction Ti must be ______

A. undone B. redone C. deleted D. Neither A or B

14. ______ is the final state in a life cycle of a transaction.

A. committed B. aborted C. failed D. A or B

15. in 2PL protocol, at stage, A transaction may obtain locks, but may not release locks.

A. Shrinking phase B. Growing phase C. Committed D. Aborted

12如果事务Ti具有获得数据项Q上的排它锁，然后过渡TJ可以______。

A.获得数据项Q B.排它锁获得数据项Q A共享锁

C.等待锁授予对数据项Q D.读取或写入Q没有锁

13.如果两个<钛启动>和<钛提交>出现在最近的检查点，以系统崩溃后的日志中，那么交易的Ti必须______

A.撤消B.重做C.删除D.无论是A或B

14.______是在一个事务的生命周期中的最终状态。

A.承诺B.中止C.失败D. A或B

15.在2PL协议，在现阶段，一个事务可以进行锁定，但可能不会释放锁。

A.萎缩阶段B.成长阶段C.承诺D.中止

本文来源：https://www.2haoxitong.net/k/doc/766bf5a79b6648d7c0c7467a.html