Describe Characteristics and Performance Considerations of a Relational Database DATA-ENGINEERING-OPTIMIZE Practice Questions (Page 2)

Questions 6–6

1. 6foundation · medium

   A database administrator is explaining the ACID properties to a junior developer. Which statement correctly describes the role of the Isolation property?

   • AIsolation ensures that once a transaction is committed, its changes are permanently stored and survive system failures.
   • BIsolation ensures that each transaction is executed as if it were the only transaction in the system, preventing concurrent transactions from interfering with each other.
   • CIsolation ensures that a transaction either completes entirely or not at all, so partial updates are rolled back on failure.
   • DIsolation ensures that a transaction brings the database from one valid state to another, preserving all defined rules and constraints.
   Reveal Solution Discussion Select an answer first