Atransactionisanaction,oraseriesofactions,carriedoutbyasingleuse

分类: (中级) 数据库系统工程师 发布时间: 2023-11-03 05:18 浏览量: 0

Atransactionisanaction,oraseriesofactions,carriedoutbyasingleuseror(请作答此空),thataccessesorchangesthecontentsofthedatabase.Atransactionshouldpossessthefourbasicorso-calledACIDproperties:Atomicity.The“allornothing”property.Atransactionisan()unitthatiseitherperformedinitsentiretyorisnotperformedatall.Consistency.Atransactionmusttransformthedatabasefromoneconsistentstatetoanotherconsistentstate.Isolation.Transactionsexecuteindependentlyofoneanother.Inotherwords,thepartialeffectsof()transactionsshouldnotbevisibletoothertransactions.Durability.Theeffectsofasuccessfullycompleted(committed)transactionarepermanentlyrecordedinthedatabaseandmustnotbelostbecauseofasubsequentfailure.Thefourpropertiesabove,only()propertyistheresponsibilityoftheconcurrencycontrolsubsystemtoensure.Itistheresponsibilityofboththe()andtheapplicationdeveloperstoensureconsistency.ToguaranteetheAtomicityandDurabilitypropertiesafterafailure,alogfileisneeded.

A.application developer

B.all users

C.application program

D.DBMS

正确答案是C