A transaction is an action, or a series

练习题库2022-08-02 71

问题 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.A.IndivisibleB.permanentC.infrequentD.infinite

选项

答案 A

解析

转载请注明原文地址:https://tihaiku.com/congyezige/2418652.html

本试题收录于：中级数据库系统工程师题库软件水平考试初中高级分类

中级数据库系统工程师

软件水平考试初中高级

相关试题推荐

随机试题

最新回复(0)

A transaction is an action, or a series

中级数据库系统工程师

软件水平考试初中高级

______occurswhenaseriesofsynchroni

______occurswhenaseriesofsynchroniz

用于提交和回滚事务的语句为()。A.ENDTRANSACTION和ROLL