1.3.2 Database Concepts and Management Quiz

What is a primary key in a relational database?

• A unique identifier for each record in a table

• A field that links two tables together

• A non-unique field used for searching

• A backup of the database

Which of the following best describes a flat file database?

• A database with multiple related tables

• A single table stored in a plain text file

• A database with complex relationships

• A database stored in the cloud

What is the purpose of normalisation in database design?

• To increase redundancy

• To reduce data anomalies and redundancy

• To make the database larger

• To decrease data integrity

Which of the following is a characteristic of a foreign key?

• It must be unique within its table

• It is used to link two tables together

• It is always a numeric field

• It is used to store large text data

What does the 'C' in ACID stand for in transaction processing?

• Consistency

• Concurrency

• Complexity

• Control

Which SQL command is used to modify existing records in a database?

• SELECT

• UPDATE

• DELETE

• INSERT

What is referential integrity in a database?

• Ensuring all data is encrypted

• Ensuring foreign keys match primary keys in related tables

• Ensuring all tables are indexed

• Ensuring data is backed up regularly

What is the third normal form (3NF) in database normalisation?

• A table with no repeating groups

• A table where all non-key attributes are functionally dependent on the primary key

• A table with no transitive dependencies

• A table with a single primary key

Which of the following is a method of capturing data?

• Data encryption

• Data entry forms

• Data normalisation

• Data indexing

What is the purpose of indexing in a database?

• To increase the size of the database

• To speed up data retrieval

• To ensure data integrity

• To normalise the database