Transaction Atomicity - DBMS Questions and Answers

1.

DBMS periodically suspends all processing and synchronizes its files and journals through the use of

   A.) Checkpoint facility
   B.) Backup facility
   C.) Recovery manager
   D.) Database change log

Answer: Option 'A'

​Checkpoint facility

2.

_______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

   A.) Time stamping
   B.) Isolation
   C.) Serializability
   D.) Atomicity

Answer: Option 'B'

Isolation means that data used during the execution of a transaction can’t be used by a second transaction until the first one is completed.

3.

If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called

   A.) Consistent state
   B.) Parallel state
   C.) Inconsistent state
   D.) Atomic state

Answer: Option 'C'

If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called in a consistent state.

4.

Each modification done in database transaction are first recorded into the

   A.) Harddrive
   B.) Disk
   C.) Log
   D.) Datamart

Answer: Option 'C'

After commit is issued the data are stored in a database and stored in drive.

5.

If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by

   A.) Flashback
   B.) Rollback
   C.) Both Flashback and Rollback
   D.) Cannot be done

Answer: Option 'D'

Cannot be done

Transaction Atomicity - DBMS Questions and Answers Download Pdf