WGU D426 DATA MANAGEMENT
FOUNDATIONS - FINAL EXAM PREP
QUESTIONS AND CORRECT DETAILED
ANSWERS A+ GRADE
1. Which phase of the database design process involves the use of an Entity-Relationship (ER)
diagram to represent data requirements without regard to the specific database software?
A. Conceptual Design
B. Logical Design
C. Physical Design
D. Implementation Design
Answer: A
Conceptual Explanation: Conceptual design is the first stage where business
requirements are mapped into a high-level model like an ER diagram, independent of any
DBMS or physical storage details.
2. In the context of the Relational Model, what is a ‘tuple’?
A. A column in a table
B. A row in a table
C. A unique identifier for a table
,D. A set of permitted values for an attribute
Answer: B
Conceptual Explanation: In relational database terminology, a row is formally called a
tuple, and a column is called an attribute.
3. Which SQL command is used to change the structure of an existing table, such as adding a
new column?
A. UPDATE
B. MODIFY
C. CHANGE
D. ALTER TABLE
Answer: D
Conceptual Explanation: ALTER TABLE is a Data Definition Language (DDL) command
used to add, delete, or modify columns in an existing table.
4. A primary key that consists of more than one attribute is known as a:
A. Foreign Key
B. Candidate Key
C. Surrogate Key
D. Composite Key
, Answer: D
Conceptual Explanation: A composite key is a primary key that uses two or more columns
to uniquely identify a row in a table.
5. Which normal form deals with removing partial functional dependencies?
A. Second Normal Form (2NF)
B. First Normal Form (1NF)
C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
Answer: A
Conceptual Explanation: 2NF requires a table to be in 1NF and for all non-key attributes
to be fully functionally dependent on the entire primary key, thus removing partial
dependencies.
6. What is the purpose of a Foreign Key in a relational database?
A. To uniquely identify a record in its own table
B. To establish a link between data in two tables and ensure referential integrity
C. To speed up data retrieval using indexing
D. To prevent duplicate records from being entered into a table
Answer: B
FOUNDATIONS - FINAL EXAM PREP
QUESTIONS AND CORRECT DETAILED
ANSWERS A+ GRADE
1. Which phase of the database design process involves the use of an Entity-Relationship (ER)
diagram to represent data requirements without regard to the specific database software?
A. Conceptual Design
B. Logical Design
C. Physical Design
D. Implementation Design
Answer: A
Conceptual Explanation: Conceptual design is the first stage where business
requirements are mapped into a high-level model like an ER diagram, independent of any
DBMS or physical storage details.
2. In the context of the Relational Model, what is a ‘tuple’?
A. A column in a table
B. A row in a table
C. A unique identifier for a table
,D. A set of permitted values for an attribute
Answer: B
Conceptual Explanation: In relational database terminology, a row is formally called a
tuple, and a column is called an attribute.
3. Which SQL command is used to change the structure of an existing table, such as adding a
new column?
A. UPDATE
B. MODIFY
C. CHANGE
D. ALTER TABLE
Answer: D
Conceptual Explanation: ALTER TABLE is a Data Definition Language (DDL) command
used to add, delete, or modify columns in an existing table.
4. A primary key that consists of more than one attribute is known as a:
A. Foreign Key
B. Candidate Key
C. Surrogate Key
D. Composite Key
, Answer: D
Conceptual Explanation: A composite key is a primary key that uses two or more columns
to uniquely identify a row in a table.
5. Which normal form deals with removing partial functional dependencies?
A. Second Normal Form (2NF)
B. First Normal Form (1NF)
C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
Answer: A
Conceptual Explanation: 2NF requires a table to be in 1NF and for all non-key attributes
to be fully functionally dependent on the entire primary key, thus removing partial
dependencies.
6. What is the purpose of a Foreign Key in a relational database?
A. To uniquely identify a record in its own table
B. To establish a link between data in two tables and ensure referential integrity
C. To speed up data retrieval using indexing
D. To prevent duplicate records from being entered into a table
Answer: B
