Examveda
Examveda

What is generally done after the transactions are executed successfully?

A. delete

B. rollback

C. commit

D. update

Answer: Option C

Solution(By Examveda Team)

In the world of databases, a transaction is a group of database operations that are treated as a single unit. Think of it like a series of steps you need to take to complete a task.

Imagine you're transferring money between bank accounts. You need to withdraw money from one account and deposit it into another. These two actions make up a single transaction.

Now, let's say everything goes smoothly during the transaction. The money is successfully withdrawn and deposited. To confirm that the transaction has been completed successfully, we need to commit it. This means making the changes permanent in the database.

So, the correct answer is Option C: commit.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous