NEW
Font size
Worksheets8525 AQA GCSE CS 3.7.1 Introduction to Relational Data
Total questions: 10
Worksheet time: 5mins
What is a database?
A single file containing user data
A temporary collection of unstructured information
A random collection of data
A structured and persistent collection of data
What are the two main types of databases?
Relational and Non-Relational
Single table and Double table
Flat-file and Hierarchical
Flat-file and Relational
Why are flat-file databases considered inefficient?
Because they use complex queries for data retrieval
Because they often contain duplicated data
Because they store data without any structure
Because they can handle large datasets efficiently
What is a key advantage of relational databases over flat-file databases?
They contain only one table
They do not require a database management system
They eliminate data inconsistency and redundancy
They are easier to duplicate
What does a Database Management System (DBMS) provide?
A way to duplicate data efficiently
A manipulation language like SQL
A single table for data storage
A structure for unorganized data
What is the role of SQL in a DBMS?
To create a flat-file database
To access and change the data
To duplicate data
To provide additional security
Why is data redundancy undesirable in databases?
It increases storage requirements
It simplifies data structure
It enhances data security
It makes data retrieval faster
How do relational databases help in maintaining data integrity?
By duplicating data across multiple tables
By using a single table for all data
By storing all data in a flat-file format
By relating tables and avoiding data inconsistencies
What is a significant disadvantage of using flat-file databases for large datasets?
They are difficult to query
They are too structured
They enhance data security
They require less storage
What does the persistence of a database refer to?
The database's ability to handle large datasets
The database's data being temporary
The database's use of complex queries
The database's data being stored permanently
