WGU D426 DATA MANAGEMENT
FOUNDATIONS COMPREHENSIVE
EXAM PREP QUESTIONS AND
CORRECT DETAILED ANSWERS A+
GRADE
1. Which of the following best describes the property of data independence in a relational
database management system (RDBMS)?
A. The requirement that every table must have a primary key to identify unique rows.
B. The ability to change the physical storage structure without changing the application
programs.
C. The ability to store data across multiple servers while maintaining a single logical view.
D. The enforcement of business rules through triggers and stored procedures.
Answer: B
Conceptual Explanation: Data independence allows changes to the physical data storage
or logical schema without affecting the users’ ability to access the data via application code.
2. In the context of the relational model, what is a ‘tuple’?
A. A specific column within a table.
B. A single row representing an entity instance.
,C. The set of all possible values for an attribute.
D. A unique identifier for a table.
Answer: B
Conceptual Explanation: In relational algebra and database terminology, a tuple refers to
a single row in a table.
3. A database designer is normalizing a table and identifies that a non-key attribute is
functionally dependent on part of a composite primary key. Which normal form is being
violated?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
Answer: B
Conceptual Explanation: Second Normal Form (2NF) requires that all non-key attributes
be fully functionally dependent on the entire primary key, not just a portion of it.
4. Which SQL command is used to remove all records from a table without deleting the table
structure itself, and typically cannot be rolled back in some systems?
A. DELETE
B. DROP
, C. TRUNCATE
D. REMOVE
Answer: C
Conceptual Explanation: TRUNCATE removes all rows from a table and is faster than
DELETE, but it does not remove the table definition (structure).
5. A ‘Many-to-Many’ relationship in a conceptual ERD is implemented in a physical relational
database by:
A. Creating an associative (linking) table containing the primary keys of both entities.
B. Creating a recursive relationship on the parent table.
C. Adding a foreign key to the ‘Many’ side table.
D. Combining both entities into a single flat table.
Answer: A
Conceptual Explanation: A junction or associative table is required to resolve a many-to-
many relationship into two one-to-many relationships.
6. Which of the following is an example of a Data Definition Language (DDL) command?
A. INSERT
B. UPDATE
C. ALTER
FOUNDATIONS COMPREHENSIVE
EXAM PREP QUESTIONS AND
CORRECT DETAILED ANSWERS A+
GRADE
1. Which of the following best describes the property of data independence in a relational
database management system (RDBMS)?
A. The requirement that every table must have a primary key to identify unique rows.
B. The ability to change the physical storage structure without changing the application
programs.
C. The ability to store data across multiple servers while maintaining a single logical view.
D. The enforcement of business rules through triggers and stored procedures.
Answer: B
Conceptual Explanation: Data independence allows changes to the physical data storage
or logical schema without affecting the users’ ability to access the data via application code.
2. In the context of the relational model, what is a ‘tuple’?
A. A specific column within a table.
B. A single row representing an entity instance.
,C. The set of all possible values for an attribute.
D. A unique identifier for a table.
Answer: B
Conceptual Explanation: In relational algebra and database terminology, a tuple refers to
a single row in a table.
3. A database designer is normalizing a table and identifies that a non-key attribute is
functionally dependent on part of a composite primary key. Which normal form is being
violated?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
Answer: B
Conceptual Explanation: Second Normal Form (2NF) requires that all non-key attributes
be fully functionally dependent on the entire primary key, not just a portion of it.
4. Which SQL command is used to remove all records from a table without deleting the table
structure itself, and typically cannot be rolled back in some systems?
A. DELETE
B. DROP
, C. TRUNCATE
D. REMOVE
Answer: C
Conceptual Explanation: TRUNCATE removes all rows from a table and is faster than
DELETE, but it does not remove the table definition (structure).
5. A ‘Many-to-Many’ relationship in a conceptual ERD is implemented in a physical relational
database by:
A. Creating an associative (linking) table containing the primary keys of both entities.
B. Creating a recursive relationship on the parent table.
C. Adding a foreign key to the ‘Many’ side table.
D. Combining both entities into a single flat table.
Answer: A
Conceptual Explanation: A junction or associative table is required to resolve a many-to-
many relationship into two one-to-many relationships.
6. Which of the following is an example of a Data Definition Language (DDL) command?
A. INSERT
B. UPDATE
C. ALTER
