WGU D427 DATA MANAGEMENT APPLICATIONS ZYBOOKS LABS 7 & 8 QUESTI… EXAM
P R O F E S S I O N A L P R A C T I C E M AT E R I A L S
WGU D427 Data
Management Applications
ZyBooks Labs 7 & 8
Questions & Answers 2026-
2027 | Verified
Verified Answers Exam Ready With Rationales
27 QUESTIONS
DOCUMENT OVERVIEW
This document provides 27 verified questions with correct answers related to data management
applications, ensuring a comprehensive understanding of SQL concepts and practices. Covering
essential database operations, it is an ideal resource for students seeking to enhance their knowledge in
database management. Students can utilize this material for effective study, review, and preparation for
certification exams.
CONTENTS
Movie Table Operations Q1–Q8
Horse Table Operations Q9–Q12
Student Table Management Q13–Q13
Practice Labs Q14–Q27
Page 1
, E XA M Q U EST I O N S
Q1 QUESTION 1 OF 27
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.
CORRECT ANSWER
ALTER TABLE Movie
ADD Producer VARCHAR(50);
ALTER TABLE Movie
DROP Genre;
ALTER TABLE Movie
CHANGE Year ReleaseYear SMALLINT;
Q2 QUESTION 2 OF 27
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
Page 2
P R O F E S S I O N A L P R A C T I C E M AT E R I A L S
WGU D427 Data
Management Applications
ZyBooks Labs 7 & 8
Questions & Answers 2026-
2027 | Verified
Verified Answers Exam Ready With Rationales
27 QUESTIONS
DOCUMENT OVERVIEW
This document provides 27 verified questions with correct answers related to data management
applications, ensuring a comprehensive understanding of SQL concepts and practices. Covering
essential database operations, it is an ideal resource for students seeking to enhance their knowledge in
database management. Students can utilize this material for effective study, review, and preparation for
certification exams.
CONTENTS
Movie Table Operations Q1–Q8
Horse Table Operations Q9–Q12
Student Table Management Q13–Q13
Practice Labs Q14–Q27
Page 1
, E XA M Q U EST I O N S
Q1 QUESTION 1 OF 27
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.
CORRECT ANSWER
ALTER TABLE Movie
ADD Producer VARCHAR(50);
ALTER TABLE Movie
DROP Genre;
ALTER TABLE Movie
CHANGE Year ReleaseYear SMALLINT;
Q2 QUESTION 2 OF 27
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
Page 2
