Grade 10 MCQs on Databases

What is a database?

• A collection of related files

• A collection of organized data

• A collection of unrelated tables

• A collection of software tools

What is the primary purpose of a database?

• To store large amounts of data

• To provide internet services

• To perform high-speed calculations

• To control computer hardware

Which of the following is an example of a manual database?

• Phonebook

• Microsoft Access

• Oracle

• Excel Spreadsheet

Which of the following is an advantage of electronic databases?

• Less space required for storage

• Data analysis is difficult

• Harder to retrieve information

• Data cannot be shared

What is meant by data redundancy?

• Data stored efficiently

• Same data stored in multiple places

• Data stored without any backup

• Data removed when no longer needed

Which of the following is NOT a characteristic of a database?

• Increased efficiency

• Data duplication

• High accuracy

• Data security

Which key uniquely identifies each record in a table?

• Foreign Key

• Composite Key

• Primary Key

• Field Key

What does a foreign key do?

• It makes tables run faster

• It uniquely identifies records in a table

• It links two tables together

• It deletes records from a table

Which of the following is an example of a relational database?

• A single table with no links

• Multiple tables with no relationship

• Multiple tables linked by foreign keys

• Data stored in a flat file

What is a one-to-one relationship?

• A row in one table relates to multiple rows in another table

• One table is related to itself

• A row in one table relates to exactly one row in another table

• Multiple rows in one table relate to one row in another