WGUl D427l Objectivel Assessmentl Latestl

WGUl D427l Objectivel Assessmentl (Latestl 2025/l 2026l Update)l Datal Managementl –l Applicationsl Review|l Questionsl &l Answers|l Gradel A|l 100%l Correctl (Verifiedl Solutions)

Q:l Whichl ofl thel followingl arel truel aboutl al materializedl viewl (Choosel 2)?⦁l Itl isl al basel table.⦁l Itl isl stored.⦁l Itl mustl bel refreshedl wheneverl thel basel tablel changes.⦁l Thel resultsl arel storedl asl al temporaryl table.

Answer:

⦁l Itl isl stored.⦁l Itl mustl bel refreshedl wheneverl thel basel tablel changes.

Q:l Thel Studentl tablel willl havel thel followingl columns: StudentID—positivel integer FirstName—variable-lengthl stringl withl upl tol 50l characters MiddleInitial—fixed-lengthl stringl withl 1l character LastName—variable-lengthl stringl withl upl tol 50l characters DateOfBirth—date AccountBalance—positivel decimall valuel representingl al balancel ofl upl tol $24,999,l withl 2l digitsl forl cents Writel al SQLl statementl tol createl thel Studentl table.Dol notl addl anyl additionall constraintsl tol anyl columnl beyondl whatl isl stated.

Answer:

CREATEl TABLEl Studentl ( l StudentIDl INTl UNSIGNED, l FirstNamel VARCHAR(50), l MiddleInitiall CHAR(1), l LastNamel VARCHAR(50), l DateOfBirthl DATE, l AccountBalancel DECIMAL(7,2)l UNSIGNEDl 1 / 4

l CHECKl (AccountBalancel <=l 24999.99)l ORl CHECKl (AccountBalancel

Q:l Thel Classificationl tablel hasl thel followingl columns: ClassificationCode—integer,l primaryl key ClassificationDescription—variable-lengthl string

Thel Vehiclel tablel shouldl havel thel followingl columns:

Name—variable-lengthl string,l maximuml 30l characters ClassificationCode—integer Writel al SQLl statementl tol createl thel Vehiclel table.l Designatel thel ClassificationCodel columnl inl thel Vehiclel tablel asl al foreignl keyl tol thel ClassificationCodel columnl inl thel Classificationl table.

Answer:

CREATEl TABLEl Vehiclel ( l Namel VARCHAR(30), l ClassificationCodel INT, l FOREIGNl KEYl (ClassificationCode)l REFERENCESl Classification(ClassificationCode) );

Q:l Thel Vehiclel tablel hasl thel followingl columns: ID—integer,l primaryl key Make—variable-lengthl string Model—variable-lengthl string Year—integer

Al newl columnl mustl bel addedl tol thel Vehiclel table:

Columnl name:l EngineSize

Datal type:l Al positivel decimall valuel lessl thanl orl equall tol 7.9l withl onel decimal.l Writel al SQLl statementl tol addl thel EngineSizel columnl tol thel Vehiclel table.

Answer:

ALTERl TABLEl Vehicle ADDl EngineSizel DECIMAL(2,1)l UNSIGNEDl CHECK(EngineSizel <=7.9);

Q:l Thel Songl tablel hasl thel followingl columns: ID—integer,l primaryl key Title—variable-lengthl string Genre—variable-lengthl string 2 / 4

Year—integer Writel al SQLl statementl tol createl al viewl namedl MyMusicl thatl containsl thel Title,l Genre,l andl Yearl columnsl forl alll songs.l Ensurel yourl resultl setl returnsl thel columnsl inl thel orderl indicated.

Answer:

CREATEl VIEWl MyMusicl AS SELECTl Title,l Genre,l Year FROMl Song;

Q:l Al databasel hasl al viewl namedl MyMusic.

Writel al SQLl statementl tol deletel thel viewl namedl MyMusicl froml thel database.

Answer:

DROPl VIEWl MyMusic;

Q:l Thel Petl tablel hasl thel followingl columns: PetIDl -l integer Namel -l variable-lengthl string Breedl -l variable-lengthl string Birthdatel -l date Writel al SQLl statementl tol modifyl thel Petl tablel tol makel thel PetIDl columnl thel primaryl key.

Answer:

ALTERl TABLEl Pet ADDl PRIMARYl KEYl (PetID);

Q:l Thel Dogl tablel hasl thel followingl columns: dogIDl -l integer,l primaryl key namel -l variable-lengthl string breedIDl -l integer birthdatel -l date

Thel Breedl tablel hasl thel followingl columns:

breedID—integer breedDescription—varchar Releases—integer Writel al SQLl statementl tol designatel thel breedIDl columnl inl thel Dogl tablel asl al foreignl keyl tol thel breedIDl columnl inl thel Breedl table. 3 / 4

Answer:

ALTERl TABLEl Dog ADDl FOREIGNl KEYl (breedID)l REFERENCESl Breedl (breedID);

Q:l Thel Songl tablel hasl thel followingl columns: ID—integer,l primaryl key Title—variable-lengthl string Genre—variable-lengthl string Year—integer Writel al SQLl statementl tol createl anl indexl namedl idx_yearl onl thel Yearl columnl ofl thel Songl table.

Answer:

CREATEl INDEXl idx_yearl ONl Songl (Year);

Q:l Thel Podcastl tablel hasl thel followingl columns: podcastID—integer,l primaryl key,l auto_increment Title—variable-lengthl string Genrel -l variable-lengthl string Speaker—variable-lengthl string Minutes—integer

Thel followingl datal needsl tol bel addedl tol thel Podcastl table:

Titlel Speakerl Genrel Minutes Rockl Paintingl Kecial McDonaldl Nol Datal 25 Writel al SQLl statementl tol insertl thel indicatedl datal intol thel Podcastl table.

Answer:

INSERTl INTOl Podcastl (Title,l Speaker,l Genre,l Minutes)l VALUESl ('Rockl Painting',l 'Kecial McDonald',l NULL,l 25);

Q:l Thel Podcastl tablel hasl thel followingl columns: PodcastID—integer,l primaryl key,l auto_increment Title—variable-lengthl string Speaker—variable-lengthl string Minutes—integer

• / 4