A-level Transaction Processing

What does the term 'transaction processing' refer to?

• Only the processing of financial transactions.
• The process of updating and deleting data.
• Any information processing divided into transactions.
• The ability to create and read data.

What is the primary purpose of transaction processing in databases?

• To allow multiple users to access data simultaneously.
• To ensure data integrity and reliability.
• To facilitate data retrieval.
• To enable data to be deleted permanently.

Why is it important for transactions to be indivisible operations?

• To allow partial completion of tasks.
• To ensure data integrity is maintained.
• To enable multiple transactions to run at once.
• To make transactions reversible.

What does the acronym CRUD stand for in the context of relational databases?

• Calculate, Retrieve, Upload, Delete
• Create, Read, Update, Delete
• Create, Retrieve, Update, Delete
• Create, Read, Upload, Delete

Which of the following is NOT a function represented by the acronym CRUD?

• Read
• Transfer
• Update
• Create

What is the significance of the ACID properties in transaction processing?

• They allow transactions to be interrupted.
• They guarantee data integrity during transactions.
• They ensure transactions are reversible.
• They enable multiple transactions to run simultaneously.

Which of the following best describes the role of a DBMS in transaction processing?

• To allow multiple users to edit data simultaneously.
• To create new databases.
• To enforce the ACID properties and ensure data integrity.
• To delete data permanently.

Which ACID property ensures that a transaction is either fully completed or not at all?

• Durability
• Atomicity
• Isolation
• Consistency

What happens if a transaction is only partially completed?

• The database remains unchanged.
• The changes are saved to the database.
• The transaction is considered successful.
• The transaction is rolled back.

Which of the following best describes the concept of atomicity in transaction processing?

• Transactions can be partially completed.
• Transactions are indivisible operations.
• Transactions must be completed in parts.
• Transactions can be interrupted.