Database Management Systems Quizzes for Sixth Form College Year 13

Question 1

In a relational database, what uniquely identifies each row in a table?

Accepted Answer

A primary key

Answer

A foreign key

Answer

A unique index

Answer

A composite key

Question 2

What is the purpose of a database normalization process?

Accepted Answer

To remove data redundancy and inconsistencies, improving data integrity

Answer

To improve database performance

Answer

To secure the database from unauthorized access

Answer

To simplify database design

Question 3

What is the difference between a conceptual data model and a logical data model?

Accepted Answer

Conceptual data model represents a high-level, abstract view of the data, while logical data model represents a more detailed, implementation-oriented view

Answer

Logical data model represents a high-level, abstract view of the data, while conceptual data model represents a more detailed, implementation-oriented view

Answer

They are the same thing

Answer

They are not related

Question 4

Which of the following is NOT a transaction control command in SQL?

Accepted Answer

SELECT

Answer

COMMIT

Answer

ROLLBACK

Answer

SAVEPOINT

Question 5

Which data model represents data as a collection of interrelated objects?

Accepted Answer

Object-oriented

Answer

Relational

Answer

Hierarchical

Answer

Network

Question 6

Which query language is specifically designed for managing and manipulating data in relational databases?

Accepted Answer

SQL

Answer

XML

Answer

HTML

Answer

Python

Question 7

Which database architecture involves a centralized database that is accessed by multiple users?

Accepted Answer

Centralized

Answer

Decentralized

Answer

Distributed

Answer

Cloud-based

Question 8

Which database index structure organizes data in a balanced binary tree?

Accepted Answer

B-tree

Answer

Hash

Answer

Bitmap

Answer

Inverted list

Question 9

Which database security measure involves converting data into a form that cannot be easily understood by unauthorized individuals?

Accepted Answer

Data encryption

Answer

Access control

Answer

Audit trails

Answer

Data backups

Question 10

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

Accepted Answer

To uniquely identify each row

Answer

To reference another table

Answer

To group similar rows together

Answer

To store calculated values

Question 11

Which normalization form ensures that all data dependencies are directly related to the primary key?

Accepted Answer

Third normal form

Answer

First normal form

Answer

Second normal form

Answer

Boyce-Codd normal form

Question 12

Which SQL statement modifies existing data in a table?

Accepted Answer

UPDATE

Answer

SELECT

Answer

INSERT

Answer

DELETE

Question 13

Which of the following is an open-source database management system?

Accepted Answer

MySQL

Answer

Oracle

Answer

Microsoft SQL Server

Answer

IBM DB2

Question 14

Which characteristic is unique to the relational data model?

Accepted Answer

Data is organized into tables composed of rows and columns

Answer

Relationships between data items are defined using pointers

Answer

Data is stored in a hierarchical structure

Answer

Records are accessed using foreign keys

Question 15

What is the primary distinction 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 a different table

Answer

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

Answer

Both primary keys and foreign keys are used to establish relationships between tables

Answer

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

Question 16

Which Structured Query Language (SQL) command is used to retrieve data from a database?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 17

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

Accepted Answer

To enhance query performance by enabling faster data retrieval

Answer

To maintain data integrity by ensuring data validity

Answer

To organize data in a specific order for efficient sorting

Answer

To reduce storage space by compressing data

Question 18

Which database architecture involves distributing data and processing across multiple interconnected computers?

Accepted Answer

Distributed architecture

Answer

Centralized architecture

Answer

Client-server architecture

Answer

Peer-to-peer architecture

Question 19

What is the primary function of a database schema?

Accepted Answer

To define the structure and organization of a database

Answer

To store the actual data contained in the database

Answer

To provide a mechanism for accessing and manipulating data

Answer

To enforce data integrity and consistency

Question 20

Which of the following is NOT a benefit of query optimization?

Accepted Answer

Guaranteed data accuracy

Answer

Faster query execution

Answer

Efficient resource usage

Question 21

Which data integrity constraint prevents a column from containing empty values?

Accepted Answer

NOT NULL

Answer

DEFAULT

Answer

UNIQUE

Answer

PRIMARY KEY

Question 22

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

Accepted Answer

To uniquely identify each row in a table

Answer

To store the most important data in the table

Answer

To link the table to other tables

Answer

To ensure data integrity

Question 23

What is the primary role of a query language in a database management system?

Accepted Answer

Retrieving data from the database

Answer

Creating and modifying databases

Answer

Inserting, updating, and deleting data

Answer

Controlling user access to the database

Question 24

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

Accepted Answer

To ensure referential integrity between tables

Answer

To establish a relationship between two tables

Answer

To optimize query performance

Answer

To control user access to the database

Question 25

Which property ensures that transactions are kept separate from one another?

Accepted Answer

Isolation of transactions

Answer

Partial completion of transactions

Answer

Rollback to a specific point in time

Question 26

Which of the following is the most widely used query language in DBMS?

Accepted Answer

SQL

Answer

NoSQL

Answer

XQuery

Question 27

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

Accepted Answer

To establish a relationship between two tables

Answer

To index the table for faster data retrieval

Answer

To store the most important data in the table

Answer

To uniquely identify each row in a table

Question 28

What is the primary purpose of a database management system?

Accepted Answer

To efficiently manage, store, and retrieve data

Answer

To perform data analysis and visualization

Answer

To host web applications

Answer

To manage user authentication and authorization

Question 29

Which data model represents data as a collection of tables with rows and columns?

Accepted Answer

Relational model

Answer

Network model

Answer

Hierarchical model

Answer

Object-oriented model

Question 30

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

Accepted Answer

To uniquely identify each record in the table and enforce data integrity

Answer

To store the most important data in the table

Answer

To establish relationships between tables

Question 31

Which database architecture is typically used for large-scale, high-performance applications requiring real-time data processing?

Accepted Answer

Distributed database

Answer

Client-server database

Answer

Centralized database

Answer

Cloud database

Question 32

Which SQL statement is used to retrieve specific data from a database based on specified criteria?

Accepted Answer

SELECT

Answer

UPDATE

Answer

INSERT

Question 33

What is the primary benefit of using a database index?

Accepted Answer

Speeding up data retrieval by providing a quick lookup table

Answer

Enforcing data integrity by preventing duplicate entries

Answer

Storing data in a specific order

Question 34

Which of the following is NOT a desirable characteristic of a well-designed database?

Accepted Answer

Redundancy of data

Answer

Data consistency

Answer

Data security

Answer

Data integrity

Question 35

Which type of database is most suitable for storing and managing large volumes of unstructured data, such as text, images, and videos?

Accepted Answer

NoSQL database

Answer

Object-oriented database

Answer

Relational database

Answer

Hierarchical database

Question 36

A data warehouse is primarily used for:

Accepted Answer

Storing, managing, and analyzing large volumes of historical data for decision-making and data mining

Answer

Supporting real-time data processing

Answer

Managing operational data for transactions

Question 37

Which SQL clause is used to filter data based on specific conditions, allowing for dynamic and selective data retrieval?

Accepted Answer

WHERE

Answer

FROM

Answer

GROUP BY

Answer

ORDER BY