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.

（1）A． application developer

B. all users

C. application program

D. DBMS

（2）A．Indivisible

B.permanent

C.infrequent

D.infinite

（3）A．completed

B.incomplete

C.aborted

D.committed

（4）A．a(chǎn)tomicity

B.consistency

C.isolation

D.durability

（5）A．DBMS

B.DBA

C.end user

D.DBS

點(diǎn)擊注冊(cè)會(huì)員>>>即可獲取數(shù)據(jù)庫(kù)系統(tǒng)工程師免費(fèi)在線真題、觀看免費(fèi)公開(kāi)課！

軟考報(bào)名：2018下半年軟考各地區(qū)報(bào)名時(shí)間匯總

真題自測(cè)：軟考各科目歷年真題及答案解析

更多資訊可關(guān)注希賽網(wǎng)軟考頻道，問(wèn)題咨詢請(qǐng)撥打客服電話400-111-9811。