WGUl D427l Pre-l Assessmentl (Latestl 2025/l 2026l Update)l Datal Managementl –l Applications|l Questionsl &l Answers|l Gradel A|l 100%l Correctl (Verifiedl Solutions)
Q:l Whichl ofl thel followingl isl al DMLl (Datal Manipulationl Language)l command?
-l CREATEl VIEW -l CREATEl TABLEl -l INSERT -l ALTERl INDEX
Answer:
INSERT
Q:l Patientl Table
PKl patientl id firstl name lastl name birthdatel
Examl Table PKl examl id examl date examl reasonl FKl patientl id
CREATEl TABLEl Examl ( exam_idl INTl NOTl NULLl AUTO_INCREMENT,l exam_datel DATEl NOTl NULL,l exam_reasonl VARCHAR(100),l patient_idl INTl NOTl NULL,l PRIMARYl KEYl (exam_id), FOREIGNl KEYl (patient_id)l REFERENCESl Patientl (patient_id)l ONl DELETEl CASCADE 1 / 3
);
Whatl wouldl happenl tol examsl inl thel Examl tablel thatl arel linkedl tol al patientl ifl thatl patientl isl deleted?
-l Thosel examsl wouldl remainl inl thel database -l Thosel examsl wouldl bel deletedl also -l Thel Patientl IDl forl thosel examsl wouldl bel changedl tol NULL -l Nothingl wouldl happen
Answer:
Thosel examsl wouldl bel deletedl also
Q:l Patientl Table
PKl patientl id firstl name lastl name birthdatel
Examl Table PKl examl id examl date examl reasonl FKl patientl id
CREATEl TABLEl Examl ( exam_idl INTl NOTl NULLl AUTO_INCREMENT,l exam_datel DATEl NOTl NULL,l exam_reasonl VARCHAR(100),l patient_idl INTl NOTl NULL,l PRIMARYl KEYl (exam_id), FOREIGNl KEYl (patient_id)l REFERENCESl Patientl (patient_id)l ONl DELETEl RESTRICT );
Whatl wouldl happenl tol examsl inl thel Examl tablel thatl arel linkedl tol al patientl ifl thatl patientl isl deleted.l
-l Thosel invoicesl wouldl remainl inl thel database -l Thosel invoicesl wouldl bel deletedl also -l Thel Customerl IDl forl thosel invoicesl wouldl bel changedl tol NULL -l Thel deletel ofl thel Customerl wouldl notl bel allowed
- / 3
Answer:
Thel deletel ofl thel Customerl wouldl notl bel allowed
Q:l Patientl Table
PKl patientl id firstl name lastl name birthdatel
Examl Table PKl examl id examl date examl reasonl FKl patientl idl
CREATEl TABLEl Examl ( exam_idl INTl NOTl NULLl AUTO_INCREMENT, exam_datel DATEl NOTl NULL, exam_reasonl VARCHARl (100),l patient_idl INTl NOTl NULL, PRIMARYl KEYl (exam_id), FOREIGNl KEYl (patient_id)l REFERENCESl Patientl (patientl _id)l ONl DELETEl SETl TOl NULLl );
whatl wouldl happenl tol examsl inl thel Examl tablel thatl arel linkedl tol al patientl ifl thatl patientl isl deleted.Thosel invoicesl wouldl remainl inl thel database.Thosel invoicesl wouldl bel deletedl also.Thel Customerl IDl forl thosel invoicesl wouldl bel changedl tol NULL.Thel deletel ofl thel Customerl wouldl notl bel allowed.
Answer:
Thel Customerl IDl forl thosel invoicesl wouldl bel changedl tol NULL
Q:l Whichl ofl thel followingl arel truel aboutl 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.
- / 3