MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

DATABASE MANAGEMENT SYSTEM

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
A
Roll back
B
Save point
C
Committ
D
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: This command restores the database to last committed state. It is also used with savepoint command to jump to a savepoint in a transaction.

Detailed explanation-3: -To restore to an existing database, one of the following authorities: SYSADM. SYSCTRL. SYSMAINT.

Detailed explanation-4: -ROLLBACK command This command restores the database to last commited state. It is also used with SAVEPOINT command to jump to a savepoint in an ongoing transaction.

Detailed explanation-5: -ROLLBACK is the SQL command that is used for reverting changes performed by a transaction.

There is 1 question to complete.
Previous
Next