A-Level Comp Sci 9618 Databases

What is a limitation of using a file-based approach for the storage and retrieval of data?

• Lack of data integrity
• Faster query processing
• Scalability
• Lower storage requirements

Which feature of a relational database addresses the limitations of a file-based approach?

• Data redundancy
• Data isolation
• Data consistency
• Increased storage requirements

What is the main purpose of an entity-relationship (E-R) diagram?

• To document a database design
• To create database tables
• To normalize database tables
• To manage database users

Which term refers to the process of organizing a database to minimize redundancy and improve data integrity?

• Denormalization
• Normalization
• Optimization
• Indexing

What does Third Normal Form (3NF) ensure in a database?

• No non-key dependencies

• No partial dependencies

• No multivalued dependencies

• No duplicate data

What is the purpose of a primary key in a relational database?

• To ensure data redundancy
• To uniquely identify a record
• To link tables in a many-to-many relationship
• To store multiple values in a single field

What is the purpose of a foreign key in a relational database?

• To uniquely identify a record
• To enforce data consistency
• To link tables in a relationship
• To store multiple values in a single field

Which feature is provided by a Database Management System (DBMS) to address the issues of a file-based approach?

• Data management
• Data redundancy
• Data fragmentation
• Increased storage requirements

In a DBMS, what is the purpose of a query processor?

• To maintain a data dictionary
• To create and modify database structure
• To execute database queries
• To ensure data security

What is the industry standard for both Data Definition Language (DDL) and Data Manipulation Language (DML)?

• Structured Query Language (SQL)
• Python
• C++
• Java