1|Page
WGU D427 OA Final Exam Data Management -
Applications Exam Newest 2025-2026 / WGU D427 OA
Final Exam Data Management -Applications Exam
Preparation /WGU D427 OA Final Exam Data
Management -Applications Practice Exam With 500
Complete Questions And Correct Answers| Brand New
Version!
The Movie table has the following columns:
ID—integer, primary key, auto-increment
Title—variable-length string
Genre—variable-length string
RatingCode—variable-length string
Year—integer
The following data needs to be added to the Movie table:
,2|Page
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 WHERE ID = 3;
The Movie table has the following columns:
ID—integer, primary key
Title—variable-length string
Genre—variable-length string
RatingCode—variable-length string
,3|Page
Year—integer
Write a SQL statement to update the Year value to be 2022 for all
movies with a Year value of 2020. - ANSWER- UPDATE Movie
SET Year = 2022
WHERE Year = 2020;
The database contains a table named Movie.
Write a SQL query to return all data from the Movie table without
directly referencing any column names. - ANSWER- SELECT * FROM
Movie;
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 query to retrieve the Title and Genre values for all records
in the Movie table with a Year value of 2020. Ensure your result set
returns the columns in the order indicated. - ANSWER- SELECT Title,
Genre
, 4|Page
FROM Movie
WHERE Year = 2020;
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 query to display all Title values in alphabetical order A-Z. -
ANSWER- SELECT Title
FROM Movie
ORDER BY Title ASC;
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
WGU D427 OA Final Exam Data Management -
Applications Exam Newest 2025-2026 / WGU D427 OA
Final Exam Data Management -Applications Exam
Preparation /WGU D427 OA Final Exam Data
Management -Applications Practice Exam With 500
Complete Questions And Correct Answers| Brand New
Version!
The Movie table has the following columns:
ID—integer, primary key, auto-increment
Title—variable-length string
Genre—variable-length string
RatingCode—variable-length string
Year—integer
The following data needs to be added to the Movie table:
,2|Page
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 WHERE ID = 3;
The Movie table has the following columns:
ID—integer, primary key
Title—variable-length string
Genre—variable-length string
RatingCode—variable-length string
,3|Page
Year—integer
Write a SQL statement to update the Year value to be 2022 for all
movies with a Year value of 2020. - ANSWER- UPDATE Movie
SET Year = 2022
WHERE Year = 2020;
The database contains a table named Movie.
Write a SQL query to return all data from the Movie table without
directly referencing any column names. - ANSWER- SELECT * FROM
Movie;
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 query to retrieve the Title and Genre values for all records
in the Movie table with a Year value of 2020. Ensure your result set
returns the columns in the order indicated. - ANSWER- SELECT Title,
Genre
, 4|Page
FROM Movie
WHERE Year = 2020;
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 query to display all Title values in alphabetical order A-Z. -
ANSWER- SELECT Title
FROM Movie
ORDER BY Title ASC;
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
