Database Systems Learning Quizzes | Master Computer Science (MSc)

Question 1

Which data model type represents data as objects, classes, and relationships?

Accepted Answer

Object-oriented model

Answer

Relational model

Answer

Hierarchical model

Answer

Network model

Question 2

Which type of database system is suitable for storing semi-structured data that does not conform to a fixed schema?

Accepted Answer

NoSQL database

Answer

Relational database

Answer

Object-oriented database

Answer

XML database

Question 3

What is a key characteristic of a database management system (DBMS)?

Accepted Answer

Centralized and organized data storage and management

Answer

Independent creation and maintenance of multiple databases

Answer

Limited support for data types and structures

Answer

Exclusive use by database administrators

Question 4

In the relation Employees(EmpID, SSN, Name, Address, Salary), which attribute is the most appropriate primary key?

Accepted Answer

EmpID

Answer

SSN

Answer

Name

Answer

Address

Question 5

In the relational database model, which constraint ensures that primary key values are unique within a table?

Accepted Answer

Primary Key Constraint

Answer

Foreign Key Constraint

Answer

Unique Constraint

Answer

Not Null Constraint

Question 6

Which SQL statement is used to create a new table?

Accepted Answer

CREATE TABLE

Answer

ALTER TABLE

Answer

DROP TABLE

Answer

SELECT * FROM

Question 7

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

Accepted Answer

Increased data redundancy

Answer

Centralized data management

Answer

Enhanced data security

Answer

Improved data accessibility

Question 8

Which data model is less commonly used in database systems?

Accepted Answer

Hierarchical model

Answer

Relational model

Answer

Object-oriented model

Answer

Entity-relationship model

Question 9

Which of the following data models is not a traditional relational model and is classified as NoSQL?

Accepted Answer

Document-oriented model

Answer

Hierarchical model

Answer

Network model

Question 10

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

Accepted Answer

Spreadsheet software

Answer

Data dictionary

Answer

Query optimizer

Answer

Transaction manager

Question 11

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

Accepted Answer

Object-oriented programming

Answer

Data modeling

Answer

Normalization

Answer

Concurrency control

Question 12

Which component of a database management system (DBMS) translates user queries into instructions that the database engine can execute?

Accepted Answer

Query processor

Answer

Data dictionary

Answer

Storage manager

Answer

Transaction manager

Question 13

Which component is not a core part of a relational database management system (RDBMS)?

Accepted Answer

Application server

Answer

Data dictionary

Answer

Query optimizer

Answer

Transaction manager

Question 14

Which of the following is not a recognized database normalization form?

Accepted Answer

SNF (Simplified Normal Form)

Answer

1NF (First Normal Form)

Answer

2NF (Second Normal Form)

Answer

3NF (Third Normal Form)

Question 15

Which of the following is not a fundamental concept in database systems?

Accepted Answer

Object-oriented programming

Answer

Data integrity

Answer

Concurrency control

Question 16

Which database design concept ensures data integrity, minimizes redundancies, and prevents anomalies?

Accepted Answer

Data normalization

Answer

Data dependency

Answer

Foreign key enforcement

Answer

Database replication

Question 17

Which security measure is essential for protecting a database from unauthorized access and data tampering?

Accepted Answer

Data Encryption

Answer

Data Redundancy

Answer

Data Normalization

Answer

Data Validation

Question 18

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

Accepted Answer

Spreadsheet application

Answer

Data dictionary

Answer

Query optimizer

Answer

Transaction manager

Question 19

Which database normalization form guarantees that each non-key attribute relies exclusively on the primary key, eliminating any indirect dependencies on other attributes?

Accepted Answer

Third normal form (3NF)

Answer

First normal form (1NF)

Answer

Second normal form (2NF)

Question 20

What is a defining characteristic of a modern Database Management System (DBMS)?

Accepted Answer

Support for both traditional SQL and emerging NoSQL data models

Answer

Limited scalability and poor performance

Answer

Exclusive use of proprietary query languages

Answer

Inability to deploy on cloud platforms

Question 21

In a database system, which Data Definition Language (DDL) statement is used to create a new table?

Accepted Answer

CREATE TABLE

Answer

ALTER TABLE

Answer

SELECT * FROM

Question 22

Which of the following is NOT a constraint used to maintain data integrity in the relational model of database systems?

Accepted Answer

Inheritance constraint

Answer

Primary key constraint

