DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Roll back
|
|
|
Save point
|
|
|
Committ
|
|
|
Both A and B
|
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: -Use the mysql command to restore a database from the command line. In MySQL, you can use the mysql command to restore the database from a dump file. mysqldump is a command-line utility used to generate a MySQL logical database backup as a single . sql file with a set of SQL statements.
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: -The ROLLBACK command is the transactional command used to undo transactions that have not already been saved to the database.