Database Management Quizzes for Year 13 ICT Students

Question 1

Which of the following is **not** a primary key constraint in a relational database?

Accepted Answer

FOREIGN KEY

Answer

UNIQUE

Answer

NOT NULL

Answer

PRIMARY KEY

Question 2

What is the primary purpose of a referential integrity constraint in a relational database?

Accepted Answer

To ensure that data in one table is consistent with related data in another table

Answer

To prevent duplicate records from being inserted into a table

Answer

To automatically update data in one table when data is updated in another related table

Answer

To create a relationship between two tables without enforcing data consistency

Question 3

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

Accepted Answer

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

Answer

A primary key is always unique, while a foreign key is not

Answer

A foreign key can reference multiple rows in another table, while a primary key cannot

Answer

None of the above options correctly describe the primary difference

Question 4

Which of the following is **not** a responsibility of a database administrator (DBA)?

Accepted Answer

Performing data entry into the database

Answer

Ensuring the security and performance of a database

Answer

Designing and implementing databases

Answer

Training users on how to use a database

Question 5

What is the purpose of a data dictionary in a database management system?

Accepted Answer

To store information about the structure of the database

Answer

To store data itself

Answer

To provide a user interface for accessing the database

Answer

To optimize the performance of queries

Question 6

Which of the following is a key principle of data integrity?

Accepted Answer

Data consistency and accuracy

Answer

Data protection from unauthorized access

Answer

Regular data backups

Answer

Centralized data storage

Question 7

Which database model is most suitable for representing complex relationships between entities?

Accepted Answer

Entity-Relationship

Answer

Hierarchical

Answer

Network

Answer

Relational

Question 8

Which of the following is a normalization technique used in database design?

Accepted Answer

Decomposition

Answer

Denormalization

Answer

Aggregation

Answer

Duplication

Question 9

In the context of database management systems (DBMS), which of the following is NOT a recognized advantage?

Accepted Answer

Increased data inconsistency and unreliability

Answer

Centralized data storage and management for enhanced accessibility

Answer

Improved data security through access controls and encryption

Answer

Reduced data redundancy, minimizing inconsistencies

Question 10

Which characteristic is crucial for ensuring data accuracy and consistency in a database?

Accepted Answer

Integrity

Answer

Security

Answer

Performance

Answer

Accessibility

Question 11

Which of the following measures is not primarily considered a data security practice?

Accepted Answer

Data deduplication

Answer

Data encryption

Answer

User authentication

Answer

Input validation

Question 12

Which database type is optimal for handling massive volumes of unstructured data, such as text, images, and videos?

Accepted Answer

NoSQL database

Answer

Relational database

Answer

Object-oriented database

Answer

Hierarchical database

Question 13

Which of the following tasks encompasses a wide range of responsibilities related to database management, including design, implementation, maintenance, and recovery?

Accepted Answer

Database administration

Answer

Data analytics

Answer

Software development

Answer

Network administration

Question 14

Which primary benefit of utilizing a query optimizer is most significant?

Accepted Answer

Enhanced query execution speed

Answer

Reduced hardware resource consumption

Answer

Improved data security

Answer

Simplified database management

Question 15

In the context of relational databases, which integrity constraint enforces a unique relationship between rows in different tables, ensuring data consistency?

Accepted Answer

Foreign key

Answer

Primary key

Answer

Unique constraint

Answer

Check constraint

Question 16

Which type of SQL statement is employed to define the structure of a database, including creating tables, modifying schemas, or altering data types?

Accepted Answer

ALTER TABLE

Answer

DELETE

Answer

JOIN

Answer

GRANT

Question 17

Which data model best represents data that has a hierarchical structure, such as family trees or organizational charts?

Accepted Answer

Hierarchical model

Answer

Relational model

Answer

Network model

Answer

Object-oriented model

Question 18

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

Accepted Answer

To ensure that each row in the table is uniquely identified

Answer

To establish relationships between tables

Answer

To store the most important data in the table

Answer

To limit the number of rows in the table

Question 19

