Ask
Login
0
10kviews
Define transaction? Explain transaction state diagram and properties of transaction
written 9.0 years ago by gravatar for meghalikalyankar meghalikalyankar • 2.3k modified 4.0 years ago by gravatar for binitamayekar binitamayekar ★ 6.7k
database management systems
ADD COMMENT EDIT
1 Answer
1
38views
written 9.0 years ago by gravatar for meghalikalyankar meghalikalyankar • 2.3k
  • 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:
  2. It is the initial state if a transaction.
  3. Execution of transaction starts in an active state. …

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.