COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which one of the following commands is used to restore the database to the last committed state
|
Roll back
|
|
Save point
|
|
Committ
|
|
Both A and B
|
Explanation:
Detailed explanation-1: -To restore the database to the last committed state ( or to undo the latest changes), the “rollback” command is used that belongs to the Transaction Control Language.
Detailed explanation-2: -ROLLBACK is the SQL command that is used for reverting changes performed by a transaction. When a ROLLBACK command is issued it reverts all the changes since last COMMIT or ROLLBACK.
Detailed explanation-3: -Answer: ctrl+Z is used to restore deleted files and folder from the recycle bin.
Detailed explanation-4: -Explanation: Commit command is used to permanently save any transaction into the database.
There is 1 question to complete.