Database Management for Sixth Form Computer Science: Interactive Learning Quizzes

Question 1

To ensure the accuracy and consistency of data in a database, which technique is primarily employed?

Accepted Answer

Data Validation

Answer

Encryption

Answer

Backup and Recovery

Answer

Access Control

Question 2

Which property is **NOT** a characteristic of ACID transactions?

Accepted Answer

Eventual Consistency

Answer

Durability

Answer

Isolation

Answer

Atomicity

Question 3

Data integrity constraints are crucial for maintaining data quality in databases. Explain their purpose and different types, highlighting how they contribute to ensuring data accuracy.

Accepted Answer

Data integrity constraints ensure data accuracy by enforcing specific rules on stored data.

Accepted Answer

Common types of data integrity constraints include primary key constraints, foreign key constraints, and check constraints.

Answer

Data integrity constraints define how data is linked between tables in a database.

Answer

Data integrity constraints are only applicable to relational database management systems.

Question 4

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

Accepted Answer

To uniquely identify each row

Answer

To enforce referential integrity

Answer

To group related rows together

Answer

To store the most important data

Question 5

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

Accepted Answer

To establish relationships between tables

Answer

To create unique values

Answer

To enforce data validation

Answer

To store additional information

Question 6

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

Accepted Answer

CREATE TABLE

Answer

SELECT

Answer

UPDATE

Answer

INSERT INTO

Question 7

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

Accepted Answer

A primary key is unique, while a candidate key is not

Answer

A candidate key is unique, while a primary key is not

Answer

A primary key is always a foreign key

Answer

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

Question 8

Which of the following is NOT a type of database transaction?

Accepted Answer

Delete-only

Answer

Read-only

Answer

Read-write

Answer

Update-only

Question 9

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

Accepted Answer

Expediting data retrieval

Answer

Ensuring data integrity

Answer

Enforcing data validation

Answer

Preventing duplicate values

Question 10

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

Accepted Answer

To uniquely identify each entity in the table

Answer

To enforce referential integrity

Answer

To speed up data retrieval

Answer

To store additional information about each entity

Question 11

Which SQL command is used to create a new database?

Accepted Answer

CREATE DATABASE

Answer

ALTER TABLE

Answer

INSERT INTO

Answer

SELECT * FROM

Question 12

Which of the following is NOT a data type in SQL?

Accepted Answer

ARRAY

Answer

INTEGER

Answer

VARCHAR

Answer

BLOB

Question 13

Which of the following is NOT a type of database index?

Accepted Answer

View Index

Answer

Clustered index

Answer

Non-clustered index

Answer

Full-text index

Question 14

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

Accepted Answer

Increased data redundancy

Answer

Improved data consistency

Answer

Enhanced data security

Answer

Simplified data access

Question 15

Which SQL statement is used to create a new table?

Accepted Answer

CREATE TABLE

Answer

SELECT

Answer

UPDATE

Answer

DELETE

Question 16

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

Accepted Answer

To enforce data integrity

Answer

To ensure data consistency

Answer

To prevent duplicate data

Answer

To optimize query performance

Question 17

Differentiate 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 the primary key in another table.

Answer

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

Answer

A primary key is used to enforce data integrity, while a foreign key is used to optimize query performance.

Answer

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

Question 18

Which of the following is **not** a benefit of database normalization?

Accepted Answer

Increased database size

Answer

Reduced data redundancy

Answer

Improved data integrity

Answer

Simplified data updates

Question 19

What is the purpose of an index in a database?

Accepted Answer

To speed up data retrieval

Answer

To enforce data integrity

Answer

To store data in a compressed format

Answer

To create relationships between tables

Question 20

Which SQL command is used to create a new table?

Accepted Answer

CREATE TABLE

Answer

SELECT

Answer

INSERT

Answer

UPDATE

Question 21

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 ensure that all data entries are consistent.

Question 22

Which of the following is a type of NoSQL database?

Accepted Answer

MongoDB

Answer

MySQL

Answer

PostgreSQL

Answer

SQL Server

Question 23

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

Accepted Answer

Increased data redundancy

Answer

Centralized data management

Answer

Improved data security

Answer

Enhanced data access and sharing

Question 24

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

Accepted Answer

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

