Fundamentals of Databases Practice Questions
A-Levels · A-Level Computer Science · 151 free MCQs with instant results and detailed explanations.
151
Total
46
Easy
76
Medium
29
Hard
Start Practicing Fundamentals of Databases
Take a timed quiz or customize your practice session
Sample Questions from Fundamentals of Databases
Here are 10 sample questions. Start a quiz to get randomized questions with scoring.
Q1
Easy
What does SQL stand for in the context of databases?
A.
Structured Query Language
B.
Standard Query Language
C.
Simple Query Language
D.
Secure Query Language
Show Answer & Explanation
Correct Answer: A
SQL stands for 'Structured Query Language', which is the standard language used for managing and manipulating databases.
Q2
Easy
Which of the following is a primary key in a database table?
A.
A column that uniquely identifies each row
B.
A column that allows null values
C.
A column used to store large amounts of text
D.
A column that is not indexed
Show Answer & Explanation
Correct Answer: A
A primary key is defined as a column (or combination of columns) that uniquely identifies each row in a database table, ensuring that no two rows have the same key.
Q3
Easy
In a relational database, what is a foreign key?
A.
A key used to create a unique identifier for a table
B.
A key that links two tables together
C.
A key that stores user permissions
D.
A key that is not used in normalization
Show Answer & Explanation
Correct Answer: B
A foreign key is a column (or set of columns) in one table that refers to the primary key in another table, establishing a relationship between the two tables.
Q4
Medium
Which of the following is NOT a characteristic of a relational database?
A.
Data is organized in tables.
B.
Data is accessed using SQL.
C.
Data is stored in a hierarchical structure.
D.
Data integrity is maintained through constraints.
Show Answer & Explanation
Correct Answer: C
In a relational database, data is structured in tables, not in a hierarchical format. Hierarchical databases organize data in a tree-like structure, contrasting with the tabular structure of relational databases.
Q5
Medium
What is the primary purpose of normalization in databases?
A.
To increase data redundancy.
B.
To reduce data anomalies.
C.
To enforce relationships.
D.
To simplify SQL queries.
Show Answer & Explanation
Correct Answer: B
Normalization aims to reduce data anomalies by organizing data into tables and establishing relationships between them, thereby ensuring data integrity and reducing redundancy.
Q6
Medium
Which SQL statement is used to retrieve data from a table?
A.
INSERT
B.
UPDATE
C.
SELECT
D.
DELETE
Show Answer & Explanation
Correct Answer: C
The SELECT statement is specifically designed for retrieving data from one or more tables in a database. The other options serve different purposes: INSERT adds data, UPDATE modifies existing data, and DELETE removes data.
Q7
Medium
In a database, what does the term 'foreign key' refer to?
A.
A key that uniquely identifies a record in its own table.
B.
A key that is used to link two tables together.
C.
A key that is generated automatically by the database.
D.
A key that is encrypted for security.
Show Answer & Explanation
Correct Answer: B
A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table, thus establishing a relationship between the two tables.
Q8
Hard
Which of the following SQL statements will successfully retrieve the names of all customers who have placed at least one order from a database with 'customers' and 'orders' tables?
A.
SELECT DISTINCT c.name FROM customers c JOIN orders o ON c.customer_id = o.customer_id;
B.
SELECT c.name FROM customers c WHERE c.customer_id IN (SELECT o.customer_id FROM orders o);
C.
SELECT c.name FROM customers c WHERE o.customer_id IS NOT NULL;
D.
SELECT c.name FROM orders o JOIN customers c ON o.customer_id = c.customer_id;
Show Answer & Explanation
Correct Answer: A
Option A correctly joins the 'customers' and 'orders' tables on customer_id and retrieves distinct customer names who have placed orders. Options B and D are close but do not fully ensure that all results are distinct, and C lacks a proper join.
Q9
Hard
In a relational database, which of the following statements correctly describes the concept of normalization?
A.
Normalization is a process of de-normalizing data to improve performance in large databases.
B.
Normalization involves organizing data to reduce redundancy and improve data integrity.
C.
Normalization is the act of merging multiple tables into one for easier access.
D.
Normalization is the process of securing data by encrypting it within the database.
Show Answer & Explanation
Correct Answer: B
Option B accurately defines normalization as the process of organizing data to reduce redundancy and enhance data integrity. The other options misrepresent the concept by focusing on de-normalization, merging, or encryption, which are unrelated to normalization.
Q10
Hard
Which of the following statements best defines a foreign key in a relational database?
A.
A foreign key is a unique identifier for a record in the same table.
B.
A foreign key is a field in one table that links to the primary key of another table.
C.
A foreign key is a value that must be unique across the entire database.
D.
A foreign key is an attribute that can only contain numeric values.
Show Answer & Explanation
Correct Answer: B
A foreign key is specifically designed to establish a link between two tables, referencing the primary key of another table to maintain referential integrity.
Showing 10 of 151 questions. Start a quiz to practice all questions with scoring and timer.
Practice All 151 Questions →More A-Level Computer Science Chapters
1
Fundamentals of Programming
149 Qs →
2
Fundamentals of Data Structures
146 Qs →
3
Fundamentals of Algorithms
145 Qs →
4
Theory of Computation
149 Qs →
5
Fundamentals of Data Representation
140 Qs →
6
Fundamentals of Computer Systems
150 Qs →
7
Fundamentals of Computer Organisation
149 Qs →
8
Consequences of Uses of Computing
151 Qs →
Fundamentals of Databases — A-Levels A-Level Computer Science Practice Questions Online
This page contains 151 practice MCQs for the chapter Fundamentals of Databases in A-Levels A-Level Computer Science. The questions are organized by difficulty — 46 easy, 76 medium, 29 hard — so you can choose the right level for your preparation.
Every question includes a detailed explanation to help you understand the concept, not just memorize answers. Take a timed quiz to simulate exam conditions, or practice at your own pace with no time limit.