Ask
Login
2
55kviews
Define transaction? Explain transaction state diagram and properties of transaction
written 5.8 years ago by gravatar for meghalikalyankar meghalikalyankar • 2.2k modified 2.5 years ago by gravatar for pedsangini276 pedsangini276 • 4.8k
advanced database management systems
ADD COMMENT EDIT
1 Answer
6
2.2kviews
written 5.8 years ago by gravatar for meghalikalyankar meghalikalyankar • 2.2k •   modified 5.7 years ago

• A transaction is the sequence of one or more SQL statements that are combined together to form a single unit of work.

Transaction State Diagram:

enter image description here

Transaction must be in one of these states:

1.Active:

• It is the initial state if a transaction.

• Execution of transaction starts in …

Create a free account to keep reading this post.

and 5 others joined a min ago.

ADD COMMENT EDIT
Please log in to add an answer.