.png){kind=logo}
WGU D427 DATA MANAGEMENT APPLICATIONS OA EXAM AND STUDY GUIDE 2026 400 QUESTIONS AND ( ANSWERS)
WGU D427 DATA MANAGEMENT APPLICATIONS OA
EXAM AND STUDY GUIDE 2026
EXAM 400 QUESTIONS AND CORRECT DETAILED
ANSWERS WITH RATIONALES(
ANSWERS)
WGU D427 DATA MANAGEMENT APPLICATIONS OA EXAM
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:
Add a Producer column with VARCHAR data type (max 50 chars). -
ANSWER- ALTER TABLE Movie ADD Producer VARCHAR(50);
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:
Remove the Genre column. - ANSWER- ALTER TABLE Movie DROP
COLUMN Genre;
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:
Change the Year column's name to ReleaseYear, and change the data
type to SMALLINT. - ANSWER- ALTER TABLE Movie CHANGE
COLUMN Year ReleaseYear SMALLINT;
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:
- Add a Producer column with VARCHAR data type (max 50 chars).
- Remove the Genre column.
- 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 DROP COLUMN Genre;
ALTER TABLE Movie CHANGE COLUMN Year ReleaseYear
SMALLINT;
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 BirthDate
Babe Quarter Horse 15.3 2015-02-10
Independence Holsteiner 16.0 2017-03-13
Ellie Saddlebred 15.0 2016-12-22
NULL Egyptian Arab 14.9 2019-10-12 - ANSWER- INSERT INTO
Horse (RegisteredName, Breed, Height, BirthDate) VALUES
('Babe', 'Quarter Horse', 15.3, '2015-02-10'),
('Independence', 'Holsteiner', 16.0, '2017-03-13'),
('Ellie', 'Saddlebred', 15.0, '2016-12-22'),
(NULL, 'Egyptian Arab', 14.9, '2019-10-12');
The Horse table has the following columns:
ID - integer, auto increment, primary key
RegisteredName - variable-length string
.png)