WGU D427 - DATA MANAGEMENT APPLICATIONS
EXAM QUESTIONS AND 100% CORRECT ANSWERS
(A+) 2025
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).
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.
,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.
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.
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
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
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:
Change the height to 15.6 for horse with ID 2.
UPDATE Horse
SET Height = 15.6
WHERE ID = 2;
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
EXAM QUESTIONS AND 100% CORRECT ANSWERS
(A+) 2025
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).
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.
,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.
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.
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
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
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:
Change the height to 15.6 for horse with ID 2.
UPDATE Horse
SET Height = 15.6
WHERE ID = 2;
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
