WGU C175 or D426 DATA MANAGEMENT FOUNDATIONS OA EXAM ACTUAL EXAM 2 Versions-with 100% verified solutions-2023

lOMoARcPSD|28964921




Data Management Foundations D426 - Lab Answers


Data Management Foundations (Western Governors University)




Studocu is not sponsored or endorsed by any college or university
Downloaded by john gatheca ()

, lOMoARcPSD|28964921




2.13

CREATE TABLE Movie (

ID SMALLINT UNSIGNED,

Title VARCHAR(50),

Ra琀椀ng CHAR(4),

ReleaseDate DATE,

Budget DECIMAL(8,2)

);



2.14

ALTER TABLE Movie

Add Producer VARCHAR(50),

DROP Genre,

CHANGE Year ReleaseYear SMALLINT;



2.15

SELECT RegisteredName,Height,BirthDate

FROM Horse

WHERE Height>='15.0' AND Height<='16.0' OR

BirthDate>='2020-01-01';



2.16

INSERT INTO Horse (RegisteredName,Breed,Height,BirthDate) VALUES

('Babe','Quarter Horse','15.3','2015-02-10'),

('Independence','Holsteiner','16.0','2017-03-13'),

('Ellie','Saddlebred','15.0','2016-12-22'),

(NULL,'Egyp琀椀an Arab','14.9','2019-10-12');




Downloaded by john gatheca ()