Understanding Database Concepts and Structures

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

• High data redundancy and inconsistency

• Enhanced data security

• Simplified data sharing

• Improved data integrity

Which feature of a relational database helps to reduce data redundancy?

• Use of primary keys

• Data normalization

• Use of secondary keys

• Data encryption

What is the purpose of normalizing a database to Third Normal Form (3NF)?

• To ensure all data is stored in a single table

• To eliminate transitive dependencies

• To increase data redundancy

• To simplify database queries

Which of the following is a feature of a database?

• Spreadsheet

• Record

• Graph

• Chart

What is a candidate key in a database table?

• A key that is always used as the primary key

• An attribute or set of attributes that uniquely identify a tuple

• A key that is used for indexing

• A key that is used for encryption

Which of the following is true about a primary key?

• It can have duplicate values

• It is a special case of a candidate key

• It is used to encrypt data

• It is always a foreign key

What is a secondary key in a database?

• A key that is used to encrypt data

• A candidate key that is an alternative to the primary key

• A key that is always used as the primary key

• A key that is used for indexing

What is a foreign key in a relational database?

• A key that uniquely identifies a record within its own table

• A set of attributes in one table that refer to the primary key in another table

• A key that is used for encryption

• A key that is used for indexing

Which of the following is NOT a feature of a relational database?

• Tables

• Fields

• Records

• Graphs

In a relational database, what is a table?

• A collection of related fields

• A collection of related records

• A single data point

• A method for data encryption