Which of the following properties ensures that once a transaction commits, its results are permanent?Question 12Select one:A.FlexibilityB.DurabilityC.IsolationD.AtomicityE.Consistency
Question
Which of the following properties ensures that once a transaction commits, its results are permanent?Question 12Select one:A.FlexibilityB.DurabilityC.IsolationD.AtomicityE.Consistency
Solution
The property that ensures that once a transaction commits, its results are permanent is B. Durability.
Here's why:
A. Flexibility is not a property related to database transactions.
B. Durability is the property that ensures once a transaction has been committed, it will remain so, even in the event of power loss, crashes, or errors.
C. Isolation is the property that ensures that the concurrent execution of transactions results in a system state that would be obtained if transactions were executed serially.
D. Atomicity is the property of a transaction that ensures it is treated as a single, indivisible logical unit of work, where either all of its data modifications are performed or none of them are.
E. Consistency is the property that ensures that a transaction brings the database from one valid state to another.
Similar Questions
Discuss Consistency and Isolation property of a transaction
Which of the following is not a property of a transaction in a DBMS?Select one:a. Isolationb. Atomicityc. Consistencyd. Uniqueness
Which ACID property specifies that once the transaction is committed, its permanent even in case of power failures?Answer choicesSelect an optionAtomicityDurabilityIsolationConsistency
Which ACID property ensures that once a transaction is committed, its effects are permanent and survive subsequent system failures?AtomicityConsistencyIsolationDurability
Atomicity. A transaction is an atomic unit of processing; it should either beperformed in its entirety or not performed at all.■ Consistency preservation. A transaction should be consistency preserving,meaning that if it is completely executed from beginning to end withoutinterference from other transactions, it should take the database from oneconsistent state to another.■ Isolation. A transaction should appear as though it is being executed in iso-lation from other transactions, even though many transactions are executing7Undo and redo are discussed more fully in Chapter 23.21.4 Characterizing Schedules Based on Recoverability 755concurrently. That is, the execution of a transaction should not be interferedwith by any other transactions executing concurrently.■ Durability or permanency. The changes applied to the database by a com-mitted transaction must persist in the database. These changes must not belost because of any failure.
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.