WGU D427 – Data Management Applications |
Questions and well detailed Answers | A+ Graded
| 2026 Update | 100% correct
✅ FULL PRACTICE SET (25 Questions)
SECTION 1: Database Design & Concepts
Q1. Entity Identification
Children living within the boundaries of two school districts will be attending one of four different
schools.
How many entities are present?
Options:
A. 2
B. 3
C. 4
D. 6
Entities: Children, School Districts, Schools
🧠 Memory tip: Entities = nouns
Q2. Relationship Cardinality
A data set currently contains horse details. A new requirement specifies that horses can be
entered into competitions.
What is the cardinality of the horse-to-competition relationship?
Options:
A. One-to-one
B. One-to-many
C. Many-to-one
D. Many-to-many
,One horse → many competitions
One competition → many horses
Q3. Data Types
Which data type will store 2022-01-10 14:22:12 as a temporal value without loss of
information?
Options:
A. DATE
B. DATETIME
C. DECIMAL
D. BIGINT
Q4. What is a primary function of a Database Management System (DBMS)?
Options:
A. Encrypting user passwords
B. Managing operating system updates
C. Storing, retrieving, and managing data
D. Designing user interfaces
Q5. What is the role of SQL in a database system?
Options:
A. Creating graphics for dashboards
B. Scripting language for web pages
C. Managing internet traffic
D. Querying and manipulating data
Q6. Which term refers to a unique identifier for a record in a database table?
Options:
A. Foreign key
B. Primary key
C. Composite key
D. Index
, Q7. The Package table has the following columns:
● Weight , Description
● LastChangedDate, TrackingNumber
Which column should be designated as the primary key?
Options:
A. Weight B. Description
C. LastChangedDate D. TrackingNumber
SECTION 2: DDL (CREATE / ALTER / INDEX)
Q8. Foreign Key (SQL Writing)
The Movie table has columns:
ID, Title, Genre, RatingCode, Year
The YearStats table has columns: Year,
TotalGross, Releases
Write an SQL statement to designate the Year column in the Movie table as a foreign key
referencing the YearStats table.
✍ Write SQL
ALTER TABLE Movie
ADD CONSTRAINT fk_movie_year
FOREIGN KEY (Year)
REFERENCES YearStats(Year);
ALTER TABLE → modifies existing table
FOREIGN KEY (Year) → column in Movie
REFERENCES YearStats(Year) → parent table + column
Questions and well detailed Answers | A+ Graded
| 2026 Update | 100% correct
✅ FULL PRACTICE SET (25 Questions)
SECTION 1: Database Design & Concepts
Q1. Entity Identification
Children living within the boundaries of two school districts will be attending one of four different
schools.
How many entities are present?
Options:
A. 2
B. 3
C. 4
D. 6
Entities: Children, School Districts, Schools
🧠 Memory tip: Entities = nouns
Q2. Relationship Cardinality
A data set currently contains horse details. A new requirement specifies that horses can be
entered into competitions.
What is the cardinality of the horse-to-competition relationship?
Options:
A. One-to-one
B. One-to-many
C. Many-to-one
D. Many-to-many
,One horse → many competitions
One competition → many horses
Q3. Data Types
Which data type will store 2022-01-10 14:22:12 as a temporal value without loss of
information?
Options:
A. DATE
B. DATETIME
C. DECIMAL
D. BIGINT
Q4. What is a primary function of a Database Management System (DBMS)?
Options:
A. Encrypting user passwords
B. Managing operating system updates
C. Storing, retrieving, and managing data
D. Designing user interfaces
Q5. What is the role of SQL in a database system?
Options:
A. Creating graphics for dashboards
B. Scripting language for web pages
C. Managing internet traffic
D. Querying and manipulating data
Q6. Which term refers to a unique identifier for a record in a database table?
Options:
A. Foreign key
B. Primary key
C. Composite key
D. Index
, Q7. The Package table has the following columns:
● Weight , Description
● LastChangedDate, TrackingNumber
Which column should be designated as the primary key?
Options:
A. Weight B. Description
C. LastChangedDate D. TrackingNumber
SECTION 2: DDL (CREATE / ALTER / INDEX)
Q8. Foreign Key (SQL Writing)
The Movie table has columns:
ID, Title, Genre, RatingCode, Year
The YearStats table has columns: Year,
TotalGross, Releases
Write an SQL statement to designate the Year column in the Movie table as a foreign key
referencing the YearStats table.
✍ Write SQL
ALTER TABLE Movie
ADD CONSTRAINT fk_movie_year
FOREIGN KEY (Year)
REFERENCES YearStats(Year);
ALTER TABLE → modifies existing table
FOREIGN KEY (Year) → column in Movie
REFERENCES YearStats(Year) → parent table + column
