Database Management Quizzes for Year 11 Computing Students

Question 1

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 create a relationship between two tables

Answer

To enforce data integrity

Question 2

What is the primary purpose of using transactions in a database?

Accepted Answer

Ensuring that a set of database operations is executed as a single unit

Answer

Improving database performance

Answer

Creating a backup of the database

Answer

Deleting data from the database

Question 3

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

Accepted Answer

ARRAY

Answer

CHAR

Answer

INTEGER

Answer

BOOLEAN

Question 4

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

Accepted Answer

CREATE DATABASE

Answer

CREATE TABLE

Answer

INSERT INTO

Answer

SELECT *

Question 5

What is the main difference between a view and a table in a database?

Accepted Answer

A view is a virtual table that is created from a query, while a table is a physical storage of data.

Answer

A table is a virtual table that is created from a view, while a view is a physical storage of data.

Answer

A view and a table are the same thing.

Answer

A table is a subset of a view.

Question 6

Which of the following SQL operators is used to check if two values are equal?

Accepted Answer

=

Answer

>

Answer

<

Answer

<>

Question 7

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

Accepted Answer

Array

Answer

Integer

Answer

String

Answer

Date

Question 8

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 in the table is accurate and consistent

Question 9

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

Accepted Answer

To establish relationships between tables in the database

Answer

To uniquely identify each row in the table

Answer

To store the most important data in the table

Answer

To ensure that all data in the table is accurate and consistent

Question 10

What is the primary benefit of using a transaction in a database?

Accepted Answer

Ensuring data integrity by maintaining data consistency during database operations

Answer

Improving database performance by reducing the time required for data retrieval

Answer

Simplifying data management by automating complex database tasks

Answer

Reducing storage space by eliminating duplicate data

Question 11

Which data modeling technique is commonly used in database design?

Accepted Answer

Entity-Relationship (ER) modeling

Answer

Object-Oriented (OO) modeling

Answer

Hierarchical modeling

Answer

Network modeling

Question 12

Which data type is specifically designed to store dates and times?

Accepted Answer

Date

Answer

Integer

Answer

String

Answer

Boolean

Question 13

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

Accepted Answer

To uniquely identify each row of data

Answer

To enforce relationships between tables

Answer

To store the maximum value in a column

Answer

To speed up data retrieval by creating an index

Question 14

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

Accepted Answer

SELECT

Answer

CREATE

Answer

UPDATE

Answer

DELETE

Question 15

What is the key difference between a clustered index and a non-clustered index?

Accepted Answer

Clustered indexes physically sort and store data based on the index, while non-clustered indexes do not.

Answer

Non-clustered indexes physically sort and store data based on the index, while clustered indexes do not.

Answer

Clustered indexes can only be created on one column, while non-clustered indexes can be created on multiple columns.

Answer

Non-clustered indexes can only be created on one column, while clustered indexes can be created on multiple columns.

Question 16

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

Accepted Answer

Increased data complexity and management overhead

Answer

Improved data consistency and integrity

Answer

Enhanced data security

Answer

Reduced data redundancy and duplication

Question 17

Which data model is designed to represent data in a tree-like structure, with each node having a parent and child relationship?

Accepted Answer

Hierarchical model

Answer

Relational model

Answer

Network model

Answer

Object-oriented model

Question 18

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

Accepted Answer

Managing and maintaining databases, ensuring their availability and performance

Answer

Designing and implementing database systems to meet specific requirements

Answer

Developing applications that use databases to store and process data

Answer

Training users on how to effectively use and query databases

Question 19

Which of the following is a characteristic that is NOT associated with a relational database management system (RDBMS)?

Accepted Answer

Hierarchical data structure

Answer

Data independence

Answer

Concurrency control

Answer

Data integrity

Question 20

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

Accepted Answer

Hierarchical data structure

Answer

Supports Structured Query Language (SQL)

Answer

Data independence

Answer

Table-based structure

Question 21

In a database, which attribute uniquely identifies each row in the 'Customers' table?

Accepted Answer

Customer ID

Answer

Customer Name

Answer

Customer Address

Answer

Customer Phone Number

Question 22

Which clause in an SQL statement is used to specify conditions for filtering rows?

Accepted Answer

WHERE

Answer

SELECT

Answer

FROM

Answer

ORDER BY