How does logical database design differ from physical database design?

Accepted Answer

Logical design focuses on data structures and relationships, while physical design focuses on data storage and organization

Answer

Physical design focuses on data structures and relationships, while logical design focuses on data storage and organization

Answer

Logical design is specific to a particular DBMS, while physical design is independent of any DBMS

Answer

There is no difference between logical and physical database design

Question 20

Which of the following is a potential drawback of using a database?

Accepted Answer

Increased data redundancy

Answer

Improved data integrity

Answer

Enhanced data security

Answer

Easier data access

Question 21

Which type of database management system (DBMS) is best suited for handling vast, unstructured datasets?

Accepted Answer

NoSQL DBMS

Answer

Relational DBMS

Answer

Hierarchical DBMS

Answer

Network DBMS

Question 22

What is the primary purpose of a primary key constraint?

Accepted Answer

Ensuring that each record in a table has a unique identifier

Answer

Enforcing data integrity by preventing duplicate entries

Answer

Restricting access to specific rows in a table

Answer

Maintaining the order of rows in a table

Question 23

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

Accepted Answer

Managing and maintaining database systems

Answer

Designing and implementing databases

Answer

Developing database applications

Answer

Training users on database usage

Question 24

Which constraint ensures that all values in a column are unique, identifying each record?

Accepted Answer

Primary key constraint

Answer

Unique constraint

Answer

Foreign key constraint

Answer

Not null constraint

Question 25

Which database model represents data as a tree-like structure, with each node having at most one parent?

Accepted Answer

Hierarchical model

Answer

Network model

Answer

Relational model

Answer

Object-oriented model

Question 26

Which function involves managing and coordinating access to data in a database, ensuring data security and integrity?

Accepted Answer

Database administration

Answer

Database design

Answer

Database maintenance

Answer

Data analysis

Question 27

Which type of data security threat involves unauthorized individuals gaining access to confidential information?

Accepted Answer

Data breach

Answer

Malware attack

Answer

Phishing attack

Answer

Data manipulation

Question 28

Which backup method involves creating a copy of only the data that has changed since the last backup?

Accepted Answer

Incremental backup

Answer

Full backup

Answer

Differential backup

Answer

Mirroring

Question 29

Which type of database query retrieves a subset of data from a table based on specified criteria?

Accepted Answer

Select query

Answer

Update query

Answer

Insert query

Answer

Delete query

Question 30

Which database optimization technique involves creating an index on a column to improve the speed of data retrieval?

Accepted Answer

Indexing

Answer

Normalization

Answer

Caching

Answer

Query optimization

Question 31

Which component of a database management system handles the execution of user queries?

Accepted Answer

Query processor

Answer

Storage manager

Answer

Transaction manager

Answer

Security manager

Question 32

Which characteristic describes a database design that eliminates data redundancy and ensures data consistency?

Accepted Answer

Normalized

Answer

Secure

Answer

Optimized

Answer

Flexible

Question 33

Which constraint uniquely identifies each row in a table in a database?

Accepted Answer

PRIMARY KEY

Answer

NOT NULL

Answer

UNIQUE

Answer

DEFAULT

Question 34

What is the primary purpose of utilizing foreign key constraints in database management?

Accepted Answer

Ensuring data consistency across multiple tables

Answer

Preventing duplicate data entries within a single table

Answer

Automatically generating unique values for table columns

Answer

Limiting the length of data stored in specific columns

Question 35

What fundamental distinction exists between a flat file database and a relational database in terms of data organization?

Accepted Answer

Relational databases establish logical connections between tables, a feature absent in flat file databases.

Answer

Flat file databases employ multiple files for data storage, unlike relational databases which utilize a single file.

Answer

Flat file databases exhibit superior efficiency compared to relational databases.

Answer

Relational databases offer enhanced security measures when compared to flat file databases.

Question 36

What is the primary purpose of defining a database schema?

Accepted Answer

Encompassing all of the above aspects

Answer

Establishing the structure and organization of a database

Answer

Specifying data types and formats for each column

Answer

