WGU DATABASE ARCHITECTURE, SQL, AND PYTHON
FUNDAMENTALS QUIZLET | FROM QUESTION TO
PERFECTION| STUDY WITH CONFIDENCE!
Course Code:
Course Title:
Programme:
Academic Year: 2026/2027
Duration: 2 Hours
Total Marks: 70%
Candidate Instructions:
1) Write your Registration Number on every answer booklet used.
2) Answer ALL questions in Section A and ANY TWO (2) questions in Section B.
3) Read each question carefully before answering.
4) Begin each question on a new page.
5) The marks for each question are indicated in brackets.
6) This paper consists of several printed pages, including this page.
7) Ensure your copy is complete before the examination begins.
8) Unauthorized materials and communication with other candidates are not permitted.
Turn Over.
APPHIA – Crafted with Care and Precision for Academic Excellence.
1
, What does the query processor do? Answer: It interprets a query, creates a plan to retrieve or
modify data, and returns the results to the application.
What does the storage manager do? Answer: It translates the query processor's instructions into
low-level file-system commands that retrieve or modify data.
What does the transaction manager do? Answer: It ensures transactions are properly executed,
prevents conflicts between concurrent transactions, and helps restore consistency after a failure.
What is a database transaction? Answer: A group of queries that must be completed or rejected
as a whole; partial completion can leave data inconsistent.
What does the database log contain? Answer: A complete record of inserts, updates, and deletes
processed by the database.
What is the catalog or data dictionary? Answer: A directory of database objects such as tables,
columns, indexes, and other metadata.
Which component prevents conflicts among concurrent requests? Answer: The transaction
manager.
Which component translates request instructions into low-level file-system commands?
Answer: The storage manager.
Which component stores information about processed updates, removals, and insertions?
Answer: The log.
Which component contains a directory of tables, columns, indexes, and other objects? Answer:
The catalog (data dictionary).
What is DDL? Answer: Data Definition Language. It defines or changes database structure.
Which statements are DDL? Answer: CREATE, ALTER, DROP, and TRUNCATE.
Which SQL sublanguage includes CREATE? Answer: DDL - Data Definition Language.
What is DML? Answer: Data Manipulation Language. It changes data stored in existing tables.
Which statements are DML? Answer: INSERT, UPDATE, and DELETE.
What is DQL? Answer: Data Query Language. It retrieves data, mainly with SELECT.
What is DCL? Answer: Data Control Language. It controls database user access.
What is DTL? Answer: Data Transaction Language. It manages database transactions.
What does FROM do in a SELECT statement? Answer: It names the table from which rows are
selected.
What does WHERE do? Answer: It filters rows by a condition.
APPHIA – Crafted with Care and Precision for Academic Excellence.
2
FUNDAMENTALS QUIZLET | FROM QUESTION TO
PERFECTION| STUDY WITH CONFIDENCE!
Course Code:
Course Title:
Programme:
Academic Year: 2026/2027
Duration: 2 Hours
Total Marks: 70%
Candidate Instructions:
1) Write your Registration Number on every answer booklet used.
2) Answer ALL questions in Section A and ANY TWO (2) questions in Section B.
3) Read each question carefully before answering.
4) Begin each question on a new page.
5) The marks for each question are indicated in brackets.
6) This paper consists of several printed pages, including this page.
7) Ensure your copy is complete before the examination begins.
8) Unauthorized materials and communication with other candidates are not permitted.
Turn Over.
APPHIA – Crafted with Care and Precision for Academic Excellence.
1
, What does the query processor do? Answer: It interprets a query, creates a plan to retrieve or
modify data, and returns the results to the application.
What does the storage manager do? Answer: It translates the query processor's instructions into
low-level file-system commands that retrieve or modify data.
What does the transaction manager do? Answer: It ensures transactions are properly executed,
prevents conflicts between concurrent transactions, and helps restore consistency after a failure.
What is a database transaction? Answer: A group of queries that must be completed or rejected
as a whole; partial completion can leave data inconsistent.
What does the database log contain? Answer: A complete record of inserts, updates, and deletes
processed by the database.
What is the catalog or data dictionary? Answer: A directory of database objects such as tables,
columns, indexes, and other metadata.
Which component prevents conflicts among concurrent requests? Answer: The transaction
manager.
Which component translates request instructions into low-level file-system commands?
Answer: The storage manager.
Which component stores information about processed updates, removals, and insertions?
Answer: The log.
Which component contains a directory of tables, columns, indexes, and other objects? Answer:
The catalog (data dictionary).
What is DDL? Answer: Data Definition Language. It defines or changes database structure.
Which statements are DDL? Answer: CREATE, ALTER, DROP, and TRUNCATE.
Which SQL sublanguage includes CREATE? Answer: DDL - Data Definition Language.
What is DML? Answer: Data Manipulation Language. It changes data stored in existing tables.
Which statements are DML? Answer: INSERT, UPDATE, and DELETE.
What is DQL? Answer: Data Query Language. It retrieves data, mainly with SELECT.
What is DCL? Answer: Data Control Language. It controls database user access.
What is DTL? Answer: Data Transaction Language. It manages database transactions.
What does FROM do in a SELECT statement? Answer: It names the table from which rows are
selected.
What does WHERE do? Answer: It filters rows by a condition.
APPHIA – Crafted with Care and Precision for Academic Excellence.
2
