Databases: A Comprehensive Guide for Year 9 ICT Students

Question 1

What is a potential drawback of using a database management system (DBMS)?

Accepted Answer

Increased costs

Answer

Centralized data storage

Answer

Reduced data redundancy

Answer

Improved data security

Question 2

Which data type is used to store text data in a database?

Accepted Answer

String

Answer

Integer

Answer

Boolean

Answer

Date

Question 3

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

Accepted Answer

Relational databases organize data in tables with structured columns and rows, while non-relational databases store data in a more flexible, document-based format.

Answer

Non-relational databases are faster than relational databases.

Answer

Relational databases are more secure than non-relational databases.

Answer

Non-relational databases are better suited for handling large datasets.

Question 4

Which data type would be most appropriate for storing an address?

Accepted Answer

String

Answer

Integer

Answer

Boolean

Answer

Date

Question 5

What is the main purpose of a database query?

Accepted Answer

To retrieve specific data from a database

Answer

To update data in a database

Answer

To delete data from a database

Answer

To create a new database

Question 6

Which data model organizes data into tables, rows, and columns?

Accepted Answer

Relational model

Answer

Hierarchical model

Answer

Network model

Answer

Object-oriented model

Question 7

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

Accepted Answer

To uniquely identify each row

Answer

To store the most crucial data in the table

Answer

To establish links between tables

Answer

To ensure data accuracy

Question 8

Which query language is used to extract and manipulate data from relational databases?

Accepted Answer

SQL

Answer

HTML

Answer

Python

Answer

Java

Question 9

Which of these is **NOT** an advantage of using a database?

Accepted Answer

Increased data repetition

Answer

Enhanced data organization

Answer

Improved data security

Answer

Accelerated data retrieval

Question 10

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

Accepted Answer

Flat-file databases store data in one table, while relational databases use multiple tables linked by relationships.

Answer

Relational databases are more complex than flat-file databases.

Answer

Flat-file databases are more efficient than relational databases.

Answer

There is no difference between flat-file and relational databases.

Question 11

What is the primary role of a data dictionary in a database system?

Accepted Answer

Storing metadata about data in the database

Answer

Enforcing data integrity and consistency

Answer

Optimizing query performance

Answer

Providing a graphical representation of the database structure

Question 12

Which of the following components is NOT included in a database management system (DBMS)?

Accepted Answer

Operating system

Answer

Data dictionary

Answer

Query processor

Answer

Concurrency control

Question 13

What is the key difference between a primary key and a unique key?

Accepted Answer

Unique keys can have duplicate values, while primary keys cannot.

Answer

Primary keys can have duplicate values, while unique keys cannot.

Answer

Primary keys are used to identify records, while unique keys are used to enforce data integrity.

Answer

There is no difference between a primary key and a unique key.

Question 14

What is the SQL command used to create a new database?

Accepted Answer

CREATE DATABASE

Answer

NEW DATABASE

Answer

MAKE DATABASE

Answer

BUILD DATABASE

Question 15

Which component is NOT found in a database management system (DBMS)?

Accepted Answer

Web browser

Answer

Data definition language

Answer

Data manipulation language

Answer

Query language

Question 16

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

Accepted Answer

To uniquely identify each record in the table

Answer

To store the most important data in the table

Answer

To enforce data integrity

Answer

To link the table to other tables

Question 17

What is the key difference between a table and a query in a database?

Accepted Answer

A table stores data, while a query retrieves data

Answer

A query stores data, while a table retrieves data

Answer

A table and a query are the same thing

Answer

A query is more powerful than a table

Question 18

Which SQL statement is used to create a new table?

Accepted Answer

CREATE TABLE

Answer

SELECT

Answer

INSERT INTO

Answer

UPDATE

Question 19

What is the main advantage of utilizing a graphical user interface (GUI) for database management?

Accepted Answer

Increased ease of use and accessibility for users with varying technical backgrounds

Answer

Faster data retrieval and manipulation

Answer

Improved data security

Answer

More powerful data analysis capabilities

Question 20

Which component of a database management system (DBMS) handles data manipulation and storage?

Accepted Answer

Database engine

Answer

Data

Answer

User interface

Answer

Storage device

Question 21

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

Accepted Answer

To uniquely identify and distinguish each record in the table

Answer

To connect the table to other related tables

Answer

To store the most valuable information in the table

Answer

To prevent unauthorized access to the table's data

Question 22

Which data type is appropriate for storing dates and times in a database?

Accepted Answer

Timestamp

Answer

Integer

Answer

String

Answer

Boolean

Question 23

What is the fundamental difference between a record and a field in a database?

Accepted Answer

A record is a group of fields, while a field holds individual data.

Answer

A field is a collection of records, while a record contains specific data.

Answer

Records and fields are interchangeable terms.

Answer

Fields are only used in primary keys, unlike records which store all other data.

Question 24

Which of the following is a common database query operation used to retrieve data?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 25

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

Accepted Answer

To establish relationships and link data between tables

Answer

To create a unique index on a table

Answer

To ensure the accuracy and consistency of data

Answer

To store additional details about a record

Question 26

What is the primary responsibility of a database administrator (DBA)?

Accepted Answer

Designing, implementing, and maintaining databases

Answer

Writing and executing database queries

Answer

Providing user support for database systems

Answer

Ensuring data security and compliance

Question 27

What is the main purpose of a database schema?

Accepted Answer

To outline the structure and relationships within a database

Answer

To maintain the integrity and accuracy of data

Answer

To optimize database performance

Answer

To provide a visual representation of the database

