The ACID properties are insured by the following services of the DBMS:
A) Concurrency transparency
B) Recovery transparency
C) Data dictionary
D) Concurrency transparency and Recovery transparency

Question

Quizplus · Accepted Answer

Concurrency transparency ensures that multiple users accessing the database simultaneously do not interfere with each other, while recovery transparency ensures that any data lost due to system failure can be recovered without compromising the consistency of the database. Therefore, both concurrency transparency and recovery transparency are necessary for ensuring the ACID properties in a DBMS. The data dictionary, while important for managing metadata, does not directly contribute to ensuring the ACID properties.

The ACID Properties Are Insured by the Following Services of the DBMS