Wgu_D427_Advanced_Database_Systems_2026_Study_Guide_Questions_With

WGU D427 ADVANCED DATABASE
SYSTEMS 2026 STUDY GUIDE QUESTIONS
WITH CORRECT ANSWERS GRADED A+

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

,⩥ 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%";


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

, ⩥ List the next five Pixar movies sorted alphabetically


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