NEW
Font size
WorksheetsDatabase Bitesize
Total questions: 20
Worksheet time: 10mins
What is a database?
A collection of data organized for easy access and management
A type of software used for graphic design
A programming language
A hardware device for storing data
Name two types of databases.
Flat-file and relational
SQL and NoSQL
Primary and foreign
Static and dynamic
What is a primary key?
A unique identifier for a record in a database table
A key used to encrypt data
A secondary identifier for a record
A type of database relationship
Explain the term 'foreign key'.
A key used to access foreign databases
A unique identifier for a record in a database table
A field in one table that uniquely identifies a row of another table
A type of database management system
What is a relational database?
A database that stores data in a single table
A database that stores data in multiple tables with relationships between them
A database used for storing images
A database that does not support SQL
Define 'data redundancy'.
The duplication of data in a database
The process of normalizing data
The encryption of data
The deletion of data
What is the purpose of a database management system (DBMS)?
To manage and control access to the database
To design websites
To create graphic designs
To manage network security
Describe the term 'data integrity'.
The accuracy and consistency of data in a database
The process of encrypting data
The duplication of data
The deletion of data
What is SQL and what is it used for?
A programming language used for web development
A query language used for managing and manipulating databases
A type of database management system
A software used for graphic design
Explain the difference between a flat-file database and a relational database.
Flat-file databases store data in multiple tables; relational databases store data in a single table
Flat-file databases store data in a single table; relational databases store data in multiple tables with relationships
Flat-file databases are used for graphic design; relational databases are used for web development
Flat-file databases do not support SQL; relational databases support SQL
What is a query in the context of databases?
A request for data from a database
A type of database relationship
A programming language
A hardware device for storing data
Name and describe two types of database relationships.
Primary and foreign
One-to-one and one-to-many
What is normalization in databases?
The process of organizing data to reduce redundancy
The encryption of data
The deletion of data
The duplication of data
Explain the term 'entity' in a database.
A unique identifier for a record
A field in a table
An object or concept about which data is stored
A type of database relationship
What is an attribute in a database?
A unique identifier for a record
A field in a table that stores data about an entity
A type of database relationship
A query language
Describe the purpose of an index in a database.
To speed up the retrieval of data
To encrypt data
To delete data
To duplicate data
What is a data type? Give two examples.
A programming language; SQL and NoSQL
A type of database relationship; primary and foreign
A classification of data; integer and string
A hardware device; hard drive and SSD
Explain the concept of 'data validation'.
The process of ensuring data is accurate and consistent
The encryption of data
The duplication of data
The deletion of data
What is a report in a database system?
A formatted presentation of data
A type of database relationship
A programming language
A hardware device for storing data
The role of a database administrator (DBA) is to:
manage and maintain the database system
design websites
create graphic designs
manage network security