Question 23

For storing a customer's date of birth, which data type would be most appropriate?

Accepted Answer

Date

Answer

Integer

Answer

String

Answer

Boolean

Question 24

What is the key difference between an SQL 'SELECT' statement and a 'SELECT *' statement?

Accepted Answer

The 'SELECT *' statement retrieves all columns, while the 'SELECT' statement retrieves only specified columns.

Answer

The 'SELECT' statement retrieves all rows, while the 'SELECT *' statement retrieves only specified rows.

Answer

There is no difference between the two statements.

Answer

The 'SELECT *' statement is more efficient than the 'SELECT' statement.

Question 25

What is the main objective of data normalization in database design?

Accepted Answer

To improve data integrity and reduce redundancy.

Answer

To enhance database performance.

Answer

To make the database easier to use for users.

Answer

To increase the size of the database.

Question 26

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

Accepted Answer

To accelerate data retrieval

Answer

To enforce data integrity

Answer

To reduce data redundancy

Answer

To increase the size of the database

Question 27

What is the purpose of database normalization, and what are its key benefits?

Accepted Answer

Eliminates data duplication, improving integrity, efficiency, and scalability.

Answer

Increases data redundancy, improving integrity.

Answer

Primarily focuses on improving integrity, with limited impact on efficiency and scalability.

Answer

Not necessary for small databases with limited data.

Question 28

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

Accepted Answer

To ensure that each record has a unique identifier

Answer

To store the most important data in the table

Answer

To group similar records together

Question 29

Which data type should be used in SQL to store dates?

Accepted Answer

DATE

Answer

CHAR

Answer

INT

Answer

TEXT

Question 30

What is the primary function of the SELECT statement in SQL?

Accepted Answer

To retrieve specific data from a database

Answer

To create a new database

Answer

To delete data from a database

Question 31

Which of the following normalization techniques is used to eliminate data redundancy in a database?

Accepted Answer

Decomposition

Answer

Aggregation

Answer

Replication

Answer

Denormalization

Question 32

What is the main objective of implementing database security?

Accepted Answer

To safeguard database information from unauthorized access and malicious activities

Answer

To make data more easily accessible to users

Answer

To improve the performance of the database

Question 33

What is the primary purpose of a database schema?

Accepted Answer

To define the structure and organization of a database

Answer

To facilitate data querying and retrieval

Answer

To store actual data within the database

Answer

To control user access and permissions

Question 34

Which of the following is a key advantage of utilizing a database management system?

Accepted Answer

Enhanced data consistency and integrity

Answer

Increased difficulty in accessing and managing data

Answer

Reduced data security and privacy

Answer

Increased data duplication and redundancy

Question 35

What is the primary benefit of using an index in a database?

Accepted Answer

To significantly improve the speed of data retrieval and access

Answer

To protect data from unauthorized access and modification

Answer

To prevent the duplication of data

Answer

To guarantee the accuracy and reliability of data

Question 36

Which of the following is not a characteristic of a relational database?

Accepted Answer

Data is stored in a hierarchical structure.

Answer

Data is organized into tables.

Answer

Data is accessed through relationships between tables.

Question 37

What is the primary key in a database table used for?

Accepted Answer

To uniquely identify each record in the table.

Answer

To link the table to other tables.

Answer

To store the most important information.

Question 38

To retrieve all customers who have purchased a specific product from a database, which SQL clause would you use to filter the results?

Accepted Answer

WHERE

Answer

ORDER BY

Answer

GROUP BY

Answer

FROM

Question 39

What is the primary purpose of normalization in database design?

Accepted Answer

To eliminate data redundancy and ensure data integrity.

Answer

To improve data retrieval speed.

Answer

To enhance database security.

Question 40

Which type of database is best suited for storing unstructured data, like images or videos?

Accepted Answer

NoSQL database

Answer

Hierarchical database

Answer

Network database

Answer

Relational database

Question 41

You need to create a database to store student records, including personal information, course enrollments, and grades. Which database model would be most appropriate?

Accepted Answer

Relational model

Answer

Hierarchical model

Answer

Object-oriented model

Answer

Network model

Question 42

What is a database management system (DBMS)?

Accepted Answer

A software tool that enables users to create, manage, and access databases.

Answer

A hardware device that stores the database.

Answer

A set of rules for organizing data.