WGU D426 OA (pdf) | 2026/2027 | Objective Assessment | Data
Management
1. Which of the following best describes the fundamental purpose of a
database management system (DBMS)?
A) To store data in spreadsheets for easy manipulation by end users
B) To serve as an intermediary layer between the database and the
application programs that access it, managing all access to the database
C) To define the physical layout of data on storage devices only
D) To eliminate the need for data backup and recovery procedures
Correct Answer: To serve as an intermediary layer between the database and
the application programs that access it, managing all access to the database
Rationale: A DBMS is software that serves as an intermediary layer between
the database and the application programs that access it. It manages all
access to the database, ensuring data integrity, security, and concurrency. It
does not replace the need for backups or define physical layouts exclusively.
2. An organization is implementing a new database system. The database
designer is tasked with creating a blueprint of the database that is
independent of any specific DBMS. Which type of data model should the
designer create?
A) Physical data model
B) Conceptual data model
C) Internal data model
D) External data model
Correct Answer: Conceptual data model
,Rationale: A conceptual data model is a high-level representation of business
requirements and is independent of any specific DBMS. It focuses on the
business rules and data structures. Physical models are DBMS-specific,
internal models describe storage, and external models represent user views.
3. Which SQL command is used to define the structure of a database,
including creating, altering, and dropping tables?
A) Data Manipulation Language (DML)
B) Data Definition Language (DDL)
C) Data Control Language (DCL)
D) Transaction Control Language (TCL)
Correct Answer: Data Definition Language (DDL)
Rationale: DDL is the subset of SQL used to define and modify the structure
of database objects. DML is used for data manipulation (INSERT, UPDATE,
DELETE, SELECT), DCL for permissions, and TCL for transaction management.
4. A database administrator wants to ensure that all data entered into a
specific column adheres to a set of predefined rules, such as a range of
values or a specific format. What should the administrator implement?
A) A trigger
B) An index
C) A constraint
D) A view
Correct Answer: A constraint
Rationale: Constraints are rules enforced on data columns to ensure data
integrity. They can enforce domain restrictions (like value ranges),
,uniqueness, or referential integrity. Triggers are procedural code, indexes
improve performance, and views are virtual tables.
5. In a relational database, what is the primary purpose of a foreign key?
A) To uniquely identify a row in its own table
B) To establish a link between two tables and enforce referential integrity
C) To improve the speed of data retrieval
D) To store large binary objects like images
Correct Answer: To establish a link between two tables and enforce
referential integrity
Rationale: A foreign key is a column or set of columns in one table that refers
to the primary key of another table. Its purpose is to establish a link between
the two tables and enforce referential integrity, ensuring that relationships
between tables remain consistent.
6. The database designer is in the process of normalizing a database. At
which level of normalization would the designer eliminate transitive
dependencies?
A) 1NF
B) 2NF
C) 3NF
D) BCNF
Correct Answer: 3NF
Rationale: Third Normal Form (3NF) requires that a table be in 2NF and that
all transitive dependencies are removed. A transitive dependency occurs
when a non-key attribute depends on another non-key attribute. 1NF
, eliminates repeating groups, 2NF eliminates partial dependencies, and BCNF
is a stronger version of 3NF.
7. Which of the following describes the concept of "data independence" in a
database system?
A) The ability to change the physical storage structure without affecting the
logical schema
B) The ability to store data without any indexes
C) The ability to run the database without a DBMS
D) The ability to store data in multiple file formats
Correct Answer: The ability to change the physical storage structure without
affecting the logical schema
Rationale: Data independence is the capacity to change the physical storage
structures (physical schema) without requiring changes to the logical schema
or application programs. This is a key benefit of the three-schema
architecture.
8. What is the difference between structured and unstructured data?
A) Structured data is always numeric, while unstructured data is always text
B) Structured data has a predefined format and is easy to search, while
unstructured data lacks a predefined format
C) Structured data is stored in files, while unstructured data is stored in
databases
D) There is no difference between structured and unstructured data
Correct Answer: Structured data has a predefined format and is easy to
search, while unstructured data lacks a predefined format
Management
1. Which of the following best describes the fundamental purpose of a
database management system (DBMS)?
A) To store data in spreadsheets for easy manipulation by end users
B) To serve as an intermediary layer between the database and the
application programs that access it, managing all access to the database
C) To define the physical layout of data on storage devices only
D) To eliminate the need for data backup and recovery procedures
Correct Answer: To serve as an intermediary layer between the database and
the application programs that access it, managing all access to the database
Rationale: A DBMS is software that serves as an intermediary layer between
the database and the application programs that access it. It manages all
access to the database, ensuring data integrity, security, and concurrency. It
does not replace the need for backups or define physical layouts exclusively.
2. An organization is implementing a new database system. The database
designer is tasked with creating a blueprint of the database that is
independent of any specific DBMS. Which type of data model should the
designer create?
A) Physical data model
B) Conceptual data model
C) Internal data model
D) External data model
Correct Answer: Conceptual data model
,Rationale: A conceptual data model is a high-level representation of business
requirements and is independent of any specific DBMS. It focuses on the
business rules and data structures. Physical models are DBMS-specific,
internal models describe storage, and external models represent user views.
3. Which SQL command is used to define the structure of a database,
including creating, altering, and dropping tables?
A) Data Manipulation Language (DML)
B) Data Definition Language (DDL)
C) Data Control Language (DCL)
D) Transaction Control Language (TCL)
Correct Answer: Data Definition Language (DDL)
Rationale: DDL is the subset of SQL used to define and modify the structure
of database objects. DML is used for data manipulation (INSERT, UPDATE,
DELETE, SELECT), DCL for permissions, and TCL for transaction management.
4. A database administrator wants to ensure that all data entered into a
specific column adheres to a set of predefined rules, such as a range of
values or a specific format. What should the administrator implement?
A) A trigger
B) An index
C) A constraint
D) A view
Correct Answer: A constraint
Rationale: Constraints are rules enforced on data columns to ensure data
integrity. They can enforce domain restrictions (like value ranges),
,uniqueness, or referential integrity. Triggers are procedural code, indexes
improve performance, and views are virtual tables.
5. In a relational database, what is the primary purpose of a foreign key?
A) To uniquely identify a row in its own table
B) To establish a link between two tables and enforce referential integrity
C) To improve the speed of data retrieval
D) To store large binary objects like images
Correct Answer: To establish a link between two tables and enforce
referential integrity
Rationale: A foreign key is a column or set of columns in one table that refers
to the primary key of another table. Its purpose is to establish a link between
the two tables and enforce referential integrity, ensuring that relationships
between tables remain consistent.
6. The database designer is in the process of normalizing a database. At
which level of normalization would the designer eliminate transitive
dependencies?
A) 1NF
B) 2NF
C) 3NF
D) BCNF
Correct Answer: 3NF
Rationale: Third Normal Form (3NF) requires that a table be in 2NF and that
all transitive dependencies are removed. A transitive dependency occurs
when a non-key attribute depends on another non-key attribute. 1NF
, eliminates repeating groups, 2NF eliminates partial dependencies, and BCNF
is a stronger version of 3NF.
7. Which of the following describes the concept of "data independence" in a
database system?
A) The ability to change the physical storage structure without affecting the
logical schema
B) The ability to store data without any indexes
C) The ability to run the database without a DBMS
D) The ability to store data in multiple file formats
Correct Answer: The ability to change the physical storage structure without
affecting the logical schema
Rationale: Data independence is the capacity to change the physical storage
structures (physical schema) without requiring changes to the logical schema
or application programs. This is a key benefit of the three-schema
architecture.
8. What is the difference between structured and unstructured data?
A) Structured data is always numeric, while unstructured data is always text
B) Structured data has a predefined format and is easy to search, while
unstructured data lacks a predefined format
C) Structured data is stored in files, while unstructured data is stored in
databases
D) There is no difference between structured and unstructured data
Correct Answer: Structured data has a predefined format and is easy to
search, while unstructured data lacks a predefined format
