NEW
Font size
WorksheetsA Level Computing Databases #1
Total questions: 11
Worksheet time: 6mins
What is a database?
A complex algorithm for data processing
An organized collection of data
A type of computer hardware
A programming language
What is the primary key in a database?
A tool to encrypt data
A password to access the database
A unique identifier for each record
A key that opens the database
What type of relationship is described as one-to-many?
One tutor group contains many students
One tutor group belongs to one student
One student belongs to many tutor groups
Many students belong to one student
What is normalization in the context of databases?
Backing up data regularly
Adjusting the database size
Reducing data redundancy
Encrypting sensitive information
What is a foreign key?
A key from another database
A primary key in another table
A unique identifier used in foreign databases
A backup key for emergency use
What is the purpose of indexing in a database?
To increase the database size
To make the database look organized
To secure the database
To make data retrieval quicker
What is a flat file database?
A 3D model of a database
A database stored on flat storage devices
A database that cannot contain tables
A database with only one table
What does 'entity relationship modeling' help with?
Modeling the user interface of the database application
Calculating the storage space needed for the database
Sketching out the relationships between tables
Designing the physical appearance of the database
What is a secondary key?
A duplicate of the foreign key
A field indexed for search purposes
A key used for secondary databases
A backup primary key
Why might a many-to-many relationship be considered poor database design?
It is too complex to understand
It makes the database too fast
It can lead to data redundancy
It is not supported by most databases
What does ACID stand for in the context of database transactions?
Atomicity, Consistency, Isolation, Durability
Association, Consistency, Integrity, Durability
Atomicity, Consistency, Integrity, Diversity
Association, Compression, Isolation, Durability
