Transaction processing

Suppose several people are simultaneously trying to reserve the last few seats on an aeroplane, what could happen?

Evaluate responses using AI:

OFF

What can be used to transfer data between computer systems?

Evaluate responses using AI:

OFF

What are the potential problems with manual data entry?

Evaluate responses using AI:

OFF

What is a single logical operation in a database known as?

• Transaction

• operation
• transaction
• command

How do we search, filter and retrieve data stored in a database?

What does ACID stand?

Evaluate responses using AI:

OFF

What is the purpose of ACID in a database?

• The purpose of ACID in a database is to ensure reliable processing of transactions and maintain data integrity.
• To store data in a non-volatile format.
• To allow multiple users to edit the same data simultaneously.
• To improve database speed and performance.

What are the potential issues with a multi user database? Give an example in your answer.

Evaluate responses using AI:

OFF

​ (a)   ensures that ​ (b)   do not overlap in time and therefore cannot ​ (c)   with each other or lead to updates being lost. Serialisation techniques include: ​ (d)   ordering and ​ (e)   ordering

• Serialisation
• transactions
• interfere
• Timestamp
• Commitment
• Commencement
• Time Critical
• Adjust
• Records

Describe the technique used for time stamp ordering:

Evaluate responses using AI:

OFF