WGU - D427 - (Latest 2025/2026 Update) Data Management - Applications – ZyBooks Labs 7 and 8 Study Guide with Questions and Certified Answers | 100% Correct | A Grade - WGU

1

WGU - D427 - (Latest 2025/2026
Update) Data Management -
Applications – ZyBooks Labs 7 and 8
Study Guide with Questions and
Certified Answers | 100% Correct | A
Grade - WGU


Quiz_________________?
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. -

Answer☑️

ALTER TABLE Movie
ADD Producer VARCHAR(50);

, ALTER TABLE Movie
2
DROP Genre;


ALTER TABLE Movie
CHANGE Year ReleaseYear SMALLINT;


Quiz_________________?
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 -

Answer☑️
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');
3


Quiz_________________?
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 -

Answer☑️

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';