Database Management Quizzes for Year 12 ICT Students

Question 1

Which of the following is an invalid type of database relationship?

Accepted Answer

One-to-none

Answer

One-to-one

Answer

One-to-many

Answer

Many-to-many

Question 2

Which of the following commands is NOT used to modify data in a relational database management system (RDBMS)?

Accepted Answer

FETCH

Answer

INSERT

Answer

DELETE

Answer

UPDATE

Question 3

Which type of database relationship is described below?

Each department can have multiple employees assigned to it, while each employee can only be assigned to one department.

Accepted Answer

One-to-many

Answer

One-to-one

Answer

Many-to-many

Answer

Hierarchical

Question 4

Which of these is NOT a basic data type in SQL?

Accepted Answer

List

Answer

Integer

Answer

Boolean

Answer

String

Question 5

What is a defining feature of a relational database management system (RDBMS)?

Accepted Answer

Relational data model

Answer

Hierarchical data model

Answer

Network data model

Answer

Object-oriented data model

Question 6

Which of the following is not a fundamental data type in SQL?

Accepted Answer

Array

Answer

Integer

Answer

String

Answer

Boolean

Question 7

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

Accepted Answer

Application Server

Answer

Database

Answer

Query Processor

Answer

Transaction Manager

Question 8

Which data type is not supported by SQL?

Accepted Answer

Array

Answer

Integer

Answer

String

Answer

Date

Question 9

Which SQL data type stores whole numbers (without decimal places)?

Accepted Answer

INTEGER

Answer

FLOAT

Answer

VARCHAR

Answer

BOOLEAN

Question 10

In database management, what is the primary purpose of a Data Definition Language (DDL) statement?

Accepted Answer

Create or modify the structure of a database table

Answer

Retrieve data from a database table

Answer

Update data within a database table

Answer

Grant permissions to users on a database object

Question 11

In SQL, which data type is NOT used to store numbers?

Accepted Answer

String

Answer

Integer

Answer

Boolean

Question 12

Which of the following is NOT a valid relationship type in a relational database schema?

Accepted Answer

All-to-all

Answer

One-to-one

Answer

One-to-many

Answer

Many-to-many

Question 13

Which constraint prevents duplicate values in a specific column of a database table?

Accepted Answer

Unique

Answer

Not Null

Answer

Primary

Answer

Foreign

Question 14

Which of the following describes the defining characteristic of a One-to-Many database relationship?

Accepted Answer

A parent record can have multiple child records, while a child record can only have one parent record.

Answer

A child record can have multiple parent records, while a parent record can only have one child record.

Answer

Parent and child records can have multiple relationships with each other.

Question 15

What is a defining characteristic of a primary key constraint in a database?

Accepted Answer

Ensures unique values in a specified column

Answer

Prevents null values in a specified column

Answer

Establishes a connection between two tables

Question 16

Which data type is not supported in SQL?

Accepted Answer

LIST

Answer

INTEGER

Answer

FLOAT

Answer

CHARACTER

Question 17

Within a Database Management System (DBMS), which component is crucial for optimizing database queries?

Accepted Answer

Query Optimizer

Answer

Data Definition Language (DDL)

Answer

Database Administrator

Question 18

In SQL, which syntax is correct for creating a new table with specific column names and data types?

Accepted Answer

CREATE TABLE table_name (column_name data_type);

Answer

TABLE table_name (column_name data_type);

Answer

CREATE TABLE table_name AS SELECT * FROM another_table;

Question 19

Which of the following SQL statements correctly creates a table named 'Customers' with three columns: 'CustomerID' (primary key), 'CustomerName', and 'ContactNumber'?

Accepted Answer

CREATE TABLE Customers (CustomerID INT NOT NULL PRIMARY KEY, CustomerName VARCHAR(255), ContactNumber VARCHAR(255))

Answer

CREATE TABLE Customers (CustomerID INT, CustomerName VARCHAR, ContactNumber VARCHAR)

Answer

CREATE Customers (CustomerID INT PRIMARY KEY, CustomerName VARCHAR(255), ContactNumber VARCHAR(255))

Answer

CREATE TABLE Customers (CustomerID INT NOT NULL, CustomerName VARCHAR(255) PRIMARY KEY, ContactNumber VARCHAR(255))

Question 20

Which SQL command is used to retrieve specific data rows from a table based on a given condition?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Question 21

Which field in a database table is unique to each row?

Accepted Answer

Primary key

Answer

Foreign key

Answer

Unique key

Answer

Composite key

Question 22

In SQL, which data type is most appropriate for storing a customer's address, and why?

Accepted Answer

VARCHAR

Answer

INTEGER

Answer

CHARACTER

Question 23

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

Accepted Answer

Object

Answer

Table

Answer

Index

Answer

Query

Question 24

In SQL, what is the main function of the Data Definition Language (DDL)?

Accepted Answer

To define and alter the structure of a database

Answer

To access and manipulate data in database tables

Answer

To control user permissions and access rights in a database system

Question 25

Which of the following is an invalid data type in SQL?

Accepted Answer

ARRAY

Answer

INTEGER

Answer

CHAR

Answer

BOOLEAN

Question 26

Which database structure organizes data into tables, where each table has rows and columns, with each column representing a specific feature of the data?

Accepted Answer

Relational Database

Answer

Hierarchical Database

Answer

Network Database

Answer

Flat File Database

Question 27

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

Accepted Answer

Compiling and executing high-level programming languages

Answer

Managing and organizing data in a structured manner

Answer

Providing security measures to protect data from unauthorized access

Answer

Performing data backup and recovery operations

Question 28

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

Accepted Answer

Excel

Answer

Oracle

Answer

MySQL

Answer

PostgreSQL

Question 29

What is the main purpose of referential integrity in a database?

Accepted Answer

To keep data consistent between linked tables

Answer

To limit which users can see certain data

Answer

To make the database faster and more efficient

Question 30

In SQL's Data Definition Language (DDL), what's the primary purpose of the ALTER TABLE statement?

Accepted Answer

Add, change, or remove columns in an existing table.

Answer

Create a new table in the database.

Answer

Delete specific rows from a table.

Question 31

In SQL, what is the primary purpose of the `UPDATE` command?

Accepted Answer

Modify existing data in a table

Answer

Create a new table

Answer

Retrieve specific rows from a table based on a condition

Answer

Modify the structure of an existing table

Question 32

Which database model stores data in tables, with each table consisting of rows and columns that represent specific data attributes?

Accepted Answer

Relational model

Answer

Network model

Answer

Hierarchical model

Answer

Object-oriented model

Question 33

In SQL's Data Definition Language (DDL), what is the primary purpose of the `CREATE TABLE` statement?

Accepted Answer

Create a new table with a defined structure and constraints

Answer

Modify an existing table's structure or data

Answer

Delete an existing table

Answer

Insert data into an existing table

Question 34

Which database structure is best suited for storing large amounts of unstructured data, like text documents or images?

Accepted Answer

NoSQL

Answer

Relational

Answer

Hierarchical

Answer

Object-Oriented

Question 35

In SQL, which clause is used to select specific columns from a database table?

Accepted Answer

SELECT

Answer

FROM

Answer

WHERE

Answer

ORDER BY

Question 36

Which of the following database relationships requires an additional table to implement using foreign keys?

Accepted Answer

Many-to-many

Answer

One-to-one

Answer

One-to-many

Question 37

In database design, which concept ensures that connections between tables are clearly defined and remain consistent?

Accepted Answer

Referential Integrity

Answer

Data Normalization

Question 38

To ensure data consistency, which database constraint is used to enforce that the value of a column in Table A must match the value of a column in Table B?

Accepted Answer

FOREIGN KEY constraint

Answer

PRIMARY KEY constraint

Answer

UNIQUE constraint

Question 39

Which of the following is not a valid data type in SQL?

Accepted Answer

Array

Answer

Integer

Answer

String

Answer

Date

Question 40

What is essential for ensuring data accuracy and consistency when designing a database?

Accepted Answer

Normalizing data

Answer

Allowing duplicate entries

Answer

Storing data in multiple tables

Answer

Using a single data type for all fields

Question 41

What is database security? Describe three different ways to implement it.

Accepted Answer

Database security protects databases from unauthorized access, changes, or destruction. Common security measures include access controls, encryption, and backups.

Answer

Database security only prevents unauthorized access to data.

Answer

Encryption is the only effective security measure for databases.

Answer

Database security is not a concern for small databases.

Question 42

What is database recovery? Describe the various techniques used to recover data in case of loss or corruption.

Accepted Answer

Database recovery involves restoring the database to a consistent state after a failure, using techniques like transaction logs, backups, and checkpoints.

Answer

Database recovery solely relies on restoring data from backups, without employing other techniques.

Answer

Database recovery is unnecessary as data is automatically restored in the event of a failure.

Answer

Database recovery exclusively utilizes checkpoints, excluding all other techniques.

Question 43

How do data warehousing and data mining contribute to business intelligence and decision-making?

Accepted Answer

Data warehousing centralizes data from various sources, while data mining analyzes it to uncover valuable insights.

Answer

Data mining centralizes data from various sources, while data warehousing analyzes it to uncover valuable insights.

Answer

Data warehousing and data mining have overlapping roles in data storage and analysis, but they do not contribute to decision-making.

Answer

Data mining creates data models, while data warehousing manages data.

Question 44

Discuss the challenges associated with data privacy, data quality, and data security in the context of big data management.

Accepted Answer

Data privacy concerns relate to the collection and use of personal information without individuals' consent.

Answer

Big data management primarily involves data storage and retrieval without significant ethical implications.

Answer

Data quality is not a significant issue in big data management, as the sheer volume of data compensates for inaccuracies.

Question 45

Which database transaction property ensures that all changes within a transaction are either fully committed or fully rolled back, preventing partial updates?

Accepted Answer

Atomicity

Answer

Consistency

Answer

Isolation

Answer

Durability

Question 46

Which among the following is NOT a component of a database management system (DBMS)?

Accepted Answer

Network switch

Answer

Database engine

Answer

Query processor

Answer

Application programming interface (API)

Question 47

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 important data in the table

Answer

To link the table to other tables in the database

Answer

To enforce data integrity

Question 48

Which of the following data types is used to store text strings in a database?

Accepted Answer

Character

Answer

Integer

Answer

Boolean

Answer

Float

Question 49

What is the main purpose of a SELECT statement in SQL?

Accepted Answer

To retrieve data from a database

Answer

To insert data into a database

Answer

To update data in a database

Answer

To delete data from a database

Question 50

Which of the following operators is used to compare two values in a SQL WHERE clause?

Accepted Answer

=

Answer

>

Answer

&

Answer

%

Question 51

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

Accepted Answer

To manage and maintain the database

Answer

To design and implement database systems

Answer

To write SQL queries for users

Answer

To provide customer support for database users

Question 52

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

Accepted Answer

To enforce referential integrity

Answer

To link the table to other tables in the database

Answer

To identify the primary key of the table

Answer

To store metadata about the table

Question 53

What is the primary purpose of implementing robust database security measures?

Accepted Answer

To protect sensitive data from unauthorized access and breaches

Answer

To comply with industry regulations and standards

Answer

To improve database performance and efficiency

Answer

To facilitate easy data sharing among multiple users

Question 54

What is the main responsibility of database administrators (DBAs) in a database management system?

Accepted Answer

Managing user access, security, and performance

Answer

Designing and creating database structures

Answer

Executing SQL queries

Question 55

When designing a database system, which factor is crucial for ensuring scalability and performance?

Accepted Answer

Data normalization

Answer

Denormalization

Answer

Eliminating indexing

Question 56

Identify the primary disadvantage associated with database normalization:

Accepted Answer

Increased database complexity

Answer

Reduction in data redundancy

Answer

Enhancement of data integrity

Answer

Requirement for additional storage space

Question 57

Which of these is a crucial ethical principle in managing data?

Accepted Answer

Preserving data privacy

Answer

Storing data indefinitely

Answer

Collecting data without individuals' consent

Answer

Using data for discriminatory purposes

Question 58

A primary key in a database is a field that:

Accepted Answer

Uniquely identifies each row in a table

Answer

Can be null or contain duplicate values

Answer

Is required for querying the database

Answer

Is used for indexing purposes

Question 59

Which of the following SQL data types is used to store dates and times?

Accepted Answer

DATETIME

Answer

INT

Answer

VARCHAR

Answer

CHAR

Question 60

To create a new table in SQL, which command should be used?

Accepted Answer

CREATE TABLE

Answer

INSERT INTO

Answer

SELECT *

Answer

UPDATE

Question 61

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

Accepted Answer

To enforce referential integrity between tables

Answer

To create a unique index on a field

Answer

To improve query performance

Answer

To prevent duplicate data entries

Question 62

What is the key distinction between a primary key and a candidate key?

Accepted Answer

A primary key is unique and enforced by the DBMS, while a candidate key is not

Answer

A candidate key can be composite, but a primary key cannot

Answer

A primary key is used for indexing, while a candidate key is not

Answer

There is no difference between a primary key and a candidate key

Question 63

Which database system function ensures the accuracy and consistency of data in a database?

Accepted Answer

Transaction Management

Answer

Data Definition Language (DDL)

Answer

Data Manipulation Language (DML)

Answer

Query Optimization

Question 64

Which of the following data types is not supported by SQL?

Accepted Answer

JAVASCRIPT

Answer

CHAR

Answer

INT

Answer

BLOB