WGU D427 DATA MANAGEMENT
APPLICATIONS ADVANCED PRACTICE
EXAM QUESTIONS AND ANSWERS
1. A table is in Second Normal Form (2NF) and contains no transitive dependencies. What is
the highest normal form this table has achieved?
A. First Normal Form (1NF)
B. Third Normal Form (3NF)
C. Second Normal Form (2NF)
D. Boyce-Codd Normal Form (BCNF)
Answer: B
Conceptual Explanation: A table is in 3NF if it is in 2NF and all non-key attributes are
functionally dependent only on the primary key, meaning there are no transitive
dependencies.
2. Which SQL clause is used to filter the results of an aggregate function?
A. WHERE
B. HAVING
C. GROUP BY
,D. ORDER BY
Answer: B
Conceptual Explanation: The HAVING clause was added to SQL because the WHERE
keyword could not be used with aggregate functions.
3. In a relational database, what does the ‘Atomicity’ property of ACID ensure?
A. Data is saved even if the system fails.
B. A transaction is treated as a single unit, which either succeeds completely or fails
completely.
C. Transactions are processed one at a time.
D. Data remains consistent before and after a transaction.
Answer: B
Conceptual Explanation: Atomicity ensures that all operations within a work unit are
completed successfully; otherwise, the transaction is aborted at the point of failure and
previous operations are rolled back.
4. Which operator would you use in a WHERE clause to search for a specific pattern in a
column?
A. IN
B. BETWEEN
C. LIKE
, D. EXISTS
Answer: C
Conceptual Explanation: The LIKE operator is used in a WHERE clause to search for a
specified pattern in a column using wildcards like % or _.
5. To remove all records from a table named ‘Orders’ without deleting the table structure
itself, which command is most efficient?
A. DELETE FROM Orders;
B. DROP TABLE Orders;
C. REMOVE * FROM Orders;
D. TRUNCATE TABLE Orders;
Answer: D
Conceptual Explanation: TRUNCATE TABLE is a DDL command that removes all rows
from a table faster than DELETE and resets auto-increment values, while preserving the
table schema.
6. A table has a composite primary key consisting of (EmployeeID, ProjectID). If the
‘HourlyRate’ attribute depends only on ‘EmployeeID’, which normal form is violated?
A. 1NF
B. 2NF
C. 3NF
APPLICATIONS ADVANCED PRACTICE
EXAM QUESTIONS AND ANSWERS
1. A table is in Second Normal Form (2NF) and contains no transitive dependencies. What is
the highest normal form this table has achieved?
A. First Normal Form (1NF)
B. Third Normal Form (3NF)
C. Second Normal Form (2NF)
D. Boyce-Codd Normal Form (BCNF)
Answer: B
Conceptual Explanation: A table is in 3NF if it is in 2NF and all non-key attributes are
functionally dependent only on the primary key, meaning there are no transitive
dependencies.
2. Which SQL clause is used to filter the results of an aggregate function?
A. WHERE
B. HAVING
C. GROUP BY
,D. ORDER BY
Answer: B
Conceptual Explanation: The HAVING clause was added to SQL because the WHERE
keyword could not be used with aggregate functions.
3. In a relational database, what does the ‘Atomicity’ property of ACID ensure?
A. Data is saved even if the system fails.
B. A transaction is treated as a single unit, which either succeeds completely or fails
completely.
C. Transactions are processed one at a time.
D. Data remains consistent before and after a transaction.
Answer: B
Conceptual Explanation: Atomicity ensures that all operations within a work unit are
completed successfully; otherwise, the transaction is aborted at the point of failure and
previous operations are rolled back.
4. Which operator would you use in a WHERE clause to search for a specific pattern in a
column?
A. IN
B. BETWEEN
C. LIKE
, D. EXISTS
Answer: C
Conceptual Explanation: The LIKE operator is used in a WHERE clause to search for a
specified pattern in a column using wildcards like % or _.
5. To remove all records from a table named ‘Orders’ without deleting the table structure
itself, which command is most efficient?
A. DELETE FROM Orders;
B. DROP TABLE Orders;
C. REMOVE * FROM Orders;
D. TRUNCATE TABLE Orders;
Answer: D
Conceptual Explanation: TRUNCATE TABLE is a DDL command that removes all rows
from a table faster than DELETE and resets auto-increment values, while preserving the
table schema.
6. A table has a composite primary key consisting of (EmployeeID, ProjectID). If the
‘HourlyRate’ attribute depends only on ‘EmployeeID’, which normal form is violated?
A. 1NF
B. 2NF
C. 3NF
