ACID Properties of Database Transaction

What is the purpose of checkpointing in a database?

• The purpose of checkpointing in a database is to save the current state for recovery and ensure data integrity.

• To optimize query performance

• To delete old data records

• To increase data redundancy

How does checkpointing improve database recovery?

• Checkpointing improves database recovery by allowing restoration to the last saved state, minimizing data loss and recovery time.

• Checkpointing eliminates the need for backups entirely.

• Checkpointing only improves performance, not recovery.

• Checkpointing requires manual intervention for recovery.

Define the ACID properties of a database transaction.

• Atomicity, Consistency, Isolation, Accessibility

• ACID properties: Atomicity, Consistency, Isolation, Durability.

• Accuracy, Clarity, Integrity, Timeliness

• Atomicity, Clarity, Isolation, Reliability

What does the 'A' in ACID stand for?

• Consistency

• Isolation

• Atomicity

• Accessibility

Explain the significance of the 'C' in ACID.

• Durability

• Availability

• Isolation

• Consistency

What does the 'I' in ACID represent?

• Isolation

• Consistency

• Durability

• Integration

Describe the 'D' in ACID and its importance.

• Isolation

• Durability

• Atomicity

• Dependability

What is media recovery in the context of databases?

• Media recovery is the method of encrypting database files for security.

• Media recovery is the process of deleting old data from a database.

• Media recovery refers to the process of optimizing database queries.

• Media recovery is the process of restoring a database to a consistent state using backup media after a failure.

How does media recovery differ from other recovery methods?

• Media recovery only applies to cloud storage solutions.

• Other recovery methods always require physical media.

• Media recovery restores data from backup media, while other methods may use logs or snapshots.

• Media recovery is faster than all other recovery methods.

What role does a log play in database recovery?

• A log is primarily for auditing user access to the database.

• A log helps in optimizing database queries for performance.

• A log is used to store user passwords securely.

• A log helps in database recovery by tracking changes and enabling restoration to a consistent state after a failure.