Latest Update Data - (Latest Update) Data Management – Applications |

D427 / D 427 Pre - Assessment V2 (Latest Update 2025 / 2026) Data Management – Applications | Questions and Answers | Grade A | 100% Correct (Verified Answers) - WGU

Question:

A.1

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.Do not add any additional constraints to any column beyond what is stated.

Answer: 1 / 4

Create Table Member (

ID INT UNSIGNED,

FirstName VARCHAR(100), MiddleInitial CHAR(1), LastName VARCHAR(100), DateOfBirth DATE, AnnualPledge DECIMAL(8,2) UNSIGNED );

Question:

A.2

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), 2 / 4

RatingCode VARCHAR (5), FOREIGN KEY (RatingCode) REFERENCES Rating(RatingCode) );

Question:

A.3

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);

• / 4

Question:

A.4

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;

Question:

A.5 A database has a view named MovieView.Write a SQL statement to delete the view named MovieView from the database.

Answer:

DROP VIEW Movieview;

• / 4