Q. What is the durability property of transactions?

  • (A) statements form a logic unit
  • (B) database remains consistent
  • (C) one transaction does not affect the other
  • (D) transaction effects are recorded permanently
💬 Discuss
✅ Correct Answer: (D) transaction effects are recorded permanently
Explanation: The durability property of transactions in MySQL refers to the guarantee that once a transaction is committed, its effects are recorded permanently and will not be lost, even in the event of a system failure. This means that the changes made by committed transactions will persist even after the system restarts or crashes. Therefore, Option D is the correct answer.

Published by Vikash Gupta ⭐ 33.56K Points at 22-Mar-2025 12:41 pm in MySQL

Explanation by: Vikash Gupta
The durability property of transactions in MySQL refers to the guarantee that once a transaction is committed, its effects are recorded permanently and will not be lost, even in the event of a system failure. This means that the changes made by committed transactions will persist even after the system restarts or crashes. Therefore, Option D is the correct answer.

💬 Discussion

📊 Question Analytics

👁️
99
Total Visits
📽️
1 y ago
Published
🎖️
Vikash Gupta
Publisher
📈
99%
Success Rate