Databases for Year 7 Computing: Interactive Quizzes and Learning

Question 1

What is the primary purpose of a primary key in a database table?

Accepted Answer

To uniquely identify each row in the table

Answer

To store the most critical piece of information for each row

Answer

To link to related rows in other tables

Answer

To ensure that all data in the table is correct and consistent

Question 2

Which of these is a database query language?

Accepted Answer

SQL

Answer

HTML

Answer

Java

Answer

Python

Question 3

What is the difference between a row and a column in a database table?

Accepted Answer

A row contains data about a specific record, while a column contains the type of data in that record.

Answer

A column contains data about a specific record, while a row contains the type of data in that record.

Answer

A row and a column are the same thing.

Answer

A row is vertical, while a column is horizontal.

Question 4

What data structure is used to organize data in a hierarchical tree-like manner?

Accepted Answer

Tree

Answer

List

Answer

Queue

Answer

Stack

Question 5

What is the main role of a Database Management System (DBMS)?

Accepted Answer

To create and manage databases

Answer

To write queries

Answer

To analyze data

Answer

To design database schemas

Question 6

Which database type is best for storing large amounts of unstructured data, such as text or images?

Accepted Answer

Document database

Answer

Relational database

Answer

Graph database

Answer

Object-oriented database

Question 7

What is the primary purpose of a primary key in a database table?

Accepted Answer

To uniquely identify each row in the table.

Answer

To ensure that all data in the table is accurate.

Answer

To improve the performance of database queries.

Answer

To provide a reference point for linking to other tables.

Question 8

Which data structure is best suited to represent relationships between data elements in a database?

Accepted Answer

Graph

Answer

Array

Answer

List

Answer

Table

Question 9

Which of the following is NOT a type of database query?

Accepted Answer

VIEW

Answer

SELECT

Answer

INSERT

Answer

UPDATE

Question 10

What is the main purpose of a database index?

Accepted Answer

To speed up data retrieval.

Answer

To improve the organization of data.

Answer

To reduce data redundancy.

Answer

To enforce data integrity.

Question 11

Which data type stores whole numbers in a database?

Accepted Answer

Integer

Answer

String

Answer

Float

Answer

Boolean

Question 12

What is the main purpose of a primary key in a database table?

Accepted Answer

To uniquely identify each row in the table

Answer

To store the most important data in the row

Answer

To link the table to other tables in the database

Answer

To sort the data in the table in ascending order

Question 13

Which of the following is a widely used database management system?

Accepted Answer

MySQL

Answer

HTML

Answer

Java

Answer

Excel

Question 14

Which of the following is a query language specifically designed for interacting with databases?

Accepted Answer

SQL

Answer

Python

Answer

C++

Answer

JavaScript

Question 15

What is the primary purpose of an index in a database?

Accepted Answer

To enhance the speed of data retrieval

Answer

To ensure data integrity

Answer

To create a unique constraint on a column

Answer

To store additional information about a table

Question 16

Which characteristic is typically NOT a feature of a well-designed database?

Accepted Answer

Data duplication

Answer

Reliable data

Answer

Organized data

Answer

Easy to use

Question 17

In a relational database model, what are the structural components called?

Accepted Answer

Tables, records, and fields

Answer

Nodes and edges

Answer

Objects and classes

Answer

Documents and collections

Question 18

Which data type should be used to store a date and time value in a database?

Accepted Answer

Date

Answer

Integer

Answer

String

Answer

Boolean

Question 19

What is the main purpose of using a query in a database management system?

Accepted Answer

To retrieve specific data from a database

Answer

To create a new database

Answer

To update existing data in a database

Answer

To delete data from a database

Question 20

Which of the following is NOT a type of database key?

Accepted Answer

Unique constraint

Answer

Primary key

Answer

Foreign key

Answer

Composite key

Question 21

Explain the difference between a primary key and a foreign key in a database.

Accepted Answer

A primary key identifies a unique record, while a foreign key references another table.

Answer

A foreign key identifies a unique record, while a primary key references another table.

Answer

Both keys identify unique records.

Answer

Both keys reference other tables.

Question 22

What is the main purpose of creating an index in a database?

Accepted Answer

To improve query performance by providing a faster way to retrieve data.

Answer

To maintain data integrity by preventing duplicate or invalid data.

Answer

To prevent unauthorized access to sensitive data.

Answer

To reduce the overall size of the database.

Question 23

In a database, what is the primary function of a primary key?

Accepted Answer

To uniquely identify each record

Answer

To store the most valuable data

Answer

To establish connections between records in different tables

Answer

To ensure data integrity

Question 24

Which of the following is a widely used database query language?

Accepted Answer

SQL

Answer

HTML

Answer

Java

Answer

Python

Question 25

What is the primary purpose of a foreign key in a database?

Accepted Answer

To establish relationships between records in different tables

Answer

To uniquely identify each record

Answer

To store the most sensitive data

Answer

To maintain data consistency

Question 26

Which of the following is NOT a recognized type of database management system (DBMS)?

Accepted Answer

Google Docs

Answer

MySQL

Answer

Oracle

Answer

Microsoft Access

Question 27

What is the main purpose of a data dictionary in a database?

Accepted Answer

To provide definitions and descriptions of the data stored in the database

Answer

To store the actual data itself

Answer

To control user access to the database

Answer

To optimize the performance of the database

Question 28

What is the key difference between a flat-file database and a relational database?

Accepted Answer

Flat-file databases store data in a single table, while relational databases store data in multiple interrelated tables.

Answer

Relational databases store data in a single table, while flat-file databases store data in multiple unrelated tables.

Answer

