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

3/10/25, 5:09 PM WGU - D427 Data Management - Applications ZyBooks Labs 7 and 8




WGU D427 DATA MANAGEMENT APPLICATIONS OA EXAM AND
STUDY GUIDE LATEST 2024-2025 ACTUAL EXAM 400
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/98

,3/10/25, 5:09 PM WGU - D427 Data Management - Applications ZyBooks Labs 7 and 8



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/98

,3/10/25, 5:09 PM WGU - D427 Data Management - Applications ZyBooks Labs 7 and 8

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/98

, 3/10/25, 5:09 PM WGU - D427 Data Management - Applications ZyBooks Labs 7 and 8



7.10 LAB - Rollback and START TRANSACTION;
savepoint (Sakila)
INSERT INTO actor
Refer to the actor table of VALUES (999, 'NICOLE', 'STREEP', '2021-06-01 12:00:00');
the Sakila database. The
table in this lab has the same SAVEPOINT my_savepoint;
columns and data types but
fewer rows. DELETE FROM
actor WHERE
Start a transaction and: first_name =
Insert a new actor with 'CUBA';
values 999, 'NICOLE',
'STREEP', '2021-06-01 SELECT *
12:00:00' Set a FROM actor;
SAVEPOINT. ROLLBACK TO SAVEPOINT
Delete the actor with first
my_savepoint; SELECT *
name 'CUBA'. Select all
FROM actor;
actors.
Roll back to the
savepoint. Select all
actors a second time


The actor with first name
'CUBA' should appear in the
second SELECT but not the
first.


8.1 Practice Lab 1 CREATE TABLE
Member ( ID
The Member table will have INT
the following columns: UNSIGNED,
ID—positive integer
FirstName
FirstName—variable-length
VARCHAR(100),
string with up to 100
MiddleInitial
characters
CHAR(1),
MiddleInitial—fixed-length
LastName
string with 1 character
VARCHAR(100),
LastName—variable-length DateOfBirth DATE,
/ 4/98