Podcast
Questions and Answers
Which of the following is NOT a purpose of a database transaction?
Which of the following is NOT a purpose of a database transaction?
- To provide a method for restoring the database operation sequence from a failure
- To improve the performance of database operations (correct)
- To provide isolation between programs accessing a database concurrently
- To ensure atomicity of the transaction
What are the possible states of a transaction?
What are the possible states of a transaction?
- Active, committed, and completed
- Active, committed, and pending
- Active, committed, and failed
- Active, committed, and aborted (correct)
What is the meaning of atomicity in a transaction?
What is the meaning of atomicity in a transaction?
- The transaction is isolated from other concurrent programs
- The transaction is the logical working unit of a database
- The transaction is regarded as a whole (correct)
- The transaction can be restored from a failure
What is the main purpose of providing isolation between programs accessing a database concurrently?
What is the main purpose of providing isolation between programs accessing a database concurrently?
What is a transaction in the context of a database?
What is a transaction in the context of a database?