Flat-file databases are more efficient than relational databases.

Answer

Relational databases are more efficient than flat-file databases.

Question 29

Which database model stores data in tables?

Accepted Answer

Relational

Answer

Hierarchical

Answer

Object-oriented

Answer

Network

Question 30

In database design, which data type is best suited for storing customer names?

Accepted Answer

String

Answer

Integer

Answer

Boolean

Answer

Decimal

Question 31

Which of the following is a type of database model?

Accepted Answer

Relational model

Accepted Answer

Hierarchical model

Accepted Answer

Network model

Answer

Sequential model

Question 32

Which of the following is the correct structure of a database table? (Table Name, Primary Key, Column Name, Data Type)

Accepted Answer

Table Name (Primary Key, Column Name, Data Type)

Answer

Column Name (Data Type, Primary Key, Table Name)

Answer

Primary Key (Table Name, Column Name, Data Type)

Answer

Data Type (Primary Key, Table Name, Column Name)

Question 33

What data type should be used to store a customer's name?

Accepted Answer

String

Answer

Integer

Answer

Boolean

Answer

Date

Question 34

Which of the following is NOT a constraint used with a primary key?

Accepted Answer

ForeignKey

Answer

Unique

Answer

Not Null

Answer

Auto Increment

Question 35

What is the main purpose of a foreign key in a database? (Establishing relationships between tables)

Accepted Answer

To link two tables together

Answer

To enforce data integrity

Answer

To create a unique index

Answer

To store additional information about a row

Question 36

Which of the following languages is used for data manipulation in databases?

Accepted Answer

SQL

Answer

HTML

Answer

CSS

Answer

JavaScript

Question 37

What is the difference between a SELECT query and an UPDATE query?

Accepted Answer

SELECT retrieves data, while UPDATE modifies data.

Answer

UPDATE retrieves data, while SELECT modifies data.

Answer

SELECT and UPDATE both retrieve data.

Answer

SELECT and UPDATE both modify data.

Question 38

What is the purpose of a database management system?

Accepted Answer

To create, manage, and access databases

Answer

To write and execute SQL queries

Answer

To design database schemas

Answer

To generate reports from databases

Question 39

How has the emergence of big data influenced the way we manage and use databases?

Accepted Answer

Big data has driven the creation of new database technologies and approaches.

Answer

Big data has simplified databases, making them more user-friendly and efficient.

Answer

Big data has diminished the importance of databases in business operations.

Answer

Big data has no impact on database management and usage.

Question 40

What's the key benefit of normalizing a database?

Accepted Answer

Less data duplication and better data accuracy

Answer

More data complexity and easier database design

Question 41

What query language is used specifically for managing and retrieving data from databases?

Accepted Answer

SQL

Answer

JavaScript

Answer

CSS

Answer

HTML

Question 42

What is the unique identifier used to distinguish each row in a database table?

Accepted Answer

Primary key

Answer

Most populated column

Answer

First column

Answer

Last column

Question 43

Which of the following is NOT an advantage of using a Database Management System (DBMS)?

Accepted Answer

Increased data redundancy

Answer

Enhanced data security

Answer

Improved data consistency

Answer

Easier data access

Question 44

What is the purpose of a foreign key in a database?

Accepted Answer

Connects a field to a primary key in another table

Answer

Creates new columns

Answer

Stores additional row information

Question 45

What is indexing used for in databases?

Accepted Answer

Speeds up data retrieval by locating matching rows quickly

Answer

Stores additional row information

Answer

Creates new columns

Question 46

Which database design principle aims to reduce data redundancy and improve integrity?

Accepted Answer

Normalization

Answer

Maximize table fields

Answer

Minimize table rows

Question 47

What is the main purpose of a primary key in a database table?

Accepted Answer

To uniquely identify each row in the table

Answer

To store the most important data in the table

Answer

To link the table to other tables in the database

Answer

To ensure that all data in the table is accurate

Question 48

Which of the following is not a common data type that can be stored in a database?

Accepted Answer

Image

Answer

Date

Answer

Number

Answer

Text

Question 49

What is the key difference between a SELECT statement and an INSERT statement in SQL?

Accepted Answer

A SELECT statement retrieves data from a table, while an INSERT statement adds new data to a table

Answer

A SELECT statement deletes data from a table, while an INSERT statement modifies existing data

Answer

A SELECT statement updates data in a table, while an INSERT statement creates a new table

Question 50

What is the primary function of a database management system (DBMS)?

Accepted Answer

To manage and control access to databases

Answer

To update and modify data in databases

Answer

To query and retrieve data from databases

Answer

To create and design databases

Question 51

Which of the following is a key advantage of using a database?

Accepted Answer

Data integrity and consistency

Answer

Difficult to maintain

Answer

Slow performance

Answer

Limited data storage

Question 52

What is the main difference between a flat-file database and a relational database?

Accepted Answer

A flat-file database stores data in a single table, while a relational database stores data in multiple tables linked by relationships

Answer

A flat-file database is more efficient than a relational database

Question 53

What is the primary purpose of a foreign key in a database table?

Accepted Answer

To establish a relationship between two tables

Answer

To identify the primary key of a table

Answer

To store additional information about a record

Answer

To prevent duplicate data from being entered

Question 54

What is the main purpose of an index in a database table?

Accepted Answer

To speed up data retrieval

Answer

To store additional information about a record

Answer

To prevent duplicate data from being entered

Answer

To ensure data integrity

Question 55

Which of the following is not a component of a typical database system?

Accepted Answer

Spreadsheet software

Answer

Data

Answer

Database management system (DBMS)

Answer

Users