1|Page
WGU D427 OA FINAL EXAM DATA MANAGEMENT APPLICATIONS
EXAM NEWEST 2026 ACTUAL EXAM WITH COMPLETE QUESTIONS
AND CORRECT DETAILED ANSWERS (100% VERIFIED ANSWERS)
|ALREADY GRADED A+| ||PROFESSOR VERIFIED||
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;
The Movie table has the following columns:
ID—integer,
Title—variable-length string,
,2|Page
Genre—variable-length string,
RatingCode—variable-length string,
Year—integer,
Write a SQL statement to modify the Movie table to make the ID
column the primary key. - ANSWER-ALTER TABLE Movie
ADD PRIMARY KEY (ID);
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,
The YearStats table has the following columns:
Year—integer,
TotalGross—bigint unsigned,
Releases—integer,
,3|Page
Write a SQL statement to designate the Year column in the Movie
table as a foreign key to the Year column in the YearStats table. -
ANSWER-ALTER TABLE Movie
ADD CONSTRAINT Year FOREIGN KEY (Year)
References YearStats(Year);
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 an index named idx_year on the
Year column of the Movie table. - ANSWER-CREATE INDEX
idx_year ON Movie (Year);
The Movie table has the following columns:
ID—integer, primary key, auto-increment,
Title—variable-length string,
, 4|Page
Genre—variable-length string,
RatingCode—variable-length string,
Year—integer,
The following data needs to be added to the Movie table:
Title Genre RatingCode Year,
Pride and Prejudice Romance G 2005,
Write a SQL statement to insert the indicated data into the Movie
table. - ANSWER-INSERT INTO Movie (Title, Genre, RatingCode,
Year)
VALUES ('Pride and Prejudice', 'Romance', 'G', 2005);
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 delete the row with the ID value of 3
from the Movie table. - ANSWER-DELETE FROM Movie
WGU D427 OA FINAL EXAM DATA MANAGEMENT APPLICATIONS
EXAM NEWEST 2026 ACTUAL EXAM WITH COMPLETE QUESTIONS
AND CORRECT DETAILED ANSWERS (100% VERIFIED ANSWERS)
|ALREADY GRADED A+| ||PROFESSOR VERIFIED||
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;
The Movie table has the following columns:
ID—integer,
Title—variable-length string,
,2|Page
Genre—variable-length string,
RatingCode—variable-length string,
Year—integer,
Write a SQL statement to modify the Movie table to make the ID
column the primary key. - ANSWER-ALTER TABLE Movie
ADD PRIMARY KEY (ID);
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,
The YearStats table has the following columns:
Year—integer,
TotalGross—bigint unsigned,
Releases—integer,
,3|Page
Write a SQL statement to designate the Year column in the Movie
table as a foreign key to the Year column in the YearStats table. -
ANSWER-ALTER TABLE Movie
ADD CONSTRAINT Year FOREIGN KEY (Year)
References YearStats(Year);
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 an index named idx_year on the
Year column of the Movie table. - ANSWER-CREATE INDEX
idx_year ON Movie (Year);
The Movie table has the following columns:
ID—integer, primary key, auto-increment,
Title—variable-length string,
, 4|Page
Genre—variable-length string,
RatingCode—variable-length string,
Year—integer,
The following data needs to be added to the Movie table:
Title Genre RatingCode Year,
Pride and Prejudice Romance G 2005,
Write a SQL statement to insert the indicated data into the Movie
table. - ANSWER-INSERT INTO Movie (Title, Genre, RatingCode,
Year)
VALUES ('Pride and Prejudice', 'Romance', 'G', 2005);
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 delete the row with the ID value of 3
from the Movie table. - ANSWER-DELETE FROM Movie
