8.1 Database Concepts Cambridge iAS 9618

What is a major limitation of a file-based approach to data storage?

• Data redundancy and inconsistency.

• Faster data retrieval.

• Improved data security.

• Easier relationship management.

Which of the following is an advantage of a relational database over a file-based system?

• Reduced data duplication through normalization.

• More data redundancy.

• Slower data retrieval.

• No relationships between data.

In a relational database, what is an entity?

• A real-world object or concept represented in the database.

• A specific value in a table.

• A software application.

• A piece of hardware.

Which of the following best describes a table in a relational database?

• A collection of related records.

• A single data value.

• A set of unrelated attributes.

• A programming script.

What is a record in a relational database?

• A single row in a table.

• A column in a table.

• A database file.

• A relationship between tables.

Which of the following is the best definition of a field in a database?

• A single piece of data within a record.

• A table in the database.

• A primary key.

• A relationship between tables.

What is another term for a database record?

• Tuple

• Attribute

• Key

• Index

What is a primary key?

• A unique identifier for a record in a table.

• A foreign key linking two tables.

• A field that allows duplicate values.

• A secondary key used for searching.

Which key is a candidate to be a primary key but is not selected?

• Candidate key

• Foreign key

• Composite key

• Index key

What is the purpose of a foreign key?

• To create a relationship between two tables.

• To uniquely identify records in a table.

• To store secondary attributes.

• To sort data in ascending order.