Answer

Foreign key constraint

Answer

Check constraint

Question 23

Within a relational database management system (RDBMS), which action is a preventative data integrity measure?

Accepted Answer

Enforce referential integrity constraints between tables.

Answer

Regularly back up the database.

Answer

Grant appropriate user permissions to restrict data modifications.

Question 24

Which database security measure is most effective in safeguarding data from unauthorized alterations?

Accepted Answer

Encryption

Answer

Firewalls

Answer

Data masking

Answer

Two-factor authentication

Question 25

Which of the following is NOT a fundamental component of a database schema?

Accepted Answer

View

Answer

Logical schema

Answer

Physical schema

Question 26

Which database security measure is primarily used to control user access to database resources and their operations?

Accepted Answer

Access Control List (ACL)

Answer

Encryption

Answer

Data Masking

Question 27

Which component is NOT a core element of a relational database management system (RDBMS)?

Accepted Answer

Application server

Answer

Data dictionary

Answer

Query optimizer

Answer

Transaction manager

Question 28

In database design, which principle aims to reduce data redundancy, prevent anomalies, and ensure data integrity by breaking down tables into smaller, related tables based on functional dependencies?

Accepted Answer

Normalization

Answer

Data Integrity Enforcement

Answer

Referential Integrity Constraints

Answer

Data Warehousing

Question 29

Which primary security measure in database systems protects sensitive data from unauthorized access?

Accepted Answer

Data Encryption

Answer

Data Integrity Constraints

Answer

Database Auditing

Question 30

In a relational database management system (RDBMS), what is the primary function of integrity constraints?

Accepted Answer

Establish rules and limitations on data values to ensure accuracy, consistency, and validity within the database

Answer

Prevent unauthorized database access and safeguard data privacy

Answer

Optimize database performance by minimizing data redundancy and enhancing storage efficiency

Answer

Create and manage user accounts, assigning appropriate permissions and access levels

Question 31

When integrating structured data from relational databases with unstructured data from sources like social media, IoT devices, and web logs, what key challenges and considerations must be addressed?

Accepted Answer

Integrating structured and unstructured data requires careful consideration of data models, data formats, and data quality.

Answer

Unstructured data can be directly imported into relational databases without any special treatment.

Answer

Integrating structured and unstructured data requires complex and expensive data integration tools.

Question 32

Which of the following is NOT a core component of a relational database management system (RDBMS)?

Accepted Answer

Document store

Answer

Data dictionary

Answer

Query processor

Answer

Transaction manager

Question 33

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

Accepted Answer

Modifying database structure (tables, columns, constraints)

Answer

Manipulating and retrieving data

Answer

Controlling access permissions

Answer

Optimizing query performance

Question 34

Which characteristic is **NOT** essential to a modern database management system (DBMS)?

Accepted Answer

Hierarchical data storage

Answer

Data independence

Answer

Concurrent data access management

Question 35

Within the context of database systems, what is the primary purpose of a database schema?

Accepted Answer

To define the structure, relationships, and constraints of data elements within a database.

Answer

To provide a concise overview of the database's structure.

Answer

To specify the specific storage mechanisms used by the database.

Answer

To manage user permissions and security measures.

Question 36

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

Accepted Answer

Spreadsheet application

Answer

Data dictionary

Answer

Query processor

Question 37

In a database system, which technique is used to maintain data integrity and consistency during concurrent transactions?

Accepted Answer

Two-Phase Locking

Answer

Timestamp Ordering

Answer

Optimistic Concurrency Control

Answer

Deadlock Prevention

Question 38

Which of the following is NOT a characteristic of data warehouses?

Accepted Answer

Data warehouses are optimized for real-time data analysis.

Answer

Data warehouses integrate data from diverse sources.

Answer

Data warehouses support complex querying and reporting.

Question 39

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 enforce referential integrity

Answer

To improve query performance

Answer

To store metadata about the table

Question 40

Which transaction isolation level ensures that all transactions are executed serially, one at a time?

Accepted Answer

Serializable

Answer

Read committed

Answer

Read uncommitted

Answer

Repeatable read

Question 41

What is a materialized view?

Accepted Answer

A precomputed query result that is stored in the database

Answer

A view that is defined using a SQL query

Answer

A temporary table that is used to store intermediate results

Answer

A stored procedure that is used to perform a specific task

Question 42

Which database replication technique ensures that updates to the database are instantly reflected on all replicas?

