Question

which of the following is invalid transaction.
1. Save transaction
2. Commit transaction
3. Rollback transaction
4. None of above

Answer 1

Explanation:

none of above ........

Answer 2

Answer:

Correct option is:

4. None of above

None of above is invalid transaction.

Explanation:

A SAVEPOINT is a point in a transaction where you can revert to a previous state without reverting the entire transaction.

The SQL command COMMIT is used in transaction tables or databases to commit the current transaction or database statement. It indicates that a transaction was completed successfully. We want to make the changes permanent once we've successfully executed the transaction statement or a simple database query. To save the changes, we must use the commit command, which makes them permanent for all users. Furthermore, once the commit command has been executed in the database, we will be unable to restore the database to its previous state prior to the execution of the first statement.