MySQL › Transactions and ACID properties - MySQL › Question #15525
MCQ Single Best Answer Easy

QWhich ACID property ensures that once a transaction is committed, its changes are protected and will persist even in the event of power outages or system crashes?

ID: #15525 Transactions and ACID properties - MySQL 125 views
Question Info
#15525Q ID
EasyDifficulty
Transactions and ACID properties - MySQLTopic
Start Quiz on This Topic
 Your Answer

Choose the Best Option

Click any option to instantly check if you're correct.

  • A Atomicity ✔ ✖
  • B Consistency ✔ ✖
  • C Isolation ✔ ✖
  • D Durability ✔ ✖
Correct Answer: Option D

Explanation

Durability is the ACID property that ensures that once a transaction is committed, its changes are protected and will persist even in the event of power outages or system crashes. It guarantees the reliability and recoverability of committed data.

 Continue Practice
Previous Question Next Question
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

Which ACID property ensures that concurrent execution of transactions does not result in data inconsistency? Which of the following statements is true about transactions in MySQL? Which ACID property ensures that concurrent execution of transactions does not result in data anomalies such a Which ACID property ensures that a transaction brings the database from one consistent state to another, witho What does ACID stand for in the context of database transactions? Which ACID property ensures that a transaction's execution does not violate the defined rules and constraints Which ACID property ensures that a transaction can be divided into smaller, independent units of work? Which ACID property ensures that a transaction's changes are isolated and not visible to other transactions un Which ACID property ensures that a transaction is treated as a single, indivisible unit of work? Which ACID property guarantees that even in the presence of system failures, a committed transaction's effects