Transaction question

Question

I have a question.

c stands for Commit, a stands for Abort, T is a transaction (db Transaction)

Is the following sentence true?

either c or a belong to T

In my opinion the sentence is true since if you have Abort you cannot Commit...and also the opposite is true.

So if you have c you cannot have a, a mutual exclusion.

Sorry to bother you but my teacher said I made a mistake

Thanks

I think 'belong' is a wrong word here. It usually says that transaction ends with commit or rollback. Group of DML statements belong to transaction; commit/rollback is a way to finish transaction. — a1ex07, Jan 27 '12 at 19:02
What about the case when you abort part of the transaction and commit the rest? — Raihan, Jan 27 '12 at 19:11
@JNK there is such thing as defining save points along a transaction and rolling back to one of them before commiting the transaction. — Raihan, Jan 27 '12 at 22:17
@Raihan - that's really just committing a smaller transaction. — JNK, Jan 27 '12 at 22:36

score 2 · Answer 1 · answered Jan 27 '12 at 22:35

2

Moved from comment to answer

I think 'belong' is a wrong word here. It usually says that transaction ends with commit or rollback. Group of DML statements belong to transaction; commit/rollback is a way to finish transaction...emphasized text

answered Jan 27 '12 at 22:35

a1ex07

9,000
3
24
40

Transaction question

1 Answers1