WGU D446 DATA MANAGEMENT -
FOUNDATIONS PRACTICE EXAM
QUESTIONS AND ANSWERS
1. Which component of a database management system (DBMS) is responsible for ensuring
the data is stored consistently and can be retrieved efficiently?
A. Transaction Manager
B. Query Optimizer
C. Data Dictionary
D. Storage Engine
Answer: D
Conceptual Explanation: The storage engine is the software component that the DBMS
uses to create, read, update, and delete data from a database.
2. Which normal form requires all non-key attributes to be functionally dependent on the
entire primary key and not just a part of it?
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: 2NF addresses partial functional dependencies, requiring that
every non-prime attribute be fully functionally dependent on the primary key.
3. In an Entity-Relationship Diagram (ERD), what does a dashed line between two entities
typically represent?
A. An identifying relationship
B. A recursive relationship
C. A many-to-many relationship
D. A non-identifying relationship
Answer: D
Conceptual Explanation: In Crow’s Foot notation, a dashed line represents a non-
identifying relationship where the child entity can exist independently of the parent.
4. Which SQL command is used to add a new column to an existing table?
A. UPDATE TABLE
B. ALTER TABLE
C. INSERT INTO
D. MODIFY TABLE
, Answer: B
Conceptual Explanation: ALTER TABLE is the DDL command used to change the structure
of an existing table, including adding or dropping columns.
5. What is the purpose of a Foreign Key in a relational database?
A. To establish and enforce a link between data in two tables.
B. To improve the speed of data retrieval.
C. To uniquely identify a row in its own table.
D. To ensure that every row has a unique value for a specific column.
Answer: A
Conceptual Explanation: A Foreign Key provides referential integrity by linking a column
in one table to the Primary Key of another table.
6. Which aggregate function would you use to find the total number of entries in a specific
column?
A. SUM()
B. COUNT()
C. TOTAL()
D. ADD()
Answer: B
FOUNDATIONS PRACTICE EXAM
QUESTIONS AND ANSWERS
1. Which component of a database management system (DBMS) is responsible for ensuring
the data is stored consistently and can be retrieved efficiently?
A. Transaction Manager
B. Query Optimizer
C. Data Dictionary
D. Storage Engine
Answer: D
Conceptual Explanation: The storage engine is the software component that the DBMS
uses to create, read, update, and delete data from a database.
2. Which normal form requires all non-key attributes to be functionally dependent on the
entire primary key and not just a part of it?
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: 2NF addresses partial functional dependencies, requiring that
every non-prime attribute be fully functionally dependent on the primary key.
3. In an Entity-Relationship Diagram (ERD), what does a dashed line between two entities
typically represent?
A. An identifying relationship
B. A recursive relationship
C. A many-to-many relationship
D. A non-identifying relationship
Answer: D
Conceptual Explanation: In Crow’s Foot notation, a dashed line represents a non-
identifying relationship where the child entity can exist independently of the parent.
4. Which SQL command is used to add a new column to an existing table?
A. UPDATE TABLE
B. ALTER TABLE
C. INSERT INTO
D. MODIFY TABLE
, Answer: B
Conceptual Explanation: ALTER TABLE is the DDL command used to change the structure
of an existing table, including adding or dropping columns.
5. What is the purpose of a Foreign Key in a relational database?
A. To establish and enforce a link between data in two tables.
B. To improve the speed of data retrieval.
C. To uniquely identify a row in its own table.
D. To ensure that every row has a unique value for a specific column.
Answer: A
Conceptual Explanation: A Foreign Key provides referential integrity by linking a column
in one table to the Primary Key of another table.
6. Which aggregate function would you use to find the total number of entries in a specific
column?
A. SUM()
B. COUNT()
C. TOTAL()
D. ADD()
Answer: B
