1.

What is the structure of a Transaction?

Answer»

The general structure of an exchange explanation comprises of starting with START TRANSACTION. The subsequent STAGE is embeddings at least one or more commands/operations, inserting statements that check for mistakes, inserting ROLLBACK statements to deal with any error found, at last, inserting a COMMIT statement to implement modification on a successful operation.

17. Explain ACID in Transaction.
  • Atomicity − It interrupts the failures and ROLLS back the modification because It is responsible accomplish all operations.
  • Consistency − It is responsible for changes implement by the database on a successful transaction.
  • Isolation − It PREPARES the transaction operations to perform individually in a transaction.
  • Durability − It is responsible for the persistence of a successful transaction in CASE an event of system failure occurs.


Discussion

No Comment Found

Related InterviewSolutions