Machine-translated by Google. Questions are authored in English.
Top

Discussion

Which of the following commands is used to save any transaction permanently into the database ?

  • A.Redo
  • B.Commit
  • C.Rollback
  • D.Undo

Answer: B

The command is Commit.

COMMIT ends a transaction and makes all its changes permanent in the database; after it, the changes survive failures and are visible to other transactions.

ROLLBACK does the opposite, undoing the changes of the current transaction. Redo and undo are recovery operations the DBMS performs from its log, not commands for saving a transaction.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.