Transaction Processing Flashcards

1
Q

What is transaction processing?

A

Any information processing which is divided into individual, indivisible operations. Each operation must succeed or fail as a complete unit.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is the A part of ACID?

A

Atomicity

A change to a database is either completely performed or not at all. A half-completed change must not be saved back to the database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the C part of ACID?

A

Consistency

Any change in the database must retain the overall state of the database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is the I part of ACID?

A

Isolation

A transaction must not be able to be interrupted by another transaction. The transaction must occur in isolation so that other users or processes cannot have access to the data concerned.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is the D part of ACID?

A

Durability

Once a change has been made to a database it must not be lost due to a system failure.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly