WGU D426 DATA MANAGEMENT -
FOUNDATIONS COMPREHENSIVE
EXAM QUESTIONS AND ANSWERS
1. Which of the following best describes the purpose of a database management system
(DBMS)?
A. To serve as a physical storage device for hardware data.
B. To exclusively perform high-level programming for web applications.
C. To act as a networking protocol for data transmission.
D. To provide a software interface for creating, managing, and interacting with databases.
Answer: D
Conceptual Explanation: A DBMS is a software suite that allows users to define, create,
maintain, and control access to the database.
2. In the relational model, what is a ‘tuple’?
A. A column in a table.
B. A row in a table representing a single record.
C. A specific relationship between two tables.
,D. A unique constraint on a primary key.
Answer: B
Conceptual Explanation: In relational database terminology, a tuple refers to a single row
or record in a table.
3. Which type of attribute can be divided into smaller sub-parts, such as an address being
split into street, city, and zip code?
A. Derived attribute
B. Composite attribute
C. Multivalued attribute
D. Simple attribute
Answer: B
Conceptual Explanation: Composite attributes can be divided into meaningful sub-parts
to represent more basic attributes.
4. What is the primary difference between the CHAR and VARCHAR data types?
A. CHAR stores numbers, while VARCHAR stores text.
B. CHAR is fixed-length and pads with spaces; VARCHAR is variable-length.
C. CHAR is variable-length, while VARCHAR is fixed-length.
D. VARCHAR is faster for searching than CHAR in all scenarios.
, Answer: B
Conceptual Explanation: CHAR is a fixed-length character string, whereas VARCHAR is a
variable-length character string.
5. A candidate key that is not selected to be the primary key is known as a:
A. Foreign key
B. Composite key
C. Superkey
D. Alternate key
Answer: D
Conceptual Explanation: Any candidate key that is not chosen as the primary key is
referred to as an alternate key.
6. Which rule ensures that every foreign key value must either match a primary key value in a
related table or be NULL?
A. Referential integrity
B. Domain integrity
C. Entity integrity
D. Relational integrity
Answer: A
FOUNDATIONS COMPREHENSIVE
EXAM QUESTIONS AND ANSWERS
1. Which of the following best describes the purpose of a database management system
(DBMS)?
A. To serve as a physical storage device for hardware data.
B. To exclusively perform high-level programming for web applications.
C. To act as a networking protocol for data transmission.
D. To provide a software interface for creating, managing, and interacting with databases.
Answer: D
Conceptual Explanation: A DBMS is a software suite that allows users to define, create,
maintain, and control access to the database.
2. In the relational model, what is a ‘tuple’?
A. A column in a table.
B. A row in a table representing a single record.
C. A specific relationship between two tables.
,D. A unique constraint on a primary key.
Answer: B
Conceptual Explanation: In relational database terminology, a tuple refers to a single row
or record in a table.
3. Which type of attribute can be divided into smaller sub-parts, such as an address being
split into street, city, and zip code?
A. Derived attribute
B. Composite attribute
C. Multivalued attribute
D. Simple attribute
Answer: B
Conceptual Explanation: Composite attributes can be divided into meaningful sub-parts
to represent more basic attributes.
4. What is the primary difference between the CHAR and VARCHAR data types?
A. CHAR stores numbers, while VARCHAR stores text.
B. CHAR is fixed-length and pads with spaces; VARCHAR is variable-length.
C. CHAR is variable-length, while VARCHAR is fixed-length.
D. VARCHAR is faster for searching than CHAR in all scenarios.
, Answer: B
Conceptual Explanation: CHAR is a fixed-length character string, whereas VARCHAR is a
variable-length character string.
5. A candidate key that is not selected to be the primary key is known as a:
A. Foreign key
B. Composite key
C. Superkey
D. Alternate key
Answer: D
Conceptual Explanation: Any candidate key that is not chosen as the primary key is
referred to as an alternate key.
6. Which rule ensures that every foreign key value must either match a primary key value in a
related table or be NULL?
A. Referential integrity
B. Domain integrity
C. Entity integrity
D. Relational integrity
Answer: A
