Ensuring that all rows impacted by the actions of a transaction are protected from changes until the entire transaction is completed is called ________.
A)statement level consistency
B)optimistic locking
C)transaction level consistency
D)durable transactions

Question

Quizplus · Accepted Answer

Transaction level consistency ensures that all changes made by a transaction are isolated from other transactions until the entire transaction is completed. This ensures that all rows impacted by the actions of the transaction are protected from changes until the transaction is committed or rolled back, ensuring data integrity. Statement level consistency protects only individual statements within a transaction, while optimistic locking is a technique used to prevent conflicts between multiple transactions attempting to access the same data simultaneously. Durable transactions ensure that once a transaction is committed, its changes are permanent and persist even in the case of system failure.

Ensuring That All Rows Impacted by the Actions of a Transaction