DATA BASE BACKUP AND RECOVERY

Question 1

a mechanism that determines whether a user is who he or she claims to be

Answer 1

AUTHENTICATION

Question 2

the granting of a right or privilege, which enables a subject to legitimately have access to a system or a legitimately have access to a system or a system’s objects.

Answer 2

AUTHORIZATION

Question 3

a security mechanism (of a DBMS) for restricting access to a system’s objects (the database) as a whole

Answer 3

ACCESS CONTROL

Question 4

Is the process of periodically taking a copy of the database and log file (and possibly programs) onto offline storage media.

Answer 4

DATABASE BACKUP

Question 5

Mechanisms for restoring a database quickly and accurately after loss or damage.

Answer 5

DATABASE RECOVERY

Question 6

Recovery in general refers to the various operations involved in restoring, rolling forward, and rolling back a backup.

Answer 6

DATABASE RECOVERY

Question 7

Provide back-up copies of portions of or entire database.

Answer 7

BACKUP FACILITIES

Question 8

BACKUP MODES

Answer 8

COLD BACK-UP
HOT BACK-UP

Question 9

Full Back-ups of a database.

Answer 9

COLD BACK-UP

Question 10

Only a selected portion of the database is shut down from use.

Answer 10

HOT BACK-UP

Question 11

Maintain an audit trail of transactions and database changes.

Answer 11

JOURNALIZING FACILITIES

Question 12

By which DBMS periodically suspends all processing and synchronizes its files and journals to establish recovery point.

Answer 12

CHECKPOINT FACILITY

Question 13

Basic Facilities for Database Backup and Recovery

Answer 13

BACKUP FACILITIES
JOURNALIZING FACILITIES
CHECKPOINT FACILITY

Question 14

RECOVERY AND RESTART PROCEDURES

Answer 14

DISK MIRRORING
RESTORE/RERUN
MAINTAINING TRANSACTION INTEGRITY

Question 15

At least two copies of the database must be kept and updated simultaneously. When a media failure occurs, processing is switched to the duplicate copy of the database.

Answer 15

DISK MIRRORING

Question 16

A technique that involves re-processing the day’s transaction (up to the point of failure) against the backup copy of the database.

Answer 16

RESTORE/RERUN

Question 17

Commit or abort all transaction changes.
A transaction is the DBMS’s abstract view of user programs.

Answer 17

MAINTAINING TRANSACTION INTEGRITY

Question 18

_____________ is the general process of assuring that transactions preserve consistency when executing simultaneously

Answer 18

CONCURRENCY CONTROL

Question 19

The back out, or undo, of unwanted changes to the database.

Answer 19

BACKWARD RECOVERY/ROLLBACK

Question 20

An atomic transaction is one in which all of the database changes are committed as a unit; either all are done or none is.

Answer 20

ATOMICITY

Question 21

A consistent transaction is one in which all actions are taken against rows in the same logical state.

Answer 21

ATOMICITY

Question 22

This property means that once the transaction is executed, it must either put the database in a consistent state or abort.

Answer 22

CONSISTENCY

Question 23

If the final state of transaction is not stable, it must bring back the system in to its initial state.

Answer 23

CONSISTENCY

Question 24

PROPERTIES OF TRANSACTION

Answer 24

ATOMICITY
CONSISTENCY
ISOLATION
DURABILITY

Question 25

Means that the behavior of a transaction is not affected by other concurrent transactions executing.

Answer 25

ISOLATION

Question 26

An isolated transaction is one that is protected from changes by other users. In a highly concurrent environment, highly isolated transactions may lead to deadlocks.

Answer 26

ISOLATION

Question 27

This property means that the effects of transaction will persist after its validation. A durable transaction is one in which all committed changes are permanent.

Answer 27

DURABILITY