Which property ensures that intermediate transaction results are hidden from other concurrently executed transactions?AtomicityConsistencyIsolationDurabilityNext

Which property ensures that intermediate transaction results are hidden from other concurrently executed transactions?

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.

Which ACID property ensures that once a transaction is committed, its effects are permanent and survive subsequent system failures?AtomicityConsistencyIsolationDurability

Discuss Consistency and Isolation property of a transaction

Select one:a.The data item X cannot be accessed by any other transaction T2 until the transaction T1 is completed and the data item X is used by the transaction T1.b.By using the data used during a transaction, the second transaction will not be able to use it until the first has been executed.c. All of the aboved.It enforced the isolation property via its concurrency control subsystem.