SQL Transaction
1.What is a transaction Simply it groups of database quires. A database transaction symbolizes a unit of work performed(Operations:Read Write) within a database management system (or similar system) against a database, and treated in a coherent and reliable way independent of other transactions. 2.why do we need transaction Group of read write operation;which independent from other operations. Do not execute part of transaction.If execute all or none. Eg:-Credit debit operation in ATM management system. 3.Serial Schedule Transaction Vs Serializable Schedule transaction *A complete schedule* is a schedule that contains either an abort or a commit for each transaction in the set. *A serial schedule* is a schedule that the actions of different transactions are not interleaved, that is transactions are executed from start to finish, one by one. *A serializable schedule* over a set S of committed transactions is a schedule whose effect on any consistent database instance is guaranteed to