Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question
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
show 3 more comments

1 Answer 1

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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