WGU D427 DATA Management Applications Objective Assessment Study Guide questions fully solved

WGU D427 DATA Management
Applications Objective
Assessment Study Guide
questions fully solved & updated
2025

The Member table will have the following columns:
ID—positive integer
FirstName—variable-length string with up to 100
characters
MiddleInitial—fixed-length string with 1 character
LastName—variable-length string with up to 100
characters
DateOfBirth—date
AnnualPledge—positive decimal value representing
a cost of up to $999,999, with 2 digits for cents
Write a SQL statement to create the Member table.
- answer CREATE TABLE Member(
ID INT UNSIGNED,
FirstName VARCHAR(100),
MiddleInitial CHAR(1),
LastName VARCHAR(100),
DateOfBirth DATE,

,AnnualPledge DECIMAL(8,2) UNSIGNED
);


The Rating table has the following columns:
RatingCode—variable-length string, primary key
RatingDescription—variable-length string
The Movie table should have the following
columns:
Title—variable-length string, maximum 30
characters
RatingCode—variable-length string, maximum 5
characters
Write a SQL statement to create the Movie table.
Designate the RatingCode column in the Movie
table as a foreign key to the RatingCode column in
the Rating table. - answer CREATE TABLE Movie(
Title VARCHAR(30),
RatingCode VARCHAR(5),
FOREIGN KEY (RatingCode) REFERENCES
Rating(RatingCode)
);


The Movie table has the following columns:
ID—integer, primary key
Title—variable-length string

, Genre—variable-length string
RatingCode—variable-length string
Year—integer
A new column must be added to the Movie table:
Column name: Score
Data type: decimal(3,1)
Write a SQL statement to add the Score column to
the Movie table. - answer ALTER TABLE Movie
ADD Score DECIMAL(3,1);


The Movie table has the following columns:
ID—integer, primary key
Title—variable-length string
Genre—variable-length string
RatingCode—variable-length string
Year—integer
Write a SQL statement to create a view named
MyMovies that contains the Title, Genre, and Year
columns for all movies. Ensure your result set
returns the columns in the order indicated. -
answer CREATE VIEW MyMovies AS
SELECT Title, Genre, Year
FROM Movie;