H446_1.3.2_Database Transaction Quiz

What does the acronym ACID stand for in transaction processing?

• Atomicity, Clarity, Isolation, Durability

• Atomicity, Consistency, Isolation, Durability

• Accuracy, Consistency, Isolation, Durability

• Atomicity, Consistency, Interoperability, Durability

Which of the following is a method of automated data capture?

• Transcribing data from a paper form

• Optical Mark Recognition (OMR)

• Manually entering data into a spreadsheet

• Typing responses into a survey

What does the Atomicity property of ACID ensure?

• Transactions are executed sequentially.

• Transactions are either fully completed or not executed at all.

• All concurrent transactions produce identical results.

• Data integrity rules are never violated.

What is the purpose of record locking in a multi-user database?

• To allow multiple users to access a record simultaneously.

• To prevent simultaneous access to records during updates.

• To permanently restrict access to sensitive data.

• To prevent users from reading data in the database.

What problem can arise if multiple users attempt to update records simultaneously without locking mechanisms?

• Serialization

• Redundancy

• Deadlock

• Data inconsistency

How does the durability property of ACID protect transaction data?

• By ensuring transactions can be reversed if needed.

• By ensuring completed transactions persist even after a power failure.

• By allowing only one transaction at a time to execute.

• By validating data integrity rules before the transaction begins.

What is a common method for exchanging data electronically without human intervention?

• Emailing documents

• Printing and scanning documents

• Electronic Data Interchange (EDI)

• Using cloud-based file storage

In the context of transaction management, what is "deadlock"?

• A situation where multiple users can edit the same record.

• A situation where transactions are executed out of order.

• A situation where two transactions wait indefinitely for each other to release resources.

• A mechanism to prevent data loss during power failures.

How does timestamp ordering ensure transaction consistency?

• By ensuring transactions execute in order of their timestamps.

• By randomly assigning priorities to transactions.

• By disallowing simultaneous transactions on any database object.

• By saving the results of all transactions to a log.

What is the role of redundancy in database systems?

• To ensure no two users can edit the same record simultaneously.

• To guarantee data is consistent across all tables in the database.

• To maintain backup systems to prevent data loss during failures.

• To allow simultaneous execution of multiple transactions.