Alsager - A2 - 1.3.2 - Databases

Which of the following is not a component of a relational database system?

• Primary Keys

• Normalisation

• Referential Integrity

• Record locking

What does ACID stand for in the context of transaction processing?

• Atomicity, Consistency, Isolation, Durability

• Association, Condition, Isolation, Documentation

• Atomicity, Consistency, Integration, Durability

• Association, Consistency, Isolation, Durability

What is the purpose of indexing in a database?

• To lock records during a transaction

• To manage database redundancy

• To improve the speed of data retrieval

• To establish referential integrity

Which of the following is a method of ensuring that data remains consistent after transactions?

• Normalisation

• Indexing

• Entity relationship modelling

• ACID properties

What is the main focus of normalisation in database design?

• Increasing data redundancy

• Improving transaction processing

• Reducing data redundancy and improving data integrity

• Locking records to prevent concurrent access

What is an entity in the context of a relational database?

• A) A single file in the database

• B) A unique identifier for each record

• C) An item of interest about which information is stored

• D) The attribute which links two tables together

What does a flat file database consist of?

• A) Multiple files with complex relationships

• B) A single file based around a single entity and its attributes

• C) Two or more linked tables

• D) A unique identifier for each record

What is a primary key in a database?

• A) The attribute that links two tables together

• B) A single file in the database

• C) A unique identifier for each record in the table

• D) An item of interest about which information is stored

What is a foreign key in the context of relational databases?

• A) A single file in the database

• B) An item of interest about which information is stored

• C) A unique identifier for each record in the table

• D) The attribute which links two tables together

What is the purpose of a secondary key in a database?

• To slow down the search process

• To search quickly

• To create a primary key

• To delete data