DATABASE BACKUP AND RECOVERY(2)

Question 1

____________ is a group of statements that are performed as an atomic group. It means either all the statements run successfully, or none of the do.

Answer 1

TRANSACTION

Question 2

A transaction in progress that terminates abnormally.

Answer 2

ABORTED TRANSACTION

Question 3

Human Error, Input of invalid data, hardware failure and deadlock

Answer 3

ABORTED TRANSACTION

Question 4

Recovery Technique: Rollback

Answer 4

ABORTED TRANSACTION
INCORRECT DATA

Question 5

If the error is discovered soon enough, backward recovery may be used.

Answer 5

INCORRECT DATA

Question 6

If only a few errors have occurred, a series of compensating transaction may be introduced through human intervention to correct the errors.

Answer 6

INCORRECT DATA

Question 7

If the first two measures are not feasible, it may be necessary to restart from the most recent checkpoint before the error occurred, and subsequent transactions processed without error.

Answer 7

INCORRECT DATA

Question 8

DATABAE FAILURES

Answer 8

ABORTED TRANSACTION
INCORRECT DATA

Question 9

To check for autocommit status in InnoDB, we will use the following query:

Answer 9

SELECT @@autocommit;

Question 10

To demonstrate how to lock tables, first we will be setting autocommit = 0.

Answer 10

SET @@autocommit = 0;

Question 11

To test Rollback:

Answer 11

ROLLBACK;

Question 12

To manually start a transaction, we will be using Begin, or start transaction:

Answer 12

START TRANSACTION;

Question 13

After a Transaction, if the transaction will be not having further changes, use commit.

Answer 13

COMMIT;