Answer

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

Answer

Foreign keys and primary keys are the same.

Answer

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

Question 25

Which of the following is a common tool used for designing databases?

Accepted Answer

Entity-Relationship Diagram (ERD)

Answer

Flowchart

Answer

Spreadsheet

Answer

Word processor

Question 26

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

Accepted Answer

To manage and maintain a database system

Answer

To design and develop new databases

Answer

To write SQL queries for end-users

Answer

To provide technical support to database users

Question 27

Which SQL statement is used to create a new table in a database?

Accepted Answer

CREATE TABLE

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 28

Which of the following is a characteristic of a NoSQL database that distinguishes it from a relational database?

Accepted Answer

Schema-less and flexible data model

Answer

Support for complex data types

Answer

Use of SQL as the query language

Answer

Strict adherence to data integrity rules

Question 29

What is the primary purpose of a database index?

Accepted Answer

To speed up data retrieval queries

Answer

To maintain data consistency and integrity

Answer

To store backup data in case of data loss

Answer

To enhance data security by encrypting data

Question 30

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 a primary key in another table.

Answer

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

Answer

Primary keys and foreign keys serve the same purpose in a relational database.

Answer

Foreign keys are used to enforce data integrity, while primary keys are not.

Question 31

What is the main purpose of a database transaction?

Accepted Answer

To ensure data consistency and integrity in the face of failures or errors

Answer

To improve query performance by optimizing data retrieval

Answer

To create a backup of the database for disaster recovery

Answer

To manage user permissions and access control to the database

Question 32

To create a new table in SQL, which command should you use?

Accepted Answer

CREATE TABLE

Answer

SELECT

Answer

INSERT

Answer

UPDATE

Question 33

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

Accepted Answer

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

Answer

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

Answer

Both primary keys and foreign keys serve the same purpose of uniquely identifying rows in tables.

Answer

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

Question 34

Which of the following database types falls under the NoSQL category?

Accepted Answer

MongoDB

Answer

MySQL

Answer

Oracle

Answer

PostgreSQL

Question 35

What is the primary objective of database normalization?

Accepted Answer

Minimize data redundancy and enhance data integrity

Answer

Increase data redundancy and improve performance

Answer

Simplify data queries and reduce complexity

Answer

Enhance security and access control

Question 36

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

Accepted Answer

Managing and maintaining the database system

Answer

Developing and implementing database applications

Answer

Designing and modeling databases

Answer

Analyzing and interpreting data

Question 37

What is the key difference between a data warehouse and a data lake?

Accepted Answer

Data warehouses are structured and optimized for querying, while data lakes are unstructured and raw.

Answer

Data lakes are structured and optimized for querying, while data warehouses are unstructured and raw.

Answer

Both data warehouses and data lakes are structured and optimized for querying.

Answer

Both data warehouses and data lakes are unstructured and raw.

Question 38

Which data type is NOT available in SQL?

Accepted Answer

Array

Answer

Integer

Answer

String

Answer

Boolean

Question 39

Which database model is characterized by its use of tables and relationships?

Accepted Answer

Relational model

Answer

Hierarchical model

Answer

Network model

Answer

Document model

Question 40

Which SQL command allows you to create a new table?

Accepted Answer

CREATE TABLE

Answer

SELECT

Answer

INSERT

Answer

DELETE

Question 41

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

Accepted Answer

To uniquely identify each record in the table

Answer

To establish relationships between tables

Answer

To store the most important data in the table

Answer

To enforce data integrity

Question 42

Which SQL statement is used to create a new database table?

Accepted Answer

CREATE TABLE

Answer

INSERT INTO

Answer

SELECT * FROM

Answer

UPDATE

Question 43

What is the primary function of a data model?

Accepted Answer

To represent the logical structure of data stored in the database

Answer

To specify the physical storage of data on the disk

Answer

To enable users to interact with the database using a graphical interface

Answer

To ensure data integrity and prevent unauthorized access

Question 44

Which of the following is a defining characteristic of the relational database model?

Accepted Answer

Data is organized into tables with rows and columns

Answer

Data is stored in a hierarchical structure

Answer

Data is accessed using a graph-based query language

Answer

Data is stored as objects with properties and methods