Question 28

Which component is NOT part of a Database Management System (DBMS)?

Accepted Answer

Spreadsheet

Answer

Data dictionary

Answer

Query processor

Answer

Client application

Question 29

What is the primary function of a primary key in a database?

Accepted Answer

To uniquely identify each record in a table

Answer

To enforce data integrity

Answer

To store the most important data in the table

Answer

To link related tables

Question 30

Which data type is most appropriate for storing a customer's address?

Accepted Answer

String

Answer

Integer

Answer

Boolean

Answer

Date

Question 31

What is the key difference between a relational and a hierarchical database?

Accepted Answer

Relational databases use tables, while hierarchical databases use a tree structure

Answer

Hierarchical databases are more flexible than relational databases

Answer

Relational databases are more efficient than hierarchical databases

Answer

Hierarchical databases are better suited for large datasets

Question 32

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

Accepted Answer

To enhance data retrieval speed

Answer

To guarantee data accuracy

Answer

To prevent data loss

Answer

To organize data logically

Question 33

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

Accepted Answer

Uniquely identifies each row in the table.

Answer

Enforces referential integrity.

Answer

Stores the most important information.

Answer

Links multiple tables together.

Question 34

Which SQL command creates a new table in a database?

Accepted Answer

CREATE TABLE

Answer

INSERT INTO

Answer

UPDATE

Answer

SELECT * FROM

Question 35

What is the primary purpose of data normalization in database design?

Accepted Answer

To eliminate data redundancy and improve data accuracy.

Answer

To reduce database size.

Answer

To simplify database usage.

Question 36

Which type of database query is used to retrieve specific data from a database?

Accepted Answer

Select query

Answer

Update query

Answer

Insert query

Question 37

What is the primary responsibility of a database administrator (DBA)?

Accepted Answer

Managing and maintaining databases.

Answer

Training users on database usage.

Answer

Designing and implementing databases.

Answer

Writing SQL queries.

Question 38

Which of the following is NOT a component of a Database Management System (DBMS)?

Accepted Answer

Operating system

Answer

Query processor

Answer

Database engine

Question 39

What is the unique characteristic of a primary key in a database table?

Accepted Answer

A unique identifier for each record

Answer

A field used to filter the data

Answer

A field that contains the most important information

Answer

A field used to sort the data

Question 40

Which data model type represents data as a collection of objects and their relationships?

Accepted Answer

Object-oriented

Answer

Network

Answer

Hierarchical

Answer

Relational

Question 41

What is the main purpose of normalization in database design?

Accepted Answer

To eliminate data redundancy and inconsistencies

Answer

To reduce the size of the database

Answer

To make the database easier to maintain

Answer

To improve database performance

Question 42

Which of the following is an advantage of using a database over a spreadsheet for managing data?

Accepted Answer

Ability to handle large amounts of data efficiently

Answer

More flexible for data analysis

Answer

Easier to create and edit data

Question 43

Explain the fundamental difference between a view and a table in a database.

Accepted Answer

A view is a virtual table derived from one or more tables, while a table is a physical storage structure.

Answer

A view can be modified while a table cannot.

Question 44

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

Accepted Answer

SQL

Answer

Java

Answer

Python

Answer

HTML

Question 45

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

Accepted Answer

To improve performance by speeding up data retrieval

Answer

To store additional information about data

Answer

To ensure data integrity

Question 46

What is a key benefit of regularly backing up a database?

Accepted Answer

Protects data from loss due to hardware failure or data corruption

Answer

Makes data more easily accessible

Answer

Improves database performance

Question 47

What is the main function of a foreign key in a database?

Accepted Answer

To maintain referential integrity between tables

Answer

To identify the primary key of a table

Answer

To prevent duplicate data

Answer

To create a relationship between two tables

Question 48

Which of the following is NOT a benefit of using a database management system (DBMS)?

Accepted Answer

Increased data redundancy

Answer

Enhanced data security

Answer

Improved data consistency

Question 49

A relational database organizes data into:

Accepted Answer

Tables

Answer

Folders

Answer

Files

Answer

Networks

Question 50

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

Accepted Answer

Uniquely identifies each record in the table

Answer

Defines the data type of each column

Answer

Links the table to other tables

Answer

Stores the table's name

Question 51

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

Accepted Answer

SQL (Structured Query Language)

Answer

CSS (Cascading Style Sheets)

Answer

JavaScript

Answer

HTML (HyperText Markup Language)

Question 52

In a database, what is a 'field'?

Accepted Answer

A single piece of information within a record

Answer

The name of a table

Answer

A collection of related records

Answer

A set of instructions for accessing data

Question 53

A school wants to store student information in a database. Which of the following would be the most appropriate primary key for the 'Students' table?

Accepted Answer

Student ID number

Answer

Student's address

Answer

Student's grade level

Answer

Student's full name

Question 54

What is the purpose of a database schema?

Accepted Answer

To define the structure and relationships between tables in a database

Answer

To store the actual data in the database

Answer

To control access to the database

Question 55

Which of the following is an example of a data type commonly used in databases?

Accepted Answer

Text

Answer

Document

Answer

Image

Answer

Video

Question 56

A customer database stores information about customers, orders, and products. What type of relationship exists between the 'Customers' and 'Orders' tables?

Accepted Answer

One-to-many

Answer

No relationship

Answer

Many-to-many

Answer

One-to-one

Question 57

Which of the following is a popular DBMS used in many organizations?

Accepted Answer

MySQL

Answer

Photoshop

Answer

Word

Answer

Excel