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
Answer: Option D
Solution(By Examveda Team)
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.Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion