Database Management Quizzes for Year 13 ICT Students

Question 1

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

Accepted Answer

Increased data complexity

Answer

Enhanced data integrity

Answer

Minimized data redundancy

Answer

Improved data accessibility

Question 2

Which SQL statement is used to retrieve only unique values from a specific column in a database table?

Accepted Answer

SELECT DISTINCT column_name FROM table_name

Answer

SELECT * FROM table_name

Answer

SELECT UNIQUE column_name FROM table_name

Answer

SELECT NOT NULL column_name FROM table_name

Question 3

Which SQL statement is used to modify data in an existing database table?

Accepted Answer

UPDATE

Answer

INSERT

Answer

DELETE

Question 4

What is a sign of a poorly designed database?

Accepted Answer

Data is scattered and lacks structure.

Accepted Answer

Tables contain unnecessary duplicate information.

Accepted Answer

Connections between tables are not defined or enforced.

Answer

The database structure is clear and understandable.

Question 5

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

Accepted Answer

Application program

Answer

Data dictionary

Answer

Query optimizer

Answer

Database engine

Question 6

Which of the following is a characteristic of a hierarchical database management system (HDBMS) but NOT a relational database management system (RDBMS)?

Accepted Answer

Data is stored in a hierarchical structure

Answer

Data is stored in tables with rows and columns

Answer

Relationships between data are explicitly defined and enforced

Answer

Data can be accessed and manipulated using a structured query language (SQL)

Question 7

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

Accepted Answer

Spreadsheet software

Answer

Data dictionary

Answer

Query optimizer

Question 8

Which data type is NOT supported by SQL?

Accepted Answer

List

Answer

Integer

Answer

String

Answer

Boolean

Question 9

Which component is NOT essential to a database management system (DBMS)?

Accepted Answer

User interface

Answer

Data dictionary

Answer

Query optimizer

Answer

Database engine

Question 10

Which component is NOT essential to a Database Management System (DBMS)?

Accepted Answer

Data visualization tool

Answer

Data dictionary

Answer

Query processor

Answer

Transaction manager

Question 11

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

Accepted Answer

Spreadsheet

Answer

Data dictionary

Answer

Query processor

Answer

Transaction manager

Question 12

Which of the following is NOT a database management system?

Accepted Answer

Spreadsheet

Answer

Relational Database Management System (RDBMS)

Answer

NoSQL Database Management System

Answer

Hierarchical Database Management System

Question 13

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

Accepted Answer

Ensures unique values across all records

Answer

Prevents null values from being entered

Answer

Improves data retrieval performance through indexing

Answer

Establishes relationships between tables through referential integrity

Question 14

Which of the following is **not** a fundamental component of a database management system (DBMS)?

Accepted Answer

Operating system

Answer

Data model

Answer

Query language

Answer

User interface

Question 15

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

Accepted Answer

To uniquely identify each row in the table

Answer

To establish a relationship with another table

Answer

To store additional information about a row

Answer

To enforce data integrity rules

Question 16

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

Accepted Answer

A column contains data of a specific type, while a row contains a set of related data.

Answer

A row contains data of a specific type, while a column contains a set of related data.

Answer

Columns and rows are interchangeable concepts.

Answer

Columns are used for data storage, while rows are used solely for data retrieval.

Question 17

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

Accepted Answer

To reduce data redundancy, improve data consistency, and enhance data integrity

Answer

To increase the overall size of the database

Answer

To make the database easier to query and retrieve data

Answer

To improve the performance of the database

Question 18

What is the fundamental difference between a SELECT statement and an UPDATE statement in SQL?

Accepted Answer

SELECT retrieves data from the database, while UPDATE modifies existing data.

Answer

UPDATE retrieves data from the database, while SELECT modifies existing data.

Answer

SELECT and UPDATE both retrieve data from the database.

Answer

SELECT and UPDATE both modify existing data in the database.

Question 19

Which data type in SQL is specifically designed to store text-based data?

Accepted Answer

VARCHAR

Answer

INT

Answer

FLOAT

Answer

DATE

Question 20

Which data model represents data as objects with interconnected relationships?

Accepted Answer

Object-oriented model

Answer

Relational model

Answer

Hierarchical model

Answer

Network model

Question 21

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

Accepted Answer

To uniquely identify each record in a table

Answer

To guarantee data consistency

Answer

To store the most important data in each record

Answer

To link tables together using foreign keys

Question 22

Which of the following is NOT a Structured Query Language (SQL) command used to modify data in a database?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 23

Which of the following is a common cyber threat targeting databases?

Accepted Answer

SQL injection attacks

Answer

Cross-site scripting (XSS)

Answer

Phishing

Answer

Man-in-the-middle attacks

Question 24

Which of the following is a widely used open-source relational database management system?

Accepted Answer

MySQL

Answer

Oracle

Answer

SQL Server

Answer

IBM DB2

Question 25

In a database table, the primary key is a field that:

Accepted Answer

Uniquely identifies each record

Answer

Contains the most critical information

Answer

Arranges the table entries in a specific order

Answer

Connects the table to other databases

Question 26

Which of the following is NOT a standard database model type?

Accepted Answer

Flat-file

Answer

Hierarchical

Answer

Network

Answer

Relational

Question 27

A SQL query primarily serves to:

Accepted Answer

Retrieve data from databases

Answer

Create new databases

Answer

Modify data within databases

Answer

Delete data from databases

Question 28

Which of the following database types is a NoSQL database?

Accepted Answer

MongoDB

Answer

MySQL

Answer

Oracle

Answer

SQL Server

Question 29

A clustered index differs from a non-clustered index in that it:

Accepted Answer

Physically arranges data in the table, unlike a non-clustered index

Answer

Logically organizes data in the table, unlike a clustered index

Answer

Improves data retrieval speed, unlike a non-clustered index

Answer

Maintains data integrity, unlike a non-clustered index

Question 30

A database schema is designed to:

Accepted Answer

Define a database's structure

Answer

Store data within a database

Answer

Query data from a database

Answer

Control user access and permissions

Question 31

In SQL, which type of join combines rows from two tables based on matching values?

Accepted Answer

INNER JOIN

Answer

LEFT JOIN

Answer

RIGHT JOIN

Answer

FULL JOIN

Question 32

Which data type is most suitable for storing a list of items?

Accepted Answer

Array

Answer

Integer

Answer

String

Answer

Boolean

Question 33

Which database model is most appropriate for representing data that is organized in a hierarchical structure?

Accepted Answer

Hierarchical

Answer

Relational

Answer

Network

Answer

Object-oriented

Question 34

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

Accepted Answer

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

Answer

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

Answer

There is no distinction between a primary key and a foreign key.

Answer

A primary key must always be a foreign key.

Question 35

What is the purpose of a data dictionary?

Accepted Answer

To define and document database objects

Answer

To store data values

Answer

To enforce data integrity

Answer

To optimize database performance

Question 36

Which option is not a recognised database model?

Accepted Answer

Procedural model

Answer

Hierarchical model

Answer

Network model

Answer

Object-relational model

Question 37

What is the primary key of a table?

Accepted Answer

A field that uniquely identifies each row

Answer

A field that is used to join the table with other tables

Answer

The first field in the table

Answer

A field that is not allowed to contain null values

Question 38

Which SQL statement is used to create a table?

Accepted Answer

CREATE

Answer

SELECT

Answer

INSERT

Answer

UPDATE

Question 39

What is the primary purpose of a foreign key?

Accepted Answer

To enforce referential integrity between tables

Answer

To store additional information about a row

Answer

To create a relationship between two tables

Answer

To index a table for faster searching

Question 40

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

Accepted Answer

To speed up data retrieval

Answer

To enforce data integrity

Answer

To store additional information about a row

Answer

To create a relationship between two tables

Question 41

Which of the following is NOT a key concept in database management systems?

Accepted Answer

Web server configuration

Answer

Data modeling

Answer

Database design

Answer

Database querying

Question 42

Which database type is specifically designed to manage vast amounts of unstructured data?

Accepted Answer

NoSQL database

Answer

Relational database

Answer

Object-oriented database

Answer

Cloud database

Question 43

Which SQL command is used to retrieve data from a database?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 44

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

Accepted Answer

To uniquely identify each record in a table

Answer

To link records between tables

Answer

To store the most important data in a table

Answer

To ensure data integrity

Question 45

In the context of a relational database, what is the primary purpose of a primary key?

Accepted Answer

To uniquely identify each row in a table

Answer

To store the data of the row

Answer

To establish relationships between tables

Answer

To enforce data integrity

Question 46

What is the fundamental distinction between a structured query language (SQL) and a non-procedural language?

Accepted Answer

SQL focuses on data manipulation, while a non-procedural language focuses on defining data structures.

Answer

SQL focuses on defining data structures, while a non-procedural language focuses on data manipulation.

Answer

Both SQL and non-procedural languages are primarily used for data manipulation.

Answer

Both SQL and non-procedural languages are primarily used for defining data structures.

Question 47

What is the distinction between a primary key and a foreign key in a database?

Accepted Answer

A primary key uniquely identifies a row in a table, while a foreign key references a primary key in another table.

Answer

A foreign key uniquely identifies a row in a table, while a primary key references a foreign key in another table.

Answer

A primary key and a foreign key are essentially the same concept.

Question 48

In database management, which technique organizes related data into logical groups to reduce redundancy and enhance data reliability?

Accepted Answer

Data Normalization

Answer

Data Fragmentation

Answer

Data Denormalization

Question 49

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

Accepted Answer

To uniquely identify each record in a table

Answer

To ensure data integrity

Answer

To speed up data retrieval

Answer

To store the most important data

Question 50

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

Accepted Answer

To enforce referential integrity

Answer

To link data between tables

Answer

To ensure data consistency

Answer

To create a unique identifier

Question 51

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

Accepted Answer

Increased data redundancy

Answer

Improved data security

Answer

Efficient data storage and retrieval

Answer

Enhanced data accuracy

Question 52

What is the key objective of normalization in database design?

Accepted Answer

To reduce data redundancy

Answer

To eliminate data inconsistencies

Answer

To improve data retrieval performance

Answer

To enhance data security

Question 53

What is the fundamental difference between a structured query language (SQL) and a non-procedural language?

Accepted Answer

SQL is declarative, while a non-procedural language is procedural.

Answer

SQL is procedural, while a non-procedural language is declarative.

Answer

SQL is more efficient than a non-procedural language.

Answer

SQL is less powerful than a non-procedural language.

Question 54

Which of the following is not typically considered a core component of a Database Management System (DBMS)?

Accepted Answer

Operating system

Answer

Data dictionary

Answer

Query processor

Answer

Data storage

Question 55

The purpose of a data model is to represent:

Accepted Answer

The structure and relationships of data

Answer

The physical storage of data

Answer

The access control mechanisms for data

Answer

The integrity constraints for data

Question 56

Which SQL command is primarily used to retrieve data from a database?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 57

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

Accepted Answer

Operating system

Answer

Data definition language (DDL)

Answer

Data dictionary

Answer

Database engine

Question 58

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

Accepted Answer

Object-oriented model

Answer

Hierarchical model

Answer

Network model

Answer

Relational model

Question 59

What is a primary purpose of normalization in database design?

Accepted Answer

To eliminate data redundancy and ensure data integrity

Answer

To improve database query performance

Answer

To simplify data updates

Answer

To enhance data security

Question 60

Which SQL command is used to retrieve data from a database table?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 61

What is the key difference between a primary key and a foreign key in a relational database?

Accepted Answer

A primary key uniquely identifies each row in a table, while a foreign key references the primary key of another table.

Answer

A foreign key identifies each row uniquely, while a primary key references a foreign key.

Question 62

Which type of database is best suited for storing and managing large volumes of structured data, such as customer records or financial transactions?

Accepted Answer

Relational database

Answer

Document database

Answer

Graph database

Answer

Key-value database

Question 63

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

Accepted Answer

To accelerate data retrieval by providing a faster search mechanism

Answer

To enforce data integrity

Question 64

What is the primary function of a transaction in a database system?

Accepted Answer

To ensure the reliability and consistency of data modifications by grouping them into logical units

Answer

To provide data backup and recovery