reopened by
4,713 views
11 votes
11 votes

ACID properties of a transactions are

  1. Atomicity, consistency, isolation, database
  2. Atomicity, consistency, isolation, durability
  3. Atomicity, consistency, integrity, durability
  4. Atomicity, consistency, integrity, database
reopened by

3 Answers

Best answer
11 votes
11 votes
Definitely its B...

ACID properties:

A - Atomicity

C- consistency

I - Isolation

D -Durability
selected by
3 votes
3 votes
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
0 votes
0 votes

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.

Answer:

Related questions

5 votes
5 votes
3 answers
1
sh!va asked May 7, 2017
5,031 views
Which of the following concurrency control protocol ensures both conflict and free from deadlock? ,Time stamp ordering2 Phase lockingBoth (a) and (b)None of the above
7 votes
7 votes
2 answers
2
sh!va asked May 7, 2017
4,543 views
Which of these is characteristic of $\textsf{RAID 5}?$Dedicated parityDouble parityHamming code parityDistributed parity
6 votes
6 votes
3 answers
3
sh!va asked May 7, 2017
9,135 views
Which symbol denote derived attributes in ER Model?Double ellipseDashed ellipseSquared ellipseEllipse with attribute name underlined
9 votes
9 votes
2 answers
4
sh!va asked May 7, 2017
6,217 views
$\begin{array}{|l|l|l|l|l|} \hline \textbf{Employee} & \textbf{Department} & \textbf{OT_allowance} \\ \hline \text{RAMA} & \text{Mechanical} & \text{5000} \\\hline \text{...