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

WGU D427 DATA MANAGEMENT APPLICATIONS OA

EXAM AND STUDY GUIDE LATEST 2024 ACTUAL

EXAM 400 QUESTIONS AND CORRECT DETAILED

ANSWERS WITH RATIONALES(VERIFIED

ANSWERS)|ALREADY GRADED A+

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