Databases GCSE

Quiz Summary

0 of 10 Questions completed

Questions:

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 10 Questions answered correctly

Your time:

You have reached 0 of 0 point(s), (0)

Current
Review
Answered
Correct
Incorrect

Question 1 of 10

1. Question
Which definition best describes a database?
- A file which stores data.
- A table.
- A persistent and organised store of data.
- A collection of different data types under one record.
- A range of data items that can be located quickly by software.
Correct

Incorrect
Question 2 of 10

2. Question
What is the name of the software which operates on the data stored in a database?
- Database Management Software (DBMS)
- Database Software (DBS)
- Database Operator Software (DBOS)
- Database Controller (DBC)
Correct

Incorrect
Question 3 of 10

3. Question
What is meant by the database term “Record”?
- Collection of data that relates to an entity (e.g. students)
- A collection of data about a single entity (e.g. a student)
- A unique piece of data about an entity (student surnames)
- An identifier for the single piece of data (e.g. ‘surnames’)
Correct

Incorrect
Question 4 of 10

4. Question
What is meant by the database term “Field”?
- Collection of data that relates to an entity (e.g. students)
- A collection of data about a single entity (e.g. a student)
- A unique piece of data about an entity (student surnames)
- An identifier for the single piece of data (e.g. ‘surnames’)
Correct

Incorrect
Question 5 of 10

5. Question
What is meant by the database term ‘Query’?
- Finding out the name of a database table.
- Producing a report from selected data.
- The interface of the database allowing for effective data entry.
- Searching / interrogating the database for specific information.
Correct

Incorrect
Question 6 of 10

6. Question
What is meant by the term ‘Data Redundancy’?
- This is where multiple copies of a database are created.
- This is where the same data is held in two or more different places within a database.
- This is where too much unuseful data is selected during a database query.
- This is the term given to a database that is no longer of use to a company.
Correct

Incorrect
Question 7 of 10

7. Question
What is a ‘Relational Database’?
- A table of data about related entities.
- Several tables of data, each about a single entity,
- Several tables of data, that combine to provide data about a single entity.
- Several tables of data, each holding data about an entity, which are linked together using key fields.
Correct

Incorrect
Question 8 of 10

8. Question
What is a ‘Primary Key’ in a relational database?
- A column in a database table, which contains unique data from another table, establishing a link between the database tables.
- A column of a database table, which, in each row, contains unique data allowing each row of the table to be identified and is used to link the table to other tables in the database.
- A column of a database table, which contains the most important data in that table.
- A column of a database table, which contains links to the other fields of the table.
Correct

Incorrect
Question 9 of 10

9. Question
What is a ‘Foreign Key’ in a relational database?
- A column in a database table, which contains unique data from another table, establishing a link between the database tables.
- A column of a database table, which, in each row, contains unique data allowing each row of the table to be identified and is used to link the table to other tables in the database.
- A column of a database table, which contains the most important data in that table.
- A column of a database table, which contains links to the other fields of the table.
Correct

Incorrect
Question 10 of 10

10. Question
What is a database query?
- A query enables data to be inserted into a database table using SQL statements.
- A query is where data is permanently removed from a database so that it can be analysed.
- A query is where the SQL ‘Select’ statement is used to identify data from the database that meets certain criteria.
- A query is when the database offers its data to the user or system.
Correct

Incorrect

Databases GCSE

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question