Accepted Answer

Synchronous

Answer

Asynchronous

Answer

Semi-synchronous

Answer

Row-based

Question 43

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

Accepted Answer

Web server

Answer

Data dictionary

Answer

Query processor

Answer

Storage manager

Question 44

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

Accepted Answer

Operating system

Answer

Data dictionary

Answer

Query optimizer

Answer

Concurrency control

Question 45

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

Accepted Answer

To uniquely identify each record in a table

Answer

To limit the size of a table

Answer

To define the data type of a column

Answer

To ensure data consistency between tables

Question 46

Which of the following is the initial phase in the database design process?

Accepted Answer

Conceptual design

Answer

Logical design

Answer

Physical design

Answer

Testing

Question 47

What is a key constraint?

Accepted Answer

Used to uniquely identify each record in a table

Answer

Used to enforce referential integrity

Answer

Used to speed up query performance

Answer

Used to store additional information about a record

Question 48

Which transaction management property ensures that transactions are executed in isolation?

Accepted Answer

Isolation

Answer

Atomicity

Answer

Consistency

Answer

Durability

Question 49

What is the purpose of data normalisation?

Accepted Answer

To reduce data redundancy and improve data consistency

Answer

To speed up data retrieval

Answer

To enforce data integrity

Answer

To store additional information about a record

Question 50

Which of the following is NOT a type of database concurrency control mechanism?

Accepted Answer

Batch processing

Answer

Locking

Answer

Timestamping

Answer

Optimistic concurrency control

Question 51

What is the purpose of a database schema?

Accepted Answer

To define the structure and organisation of a database

Answer

To store the data in the database

Answer

To enforce data integrity

Answer

To speed up data retrieval

Question 52

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

Accepted Answer

Application server

Answer

Query processor

Answer

Storage manager

Answer

Transaction manager

Question 53

In a relational database model, a table is structured with:

Accepted Answer

Rows and columns

Answer

Pages and blocks

Answer

Objects and methods

Answer

Fields and records

Question 54

Which of the following SQL statements is used to create a table?

Accepted Answer

CREATE TABLE

Answer

DROP TABLE

Answer

ALTER TABLE

Answer

UPDATE TABLE

Question 55

Which transaction property ensures that transactions are executed in a specific order without interference?

Accepted Answer

Isolation

Answer

Atomicity

Answer

Consistency

Answer

Durability

Question 56

Which database design methodology is used to represent relationships between entities?

Accepted Answer

Entity-Relationship (ER) modelling

Answer

Object-Oriented (OO) modelling

Answer

Relational modelling

Answer

Hierarchical modelling

Question 57

What is the main advantage of using indexes in a database?

Accepted Answer

Improved query performance and efficiency

Answer

Reduced database storage space

Answer

Enhanced data security and privacy

Answer

Simplified database maintenance and administration

Question 58

What is the primary purpose of database triggers?

Accepted Answer

Automatically execute predefined actions in response to specific events

Answer

Enhance database performance and scalability

Answer

Improve data security and integrity

Answer

Simplify database administration and maintenance

Question 59

What is referential integrity and why is it crucial for maintaining data consistency in a relational database management system (RDBMS)?

Accepted Answer

Referential integrity ensures that foreign key values in a child table match existing primary key values in the parent table, preserving data consistency.

Answer

Referential integrity prevents the duplication of records within a table.

Answer

Referential integrity is not necessary for preserving data integrity in RDBMS.

Question 60

Which component is absent in a Database Management System (DBMS)?

Accepted Answer

Web server

Answer

Data catalog

Answer

Transaction manager

Answer

Query optimizer

Question 61

Data as a collection of entities and relationships is a characteristic of which data model?

Accepted Answer

Entity-relationship model

Answer

Relational model

Answer

Hierarchical model

Answer

Network model

Question 62

Which SQL statement creates a new table?

Accepted Answer

CREATE TABLE

Answer

SELECT

Answer

INSERT

Answer

UPDATE

Question 63

What is the primary objective of a database transaction?

Accepted Answer

Ensure data integrity and persistence

Answer

Enhance performance

Answer

Safeguard data from unauthorized access

Answer

Facilitate data sharing

Question 64

Which is NOT a DBMS concurrency control mechanism?

Accepted Answer

Batching

Answer

Locking

Answer

Timestamping

Answer

Optimistic concurrency control