ISRO2017-6

Question

ACID properties of a transactions are

• A. Atomicity, consistency, isolation, database
• B. Atomicity, consistency, isolation, durability
• C. Atomicity, consistency, integrity, durability
• D. Atomicity, consistency, integrity, database

Answer 1

Definitely its B...

ACID properties:

A - Atomicity

C- consistency

I - Isolation

D -Durability

Answer 2

To maintain integrity of the database , the transactions follow ACID properties:

A - Atomicity, the Recovery management component of DBMS software is responsible for atomicity.

C - Consistency, the Database Administrator or Database Creator takes care of consistency.

I - Isolation, taken care by the concurrency control component of DBMS software.

D - Durability, again the Recovery management component of DBMS software responsible for this.

So, the correct answer is B

Answer 3

ACID stands for Atomicity, Consistency, Isolation and Durability.

Atomicity

It means that either the record/document updates completely or does not update with respect to the operation.

Either everything occurs or nothing occurs.

Consistency

It implies that a transaction either creates a new and valid state of data, or, if any failure occurs, returns all data to its state before the transaction was started.

If successful then valid data else revert back to original data.

Isolation

Two or more simultaneous database queries should run independent of the other transactions.

Durability

Data once committed should be saved in memory so that even in case of system failure, data is not affected.