Databases h446 transaction processing

What is a transaction in a database system?

• A method to backup data

• A request to log into the database

• A type of database

• A single logical unit of work that may consist of multiple steps

What is an example of a transaction with multiple steps?

• Deleting a record from the database

• Changing the database password

• Transferring money from a current account to a savings account

• Creating a new database

What is a key principle of transaction processing?

• Transactions do not need to be logical units

• Either all of the steps must happen, or none of them must happen

• Transactions can be partially completed

• Only the first step of a transaction needs to be successful

What makes managing transactions more complex?

• The use of older database technology

• Simple database queries

• Databases that only allow a single user

• Databases supporting multiple users making concurrent processing requests

What is concurrent processing?

• Processing transactions one after another

• A type of database software

• A method to lock database records

• Handling multiple transactions at the same time

What is serialisation in the context of databases?

• Deleting old transactions from the database

• Backing up the database

• Ensuring transactions are processed in a sequential order

• Converting data into a series of bytes

What is record locking?

• Preventing a record from being changed while it is being used by a transaction

• A security measure to protect records from unauthorized access

• Permanently deleting a record

• Copying records to another location

What does timestamp ordering help with?

• Organizing records alphabetically

• Speeding up database queries

• Determining the age of the database

• Resolving conflicts in concurrent transactions

What is the purpose of SQL in transaction processing?

• To create graphical interfaces for databases

• To manage database security

• To define and manipulate data within transactions

• To network multiple databases together

What does the ACID test ensure in transaction processing?

• That the database can handle large amounts of data

• That transactions are processed reliably and safely

• That transactions are processed at high speed

• That the database is free of viruses