WGU D427 DATA MANAGEMENT
APPLICATIONS ADVANCED REVIEW
QUESTIONS AND ANSWERS
1. Which of the following describes the condition for a table to be in Second Normal Form
(2NF)?
A. It must be in 1NF and contain no transitive dependencies.
B. Every determinant must be a candidate key.
C. It must contain no repeating groups and have a defined primary key.
D. It must be in 1NF and all non-key attributes must be fully functionally dependent on the
entire primary key.
Answer: D
Conceptual Explanation: 2NF requires the table to be in 1NF and that no non-prime
attribute is dependent on a subset of any candidate key (no partial functional
dependencies).
2. In a relational database, what does the ‘Atomicity’ property of ACID ensure?
A. Data is written to disk immediately after every change.
,B. Multiple transactions can occur at the same time without interference.
C. A transaction is treated as a single unit, which either succeeds completely or fails
completely.
D. Only valid data is written to the database based on defined rules.
Answer: C
Conceptual Explanation: Atomicity ensures that all statements within a transaction are
completed successfully; if any part fails, the entire transaction is rolled back.
3. Which SQL clause is used to filter the results of an aggregate function?
A. WHERE
B. GROUP BY
C. HAVING
D. ORDER BY
Answer: C
Conceptual Explanation: The HAVING clause was added to SQL because the WHERE
keyword could not be used with aggregate functions.
4. What is the result of a CROSS JOIN between a table with 5 rows and a table with 10 rows?
A. 15 rows
B. 50 rows
, C. 5 rows
D. 10 rows
Answer: B
Conceptual Explanation: A CROSS JOIN produces a Cartesian product, multiplying the
number of rows in the first table by the number of rows in the second (5 * 10 = 50).
5. A ‘Transitive Dependency’ is specifically addressed in which normalization stage?
A. Third Normal Form (3NF)
B. Second Normal Form (2NF)
C. First Normal Form (1NF)
D. Boyce-Codd Normal Form (BCNF)
Answer: A
Conceptual Explanation: 3NF requires a table to be in 2NF and have no transitive
functional dependencies (non-key attributes depending on other non-key attributes).
6. Which SQL command is categorized as Data Definition Language (DDL)?
A. UPDATE
B. INSERT
C. SELECT
D. ALTER
APPLICATIONS ADVANCED REVIEW
QUESTIONS AND ANSWERS
1. Which of the following describes the condition for a table to be in Second Normal Form
(2NF)?
A. It must be in 1NF and contain no transitive dependencies.
B. Every determinant must be a candidate key.
C. It must contain no repeating groups and have a defined primary key.
D. It must be in 1NF and all non-key attributes must be fully functionally dependent on the
entire primary key.
Answer: D
Conceptual Explanation: 2NF requires the table to be in 1NF and that no non-prime
attribute is dependent on a subset of any candidate key (no partial functional
dependencies).
2. In a relational database, what does the ‘Atomicity’ property of ACID ensure?
A. Data is written to disk immediately after every change.
,B. Multiple transactions can occur at the same time without interference.
C. A transaction is treated as a single unit, which either succeeds completely or fails
completely.
D. Only valid data is written to the database based on defined rules.
Answer: C
Conceptual Explanation: Atomicity ensures that all statements within a transaction are
completed successfully; if any part fails, the entire transaction is rolled back.
3. Which SQL clause is used to filter the results of an aggregate function?
A. WHERE
B. GROUP BY
C. HAVING
D. ORDER BY
Answer: C
Conceptual Explanation: The HAVING clause was added to SQL because the WHERE
keyword could not be used with aggregate functions.
4. What is the result of a CROSS JOIN between a table with 5 rows and a table with 10 rows?
A. 15 rows
B. 50 rows
, C. 5 rows
D. 10 rows
Answer: B
Conceptual Explanation: A CROSS JOIN produces a Cartesian product, multiplying the
number of rows in the first table by the number of rows in the second (5 * 10 = 50).
5. A ‘Transitive Dependency’ is specifically addressed in which normalization stage?
A. Third Normal Form (3NF)
B. Second Normal Form (2NF)
C. First Normal Form (1NF)
D. Boyce-Codd Normal Form (BCNF)
Answer: A
Conceptual Explanation: 3NF requires a table to be in 2NF and have no transitive
functional dependencies (non-key attributes depending on other non-key attributes).
6. Which SQL command is categorized as Data Definition Language (DDL)?
A. UPDATE
B. INSERT
C. SELECT
D. ALTER
