Transaction processing

ACID

________ is used to ensure that the integrity of the database is maintained under any circumstances.

simultaneous access

Record locking prevents ________ to the same record.

ACID

________ stands for Atomicity, Consistency, Isolation, Durability.

What is data capture?

Data capture is the process of collecting data and inputting it into a database.

What are the two methods of data capture?

The two methods of data capture are manual and automated.

What are some examples of automated data capture methods?

Some examples of automated data capture methods are smart card readers, barcode readers, scanners, optical character recognition, optical mark recognition, magnetic ink character recognition, and sensors.

What is EDI?

EDI stands for Electronic Data Interchange, which is the computer-to-computer exchange of documents.

What is ACID?

ACID stands for Atomicity, Consistency, Isolation, and Durability, which are used to ensure the integrity of a database.

What is record locking?

Record locking is a technique used to prevent simultaneous access to the same record in a database.

What is serialisation?

Serialisation is a technique used by the database management system to prevent deadlocks from arising.

What is redundancy?

Redundancy is the duplication of hardware in different geographical areas to mirror every transaction that happens on the main database.