0

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

  • 3
    What does your teacher say? – gbn Jan 27 '12 at 18:26
  • 1
    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
  • @a1ex07 I think you should make your comment an answer. – Leigh Riffel Jan 27 '12 at 20:20
  • @Raihan - that's not how atomicity works. – JNK Jan 27 '12 at 21:22
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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.