Defining relationships and connections between different tables

Question 37

What is the fundamental purpose of utilizing joins in SQL?

Accepted Answer

Combining rows from multiple tables based on specified criteria

Answer

Filtering and selecting specific rows from a single table

Answer

Sorting rows within a table in a particular order

Answer

Deleting rows from a table that meet certain conditions

Question 38

Which of the following is not considered a potential security risk associated with databases?

Accepted Answer

Unavailability of data due to technical issues

Answer

Unauthorized access to sensitive data

Answer

Potential loss of valuable data due to system failures

Answer

Intentional or accidental data corruption

Question 39

What are the advantages of using a database management system (DBMS)?

Accepted Answer

Improved data integrity

Accepted Answer

Increased data security

Accepted Answer

Reduced data redundancy

Answer

Increased data complexity

Question 40

Which of the following is a disadvantage of using a relational database management system (RDBMS)?

Accepted Answer

Data redundancy

Answer

Data consistency

Answer

Data security

Answer

Data independence

Question 41

Which database management system organizes data in a hierarchical structure?

Accepted Answer

Hierarchical database management system

Answer

Relational database management system

Answer

Network database management system

Answer

Object-oriented database management system

Question 42

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

Accepted Answer

Spreadsheet software

Answer

Relational DBMS

Answer

Object-oriented DBMS

Answer

NoSQL DBMS

Question 43

Which data type is most suitable for storing a student's date of birth?

Accepted Answer

Date

Answer

Integer

Answer

Float

Answer

Boolean

Question 44

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

Accepted Answer

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

Answer

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

Answer

Both primary and foreign keys uniquely identify each record in a table.

Answer

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

Question 45

What is the purpose of using a join in a SQL query?

Accepted Answer

To retrieve data from multiple tables based on a common field

Answer

To insert data into a table

Answer

To update data in a table

Answer

To delete data from a table

Question 46

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

Accepted Answer

Object-oriented Programming Language (OOPL)

Answer

Relational DBMS

Answer

Hierarchical DBMS

Answer

Graph DBMS

Question 47

Which of the following is NOT a type of data integrity rule?

Accepted Answer

Optimistic concurrency

Answer

Data consistency

Answer

Referential integrity

Answer

Primary key integrity

Question 48

What is the primary purpose of a database schema?

Accepted Answer

To define the structure and constraints of a database.

Answer

To provide a graphical representation of the database.

Answer

To store data in a structured format.

Question 49

Which of the following database models depicts data as a network of interconnected entities?

Accepted Answer

Network model

Answer

Relational model

Answer

Object-oriented model

Answer

Flat model

Question 50

Which of the following responsibilities is most closely associated with a database administrator?

Accepted Answer

Monitoring database performance and adjusting as required.

Answer

Writing and executing SQL queries on behalf of users.

Answer

Designing and implementing new databases.

Question 51

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

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 is always a unique constraint, while a primary key is not.

Question 52

Which of the following is a key benefit of using a transaction?

Accepted Answer

It ensures that multiple database operations are either all completed or none are completed, preserving data integrity.

Answer

It speeds up database operations by eliminating the need for locking mechanisms.

Answer

It allows users to access the database concurrently without any data conflicts.

Question 53

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

Accepted Answer

To enhance data retrieval speed by providing a direct path to data based on specific criteria.

Answer

To ensure that all data in the database is stored in a consistent format.

Answer

To secure the database against unauthorized access.

Question 54

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

Accepted Answer

Eliminating the need for data backup and recovery procedures.

Answer

Enforcing data integrity and consistency.

Answer

Providing efficient data access and retrieval.

Question 55

What is the main purpose of a data dictionary?

Accepted Answer

To store metadata about the database, including table definitions and user permissions.

Answer

To provide a graphical interface for managing the database.

Answer

To log all changes made to the database.

Question 56

Which of the following is considered a best practice for database security?

Accepted Answer

Implementing user authentication and authorization mechanisms.

Answer

Storing all database data in plain text format.

Answer

Allowing unrestricted access to the database.