In case of any shut down during transaction before commit which of the following statement is done automatically?FlashbackViewRollbackCommit

In the event of a shutdown during a transaction before it is committed, the statement that is done automatically is Rollback.

Explanation

When a transaction is initiated in a database, it can either be committed to save changes or rolled back to revert any changes made during the transaction if something goes wrong (like a system shutdown).

• Flashback is a feature in some database systems that allows you to view past data states but does not automatically execute in case of a shutdown.
• View typically refers to a database object that presents data in a particular format and does not pertain to transaction control in the context of shutdowns.
• Commit would finalize the transaction, which cannot occur if the system shuts down unexpectedly.

Therefore, rollback is the correct answer as it ensures data integrity by reverting any uncommitted changes in the event of an interruption.