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.atomicity B.consistency C.isolation D.durability正确答案B
