WGU D427 Data Management – Applications | MYSQL - SQL Programing - Intermediate Level | 2025 Update with complete solutions.

6/11/25, 1:42 AM Data Management - Applications D427 - MYSQL - SQL Programing - Intermediate Level




WGU D427 Data Management – Applications | MYSQL - SQL
Programing - Intermediate Level | 2025 Update with
complete solutions.



Correct

Incorrect


WGU D427 Data Management - Applications

107 Correct terms




Questions and answers

,6/11/25, 1:42 AM Data Management - Applications D427 - MYSQL - SQL Programing - Intermediate Level


1 of 107

Term


Create a Movie table with the following columns:
ID - positive integer with maximum value of 50,000,
Title - variable-length string with up to 50 characters,
Rating - fixed-length string with 4 characters,
ReleaseDate - date,
Budget - decimal value representing a cost of up to 999,999 dollars,
with 2 digits for cents,



Give this one a go later!



CREATE TABLE Orders (
OrderID int NOT NULL,
OrderNumber int NOT NULL,
PersonID int,
PRIMARY KEY (OrderID),
FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)
);




CREATE TABLE Persons (
ID int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int,
CONSTRAINT PK_Person PRIMARY KEY (ID,LastName)
);

,6/11/25, 1:42 AM Data Management - Applications D427 - MYSQL - SQL Programing - Intermediate Level

CREATE TABLE Member (
ID INT PRIMARY KEY unsigned,
FirstName VARCHAR(100),
MiddleInitial CHAR(1),
LastName VARCHAR(100),
DateOfBirth DATE,
AnnualPledge DECIMAL(8, 2) unsigned
);
CREATE TABLE Movie (
ID SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
Title VARCHAR(50),
Rating CHAR(4),
ReleaseDate DATE,
Budget DECIMAL(8, 2) CHECK (Budget >= 0 AND Budget <= 999999)
);


Don't know?




2 of 107

Term



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



Give this one a go later!



DELETE FROM Table_name WHERE Condition;




SELECT * FROM Book;

, 6/11/25, 1:42 AM Data Management - Applications D427 - MYSQL - SQL Programing - Intermediate Level


DROP VIEW BookView;




SELECT LS.LessonDateTime, S.FirstName, S.LastName, H.RegisteredName FROM
LessonSchedule LS LEFT JOIN Student S ON LS.StudentID = S.ID LEFT JOIN Horse H
ON LS.HorseID = H.ID WHERE LS.LessonDateTime >= '2020-02-01' AND
LS.LessonDateTime < '2020-02-02' ORDER BY LS.LessonDateTime ASC,
H.RegisteredName ASC;


Don't know?




3 of 107

Term


The Book table has the following columns:
ID—integer, primary key,
Title—variable-length string,
Genre—variable-length string,
Year—integer,
The YearSales table has the following columns:
Year—integer,
TotalSales—bigint unsigned,
Releases—integer,
Write a SQL statement to designate the Year column in the Book table
as a foreign key to the Year column in the TotalSales table.



Give this one a go later!