In order to undo the work of transaction after last commit which one should be used?Select one:a. Flashbackb. Viewc. Rollbackd. Commit
Question
In order to undo the work of transaction after last commit which one should be used?Select one:a. Flashbackb. Viewc. Rollbackd. Commit
Solution
The correct answer is c. Rollback.
Here's why:
a. Flashback: This is a feature in Oracle that allows you to view past states of database objects, or to return database objects to a previous state, but it doesn't undo the work of a transaction.
b. View: This is a virtual table based on the result-set of an SQL statement. It doesn't have the ability to undo the work of a transaction.
c. Rollback: This is the correct answer. A ROLLBACK command in SQL is used to undo transactions that have not already been saved to the database.
d. Commit: This command is used to save all transactions to the database. Once a transaction is committed, it cannot be rolled back.
Similar Questions
Which of the following makes the transaction permanent in the database? Rollback View Commit Flashback
In case of any shut down during transaction before commit which of the following statement is done automatically?FlashbackViewRollbackCommit
Select the correct answerDuring transaction before commit which of the following statements is done automatically in case of shutdown?OptionsCommitRollbackViewFlashback
How do you undo the last commit in Git while keeping the changes in the working directory?
Consider the following action:TRANSACTION.....Commit;ROLLBACK;What does Rollback do?Redoes the transactions before commitClears all transactionsUndoes the transactions before commitNo action
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.