SLR10 - Revision Quiz

What is the main purpose of Atomicity in database transactions?

• To ensure transactions are either fully completed or not at all

• To maintain data consistency

• To allow partial transaction processing

• To ensure data is stored in secondary storage

Which property ensures that each transaction obeys the defined validation rules of the database?

• Consistency

• Atomicity

• Isolation

• Durability

What does CRUD stand for in relational databases?

• Create, Read, Update, Delete

• Create, Retrieve, Update, Delete

• Create, Read, Upload, Delete

• Create, Read, Update, Drop

What does Durability ensure in database transactions?

• Changes are not lost once made

• Transactions are isolated

• Data is consistent

• Transactions are atomic

What is Entity-Relationship Modelling used for?

• Describing data tables and relationships visually

• Ensuring data integrity

• Locking records during updates

• Creating indexes for primary keys

What is a characteristic of a table in First Normal Form (1NF)?

• No repeating attributes

• Multiple primary keys

• Redundant data

• Nested tables

What type of database uses a single table data structure to store all data?

What is a Foreign Key used for in a relational database?

• Linking two tables

• Identifying unique records

• Creating indexes

• Ensuring data integrity

What does Isolation ensure in database transactions?

• Transactions are not interrupted

• Data is consistent

• Changes are durable

• Data is normalized

What feature is used to uniquely identify a record in a table?