WGU D427 Data Management
Applications ZyBooks - WGU Exam Study
Guide – Complete Questions with Correct
Detailed Answers | Latest Updated Version
Prepare effectively for your Western Governors University (WGU) exams with this
comprehensive and well-organized study guide. This resource contains complete exam
questions with correct and detailed answers, designed to help students understand key
concepts and successfully prepare for their WGU assessments.
WGU courses follow a competency-based learning model, meaning students must
demonstrate a strong understanding of course objectives before passing their assessments.
This study guide helps simplify the process by providing structured questions and accurate
explanations that reinforce important topics and improve exam readiness.
What This Study Guide Includes
✔ Complete exam questions covering key WGU course competencies
✔ Correct answers with clear and detailed explanations
✔ Organized format for quick and effective revision
✔ Coverage of commonly tested concepts in WGU assessments
✔ Latest updated version for reliable exam preparation
Why This Study Guide Is Helpful
This resource is designed to help students review faster, understand concepts more clearly,
and build confidence before taking WGU Objective Assessments (OA). Practicing with
structured questions and reviewing detailed answers helps strengthen knowledge and
improve test-taking skills.
Ideal For
,• WGU Objective Assessment (OA) preparation
• Midterm and final exam review
• Self-paced study and revision
• Practicing exam-style questions
• Strengthening understanding of course competencies
A valuable study resource designed to support WGU students in preparing effectively and
performing confidently in their exams.
7.1 LAB - Alter Movie table
The Movie table has the following columns:
ID - positive integer
Title - variable-length string
Genre - variable-length string
RatingCode - variable-length string
Year - integer
Write ALTER statements to make the following modifications to the Movie table:
1. Add a Producer column with VARCHAR data type (max 50 chars).
2. Remove the Genre column.
3. Change the Year column's name to ReleaseYear, and change the data type to SMALLINT.
ALTER TABLE Movie
ADD Producer VARCHAR(50);
ALTER TABLE Movie
DROP Genre;
ALTER TABLE Movie
CHANGE Year ReleaseYear SMALLINT;
,7.2 LAB - Insert rows into Horse table
The Horse table has the following columns:
ID - integer, auto increment, primary key
RegisteredName - variable-length string
Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner,
Quarter Horse, Paint, Saddlebred
Height - decimal number, must be between 10.0 and 20.0
BirthDate - date, must be on or after Jan 1, 2015
Insert the following data into the Horse table:
RegisteredName Breed Height
INSERT INTO Horse (RegisteredName, Breed, Height, BirthDate)
VALUES ('Babe', 'Quarter Horse', 15.3, '2015-02-10');
INSERT INTO Horse (RegisteredName, Breed, Height, BirthDate)
VALUES ('Independence', 'Holsteiner', 16.0, '2017-03-13');
INSERT INTO Horse (RegisteredName, Breed, Height, BirthDate)
VALUES ('Ellie', 'Saddlebred', 15.0, '2016-12-22');
INSERT INTO Horse (Breed, Height, BirthDate)
VALUES ('Egyptian Arab', 14.9, '2019-10-12');
7.3 LAB - Update rows in Horse table
The Horse table has the following columns:
ID - integer, auto increment, primary key
RegisteredName - variable-length string
Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner,
Quarter Horse, Paint, Saddlebred
Height - decimal number, must be ≥ 10.0 and ≤ 20.0
BirthDate - date, must be ≥ Jan 1, 2015
Make the following updates:
1.- Change the height to 15.6 for horse with ID 2.
2.- Change the registered name to Lady
, UPDATE Horse
SET Height = 15.6
WHERE ID = 2;
UPDATE Horse
SET RegisteredName = 'Lady Luck',
BirthDate = '2015-05-01'
WHERE ID = 4;
UPDATE Horse
SET Breed = NULL
WHERE BirthDate >= '2016-12-22';
7.4 LAB - Delete rows from Horse table
The Horse table has the following columns:
ID - integer, auto increment, primary key
RegisteredName - variable-length string
Breed - variable-length string
Height - decimal number
BirthDate - date
Delete the following rows:
1.- Horse with ID 5.
2.- All horses with breed Holsteiner or Paint.
3.- All horses born before March 13, 2013.
DELETE FROM Horse
WHERE ID = 5;
DELETE FROM Horse
WHERE Breed IN ('Holsteiner' , 'Paint');
DELETE FROM Horse
WHERE BirthDate < '2013-03-13';
7.5 LAB - Select horses with logical operators
Applications ZyBooks - WGU Exam Study
Guide – Complete Questions with Correct
Detailed Answers | Latest Updated Version
Prepare effectively for your Western Governors University (WGU) exams with this
comprehensive and well-organized study guide. This resource contains complete exam
questions with correct and detailed answers, designed to help students understand key
concepts and successfully prepare for their WGU assessments.
WGU courses follow a competency-based learning model, meaning students must
demonstrate a strong understanding of course objectives before passing their assessments.
This study guide helps simplify the process by providing structured questions and accurate
explanations that reinforce important topics and improve exam readiness.
What This Study Guide Includes
✔ Complete exam questions covering key WGU course competencies
✔ Correct answers with clear and detailed explanations
✔ Organized format for quick and effective revision
✔ Coverage of commonly tested concepts in WGU assessments
✔ Latest updated version for reliable exam preparation
Why This Study Guide Is Helpful
This resource is designed to help students review faster, understand concepts more clearly,
and build confidence before taking WGU Objective Assessments (OA). Practicing with
structured questions and reviewing detailed answers helps strengthen knowledge and
improve test-taking skills.
Ideal For
,• WGU Objective Assessment (OA) preparation
• Midterm and final exam review
• Self-paced study and revision
• Practicing exam-style questions
• Strengthening understanding of course competencies
A valuable study resource designed to support WGU students in preparing effectively and
performing confidently in their exams.
7.1 LAB - Alter Movie table
The Movie table has the following columns:
ID - positive integer
Title - variable-length string
Genre - variable-length string
RatingCode - variable-length string
Year - integer
Write ALTER statements to make the following modifications to the Movie table:
1. Add a Producer column with VARCHAR data type (max 50 chars).
2. Remove the Genre column.
3. Change the Year column's name to ReleaseYear, and change the data type to SMALLINT.
ALTER TABLE Movie
ADD Producer VARCHAR(50);
ALTER TABLE Movie
DROP Genre;
ALTER TABLE Movie
CHANGE Year ReleaseYear SMALLINT;
,7.2 LAB - Insert rows into Horse table
The Horse table has the following columns:
ID - integer, auto increment, primary key
RegisteredName - variable-length string
Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner,
Quarter Horse, Paint, Saddlebred
Height - decimal number, must be between 10.0 and 20.0
BirthDate - date, must be on or after Jan 1, 2015
Insert the following data into the Horse table:
RegisteredName Breed Height
INSERT INTO Horse (RegisteredName, Breed, Height, BirthDate)
VALUES ('Babe', 'Quarter Horse', 15.3, '2015-02-10');
INSERT INTO Horse (RegisteredName, Breed, Height, BirthDate)
VALUES ('Independence', 'Holsteiner', 16.0, '2017-03-13');
INSERT INTO Horse (RegisteredName, Breed, Height, BirthDate)
VALUES ('Ellie', 'Saddlebred', 15.0, '2016-12-22');
INSERT INTO Horse (Breed, Height, BirthDate)
VALUES ('Egyptian Arab', 14.9, '2019-10-12');
7.3 LAB - Update rows in Horse table
The Horse table has the following columns:
ID - integer, auto increment, primary key
RegisteredName - variable-length string
Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner,
Quarter Horse, Paint, Saddlebred
Height - decimal number, must be ≥ 10.0 and ≤ 20.0
BirthDate - date, must be ≥ Jan 1, 2015
Make the following updates:
1.- Change the height to 15.6 for horse with ID 2.
2.- Change the registered name to Lady
, UPDATE Horse
SET Height = 15.6
WHERE ID = 2;
UPDATE Horse
SET RegisteredName = 'Lady Luck',
BirthDate = '2015-05-01'
WHERE ID = 4;
UPDATE Horse
SET Breed = NULL
WHERE BirthDate >= '2016-12-22';
7.4 LAB - Delete rows from Horse table
The Horse table has the following columns:
ID - integer, auto increment, primary key
RegisteredName - variable-length string
Breed - variable-length string
Height - decimal number
BirthDate - date
Delete the following rows:
1.- Horse with ID 5.
2.- All horses with breed Holsteiner or Paint.
3.- All horses born before March 13, 2013.
DELETE FROM Horse
WHERE ID = 5;
DELETE FROM Horse
WHERE Breed IN ('Holsteiner' , 'Paint');
DELETE FROM Horse
WHERE BirthDate < '2013-03-13';
7.5 LAB - Select horses with logical operators
