WGU D427 DATA MANAGEMENT APPLICATIONS OA EXAM AND STUDY GUIDE LATEST ACTUAL EXAM 430 QUESTIONS AND CORRECT DETAILED ANSWERS WITH RATIONALES (VERIFIED ANSWERS)|ALREADY GRADED A+

3/30/25, 12:30 PM WGU - D427 Data Management - Applications ZyBooks




WGU D427 DATA MANAGEMENT APPLICATIONS OA EXAM AND
STUDY GUIDE LATEST 2024-2025 ACTUAL EXAM 430 QUESTIONS
AND CORRECT DETAILED ANSWERS WITH RATIONALES (VERIFIED
ANSWERS)|ALREADY GRADED A+




7.1 LAB - Alter Movie table ALTER TABLE Movie
ADD Producer VARCHAR(50);
The Movie table has the
following columns: ALTER TABLE Movie
ID - positive integer DROP Genre;
Title - variable-length string
Genre - variable-length ALTER TABLE Movie
string RatingCode - CHANGE Year ReleaseYear SMALLINT;
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.




1/166

,3/30/25, 12:30 PM WGU - D427 Data Management - Applications ZyBooks



7.2 LAB - Insert rows into INSERT INTO Horse (RegisteredName,
Horse table Breed, Height, BirthDate) VALUES ('Babe',
'Quarter Horse', 15.3, '2015-02-10');
The Horse table has the
following columns: ID -
INSERT INTO Horse (RegisteredName,
integer, auto increment,
Breed, Height, BirthDate) VALUES
primary key
('Independence', 'Holsteiner', 16.0, '2017-
RegisteredName -
03-13');
variable-length string
Breed - variable-length INSERT INTO Horse (RegisteredName,
string, must be one of the Breed, Height, BirthDate) VALUES ('Ellie',
following: Egyptian Arab, 'Saddlebred', 15.0, '2016-12-22');
Holsteiner, Quarter Horse,
Paint, Saddlebred INSERT INTO Horse (Breed,
Height - decimal number,
must be between Height, BirthDate) VALUES
10.0 and 20.0 ('Egyptian Arab', 14.9, '2019-10-
BirthDate - date, must be on or 12');
after Jan 1, 2015


Insert the following data
into the Horse table:
RegisteredName Breed Height
7.3 LAB - Update rows in UPDATE
Horse table Horse SET
Height =
The Horse table has the
15.6
following columns: ID -
WHERE ID
integer, auto increment,
= 2;
primary key
RegisteredName -
UPDATE Horse
variable-length string SET RegisteredName = 'Lady
Breed - variable-length Luck', BirthDate = '2015-
string, must be one of the 05-01'
following: Egyptian Arab, WHERE ID = 4;
Holsteiner, Quarter Horse,
Paint, Saddlebred UPDATE
Height - decimal number, Horse SET
must be ≥ 10.0 and ≤ 20.0 Breed =
2/166

,3/30/25, 12:30 PM WGU - D427 Data Management - Applications ZyBooks

BirthDate - date, must be ≥ Jan NULL
1, 2015 WHERE BirthDate >= '2016-12-22';

Make the following updates:
1.- Change the height to 15.6
for horse with ID 2.
2.- Change the registered
name to Lady




7.4 LAB - Delete rows from DELETE
Horse table FROM Horse
WHERE ID =
The Horse table has the
5;
following columns: ID -
integer, auto increment,
DELETE FROM Horse
primary key WHERE Breed IN ('Holsteiner' , 'Paint');
RegisteredName -
variable-length string DELETE FROM Horse
Breed - variable-length string WHERE BirthDate < '2013-03-13';
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.




3/166

, 3/30/25, 12:30 PM WGU - D427 Data Management - Applications ZyBooks



7.5 LAB - Select horses SELECT RegisteredName,
with logical operators Height, BirthDate FROM Horse
WHERE (Height BETWEEN
The Horse table has the 15.0 AND 16.0) OR
following columns:
(BirthDate >= '2020-01-01');
ID - integer, primary key
RegisteredName - variable-
length string
Breed - variable-length string
Height - decimal number
BirthDate - date

Write a SELECT statement
to select the registered
name, height, and birth date
for only horses that have a
height between 15.0 and
16.0 (inclusive) or have a
birth date on or after
January 1, 2020.
7.6 LAB - Create Movie table CREATE TABLE Movie(
ID SMALLINT
Create a Movie table with the UNSIGNED, Title
following columns: VARCHAR(50),
ID - positive integer with Rating
maximum value of 50,000 CHAR(4),
Title - variable-length string ReleaseDate
with up to 50 characters DATE, Budget
Rating - fixed-length DECIMAL(8,2)
string with 4 characters );
ReleaseDate - date
Budget - decimal value
representing a cost of up to
999,999 dollars, with 2
digits for cents




4/166