WGU – D427 DATA MANAGEMENT – APPLICATIONS ZYBOOKS LABS
7&8 LATEST EXAM QUESTIONS AND ANSWERS 2025-2026 VERIFIED BY
EXPERTS AND ALREADY GRADED A+
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');
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';
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
7&8 LATEST EXAM QUESTIONS AND ANSWERS 2025-2026 VERIFIED BY
EXPERTS AND ALREADY GRADED A+
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');
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';
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
