Question

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. e.) ARID transactions.

Answer 1

The correct term for ensuring that all rows impacted by the actions of a transaction are protected from changes until the entire transaction is completed is:

c.) transaction level consistency.

This concept ensures that the changes made by a transaction are isolated from other transactions until it's either committed or rolled back to maintain the consistency and integrity of the database