2018上半年数据库系统工程师上午真题(八)

数据库系统工程师 责任编辑:胡媛 2018-06-01

添加老师微信

备考咨询

加我微信

摘要:2018上半年数据库系统工程师考试已经结束,希赛小编为大家整理了2018上半年数据库系统工程师上午真题,以下为第八部分。

● A transaction is an action, or a series of actions, carried out by a single user or (   ), that accesses or changes the contents of the database.

A transaction should possess the four basic or so-called ACID properties:

Atomicity. The “all or nothing” property. A transaction is an (  ) unit that is either performed in its entirety or is not performed at all.

Consistency. A transaction must transform the database from one consistent state to another consistent state.

Isolation. Transactions execute independently of one another. In other words, the partial effects of (  ) transactions should not be visible to other transactions.

Durability. The effects of a successfully completed (committed)transaction are permanently recorded in the database and must not be lost because of a subsequent failure.

The four properties above, only (   ) property is the responsibility of the concurrency control subsystem to ensure. It is the responsibility of both the(   )and the application developers to ensure consistency. To guarantee the Atomicity and Durability properties after a failure, a log file is needed.

(71)A. application developer

B. all users

C. application program

D. DBMS

(72)A.Indivisible

B.permanent

C.infrequent

D.infinite

(73)A.completed

B.incomplete

C.aborted

D.committed

(74)A.atomicity

B.consistency

C.isolation

D.durability

(75)A.DBMS

B.DBA

C.end user

D.DBS


>>>>>>2018上半年数据库系统工程师上午真题汇总

>>>>>>查看更多数据库系统工程师历年真题

更多资料
更多课程
更多真题
温馨提示:因考试政策、内容不断变化与调整,本网站提供的以上信息仅供参考,如有异议,请考生以权威部门公布的内容为准!

软考备考资料免费领取

去领取

!
咨询在线老师!