Recovery and Atomicity Multiple Choice Questions (MCQ) PDF Download

MCQ 1: The unique identifier field in the update log record in which the data item is written is called

1. Transaction identifier
2. New value identifier
3. Data-item identifier
4. Data-value identifier

MCQ 2: The Log record type that describes a single database write is known as

1. Transaction log record
2. Write log record
3. Read log record
4. Update log record

MCQ 3: The number of fields in an update log record are

1. 3
2. 4
3. 5
4. 6

MCQ 4: The field of update log record that defines the unique identifier of the transaction is known as

1. Data-item identifier
2. Old value identifier
3. Transaction identifier
4. New value identifier

MCQ 5: The unique identifier field in the update log record that performs the write operation is called

1. Data-item identifier
2. Transaction identifier
3. Data-value identifier
4. New value identifier