Transaction Processing, CRUD and ACID

What is transaction processing in the context of databases?

• A process that allows partial completion of operations

• A process that divides information processing into indivisible operations called transactions

• A process that only updates data without reading it

• A process that deletes data without creating it

Which of the following is NOT part of the CRUD operations in relational databases?

• Create

• Read

• Update

• Analyse

What does the 'C' in CRUD stand for?

• Consistency

• Create

• Complete

• Calculate

Which SQL statement is used to remove data from a database?

• INSERT

• SELECT

• DELETE

• UPDATE

What does the 'A' in ACID rules stand for?

• Availability

• Atomicity

• Accessibility

• Adaptability

Which of the following is a property required by every database according to the ACID rules?

• Isolation

• Integration

• Innovation

• Interaction

What is the main purpose of the ACID rules in transaction processing?

• To ensure data redundancy

• To ensure data integrity

• To ensure data loss

• To ensure data duplication

Match the following SQL statements with their purposes.

• Used to remove data from a database

• CREATE

• Used to create a new table in the database

• INSERT

• Used to modify existing data in a database

• DELETE

• Used to add new data to a database

• UPDATE

The 'D' in ACID stands for (a)  

• Durability
• Dependency
• Development
• Distribution

(a)   is a core function of relational databases.

• Analyse
• Create
• Integrate
• Synchronise