WGU D427 – Database Management Applications (2025) | Pre-Assessment & Objective Assessment with Verified Answers | Updated for Guaranteed Pass

WGU D427 Database Management Applications
Exam 2025 – Pre-Assessment & Objective
Assessment with Verified Answers | Updated for
Guaranteed Pass


This comprehensive exam for WGU D427 Database Management Applications (2025/2026)
includes 200 verified questions for pre-assessment and objective assessment, covering SQL
queries, database design, normalization, DDL, DML, joins, views, indexes, and advanced
concepts. Questions are multiple-choice with four options, correct answer in RED, and short
rationales based on relational database principles. Organized by topic.

Database Fundamentals and Design (Questions 1-40)
Question 1: How many attributes are present in the address fragment "San Francisco, CA
94110 USA"?
A. 1
B. 2
C. 3
D. 4
Correct Answer: D. 4
Rationale: Street, City, State, ZIP - four attributes.



Question 2: In the Package table with columns Weight (decimal), Description (string),
LastChangedDate (date), TrackingNumber (integer), which column is best as primary key?
A. Weight
B. Description
C. LastChangedDate
D. TrackingNumber
Correct Answer: D. TrackingNumber
Rationale: Unique identifier for packages.



Question 3: Which data type stores a date and time without loss of information?
A. DATE
B. DATETIME
C. DECIMAL
D. BIGINT

,Correct Answer: B. DATETIME
Rationale: DATETIME includes time component.



Question 4: Which SQL command is DDL?
A. UPDATE
B. ALTER
C. SELECT
D. DELETE
Correct Answer: B. ALTER
Rationale: DDL modifies structure.



Question 5: What is a database model?
A. Hardware setup
B. Conceptual framework for data structures and operations
C. Programming language
D. Network topology
Correct Answer: B. Conceptual framework for data structures and operations
Rationale: Defines data organization.



Question 6: What is a primary key?
A. Duplicate allowed
B. Unique identifier for each row
C. Index only
D. Foreign key
Correct Answer: B. Unique identifier for each row
Rationale: Ensures uniqueness and no nulls.



Question 7: What is normalization?
A. Denormalization
B. Organizing data to reduce redundancy
C. Adding data
D. Deleting tables
Correct Answer: B. Organizing data to reduce redundancy
Rationale: 1NF to 3NF.

,Question 8: First normal form (1NF) requires:
A. Composite keys
B. Atomic values, no repeating groups
C. Dependencies
D. Transitive dependencies
Correct Answer: B. Atomic values, no repeating groups
Rationale: Single value per cell.



Question 9: Second normal form (2NF) eliminates:
A. Partial dependencies
B. Full dependencies
C. Transitive
D. Anomalies
Correct Answer: A. Partial dependencies
Rationale: Non-key attributes fully dependent.



Question 10: Third normal form (3NF) eliminates:
A. Partial
B. Transitive dependencies
C. Composite keys
D. Repeating groups
Correct Answer: B. Transitive dependencies
Rationale: No non-key to non-key dependencies.



Question 11: What is a foreign key?
A. Primary in another table
B. References primary key in another table
C. Unique
D. Index
Correct Answer: B. References primary key in another table
Rationale: Enforces referential integrity.



Question 12: What is a relational database?
A. NoSQL
B. Tables related by keys
C. Flat file
D. Hierarchical

, Correct Answer: B. Tables related by keys
Rationale: RDBMS like MySQL.



Question 13: What is SQL?
A. Programming language
B. Query language for relational DBs
C. Markup
D. Script
Correct Answer: B. Query language for relational DBs
Rationale: Structured Query Language.



Question 14: DDL stands for:
A. Data Definition Language
B. Data Manipulation Language
C. Data Query Language
D. Data Control Language
Correct Answer: A. Data Definition Language
Rationale: CREATE, ALTER, DROP.



Question 15: DML stands for:
A. Data Definition Language
B. Data Manipulation Language
C. Data Query Language
D. Data Control Language
Correct Answer: B. Data Manipulation Language
Rationale: INSERT, UPDATE, DELETE.



Question 16: DQL stands for:
A. Data Definition Language
B. Data Manipulation Language
C. Data Query Language
D. Data Control Language
Correct Answer: C. Data Query Language
Rationale: SELECT.