Question 45

What is the primary function of a SQL query?

Accepted Answer

To retrieve specific data from a database

Answer

To create new tables and databases

Answer

To modify data within a database

Answer

To perform complex data analysis and generate reports

Question 46

Which of the following is NOT a type of NoSQL database?

Accepted Answer

Relational database

Answer

Document database

Answer

Key-value store

Answer

Graph database

Question 47

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

Accepted Answer

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

Answer

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

Answer

Both primary keys and foreign keys can uniquely identify rows

Answer

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

Question 48

What is the distinction between a physical database design and a logical database design?

Accepted Answer

A physical database design defines the physical storage of data, while a logical database design outlines the data's logical structure

Answer

A logical database design defines the physical storage of data, while a physical database design outlines the data's logical structure

Answer

There is no difference between a physical database design and a logical database design

Answer

Both physical database designs and logical database designs define the physical storage of data

Question 49

What is the unique identifier of a row in a table known as?

Accepted Answer

Primary key

Answer

Foreign key

Answer

Candidate key

Answer

Unique key

Question 50

Which SQL command is used to create a new table?

Accepted Answer

CREATE TABLE

Answer

INSERT INTO

Answer

UPDATE

Answer

SELECT

Question 51

What is the primary purpose of a foreign key?

Accepted Answer

To ensure data integrity by enforcing referential constraints

Answer

To establish links between tables

Answer

To create relationships between rows in different tables

Answer

To store additional information about a row

Question 52

Which of the following is not a type of NoSQL database?

Accepted Answer

Relational

Answer

Document-oriented

Answer

Key-value store

Answer

Graph

Question 53

How does a primary key differ from a candidate key?

Accepted Answer

A primary key is selected from the candidate keys.

Answer

A primary key is a unique identifier, while a candidate key is not.

Answer

A candidate key is a unique identifier, while a primary key is not.

Answer

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

Question 54

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

Accepted Answer

Object

Answer

Integer

Answer

String

Answer

Boolean

Question 55

What is the purpose of a WHERE clause in an SQL statement?

Accepted Answer

To filter and select specific rows from a table

Answer

To modify existing rows in a table

Answer

To remove rows from a table

Answer

To create a new table

Question 56

How do data integrity constraints contribute to maintaining data quality in a database system?

Accepted Answer

They ensure data accuracy and consistency, preventing data anomalies.

Answer

They restrict unauthorized access to protect data from modifications.

Answer

They automate database backups for data recovery.

Answer

They are exclusive to relational database systems.

Question 57

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

Accepted Answer

Array

Answer

Integer

Answer

String

Answer

Boolean

Question 58

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

Accepted Answer

To uniquely identify each row in a table

Answer

To establish referential integrity between tables

Answer

To store data for a specific column

Answer

To index data for faster retrieval

Question 59

Which type of database is designed to manage large volumes of unstructured data?

Accepted Answer

NoSQL database (e.g., MongoDB)

Answer

Relational database

Answer

Graph database

Answer

Cloud database

Question 60

What is the term used to describe a collection of interconnected tables in a database?

Accepted Answer

Schema

Answer

Data model

Answer

Entity-relationship diagram

Answer

Database instance

Question 61

What is the main distinction between a normalized and a denormalized database?

Accepted Answer

Normalized databases minimize redundant data, while denormalized databases include more redundancy to enhance query performance

Answer

Denormalized databases minimize redundant data, while normalized databases include more redundancy to improve data consistency

Answer

Normalized databases use more tables, while denormalized databases use fewer tables

Answer

Denormalized databases use more tables, while normalized databases use fewer tables

Question 62

In database design, what is the purpose of an entity-relationship diagram (ERD)?

Accepted Answer

To graphically depict the relationships between entities in a database

Answer

To generate SQL code for creating the database

Answer

To store the actual data in the database

Answer

To document the database schema

Question 63

Which of the following is not a join type in database queries?

Accepted Answer

Union join

Answer

Inner join

Answer

Outer join

Answer

Cross join

Question 64

In a relational database, what is the function of a foreign key?

Accepted Answer

To enforce referential integrity between tables

Answer

To establish a relationship between two tables

Answer

To store data for a specific column

Answer

To index data for faster retrieval