Page 1 of 52
D427 WGU DATA MANAGEMENT
APPLICATIONS| WGU D427 PRACTICE EXAM
QUESTIONS WITH ANSWERS
Find the movies not released in the years between 2000 and 2010
Movies Table:
Id
Title
Director
Year
Length_minutes -- ANSWER--SELECT title, year FROM movies
WHERE year < 2000 OR year > 2010;
Find all Toy Story movies.
Movies Table:
Id
Title
Director
Year
Length_minutes -- ANSWER--SELECT title, director FROM movies
WHERE title LIKE "Toy Story%";
,Page 2 of 52
List all directors of Pixar movies (alphabetically), without duplicates
Movies Table:
Id
Title
Director
Year
Length_minutes -- ANSWER--SELECT DISTINCT Director
FROM Movies
ORDER BY Director ASC;
List the last four Pixar movies released (ordered from most recent to least)
Movies Table:
Id
Title
Director
Year
Length_minutes -- ANSWER--SELECT Title, Year FROM Movies
ORDER BY Year DESC
LIMIT 4;
Find the title of each Movies Table:
Id
,Page 3 of 52
Title
Director
Year
Length_minutes -- ANSWER--SELECT title FROM movies;
Find the title and director of each film
Movies Table:
Id
Title
Director
Year
Length_minutes -- ANSWER--SELECT title, director FROM movies;
Find the movie with a row id of 6
Movies Table:
Id
Title
Director
Year
Length_minutes -- ANSWER--SELECT Id, Title FROM Movies WHERE Id = 6;
List the next five Pixar movies sorted alphabetically
, Page 4 of 52
Movies Table:
Id
Title
Director
Year
Length_minutes -- ANSWER--SELECT title
FROM movies
ORDER BY title ASC
LIMIT 5 OFFSET 5;
List all buildings and the distinct employee roles in each building (including empty buildings)
Buildings Table:
Building_name, Capacity
Employees Table:
Role, Name, Building, Years_employed -- ANSWER--SELECT DISTINCT building_name,
role
FROM buildings
LEFT JOIN employees
ON building_name = building;
Find the name and role of all employees who have not been assigned to a building
Buildings Table:
Building_name, Capacity
D427 WGU DATA MANAGEMENT
APPLICATIONS| WGU D427 PRACTICE EXAM
QUESTIONS WITH ANSWERS
Find the movies not released in the years between 2000 and 2010
Movies Table:
Id
Title
Director
Year
Length_minutes -- ANSWER--SELECT title, year FROM movies
WHERE year < 2000 OR year > 2010;
Find all Toy Story movies.
Movies Table:
Id
Title
Director
Year
Length_minutes -- ANSWER--SELECT title, director FROM movies
WHERE title LIKE "Toy Story%";
,Page 2 of 52
List all directors of Pixar movies (alphabetically), without duplicates
Movies Table:
Id
Title
Director
Year
Length_minutes -- ANSWER--SELECT DISTINCT Director
FROM Movies
ORDER BY Director ASC;
List the last four Pixar movies released (ordered from most recent to least)
Movies Table:
Id
Title
Director
Year
Length_minutes -- ANSWER--SELECT Title, Year FROM Movies
ORDER BY Year DESC
LIMIT 4;
Find the title of each Movies Table:
Id
,Page 3 of 52
Title
Director
Year
Length_minutes -- ANSWER--SELECT title FROM movies;
Find the title and director of each film
Movies Table:
Id
Title
Director
Year
Length_minutes -- ANSWER--SELECT title, director FROM movies;
Find the movie with a row id of 6
Movies Table:
Id
Title
Director
Year
Length_minutes -- ANSWER--SELECT Id, Title FROM Movies WHERE Id = 6;
List the next five Pixar movies sorted alphabetically
, Page 4 of 52
Movies Table:
Id
Title
Director
Year
Length_minutes -- ANSWER--SELECT title
FROM movies
ORDER BY title ASC
LIMIT 5 OFFSET 5;
List all buildings and the distinct employee roles in each building (including empty buildings)
Buildings Table:
Building_name, Capacity
Employees Table:
Role, Name, Building, Years_employed -- ANSWER--SELECT DISTINCT building_name,
role
FROM buildings
LEFT JOIN employees
ON building_name = building;
Find the name and role of all employees who have not been assigned to a building
Buildings Table:
Building_name, Capacity
