WGU - Pre-Assessment- Data Management - Applications (FJO1) (PFJO)

WGU - Pre-Assessment: Data Management -
Applications (FJO1) (PFJO) Multiple Choice Questions
and Verified Answers 100% | A+ Graded

A ysalesperson yis yauthorized yto ysell ymany yproducts yand ya yproduct ycan ybe ysold yby ymany
ysalespersons.




Which ykind yof ybinary yrelationship ydoes ythis yscenario ydescribe? y- yCORRECT yANSWER y-
Many-to- ymany



Which ytwo yexamples yare? yA

yperson yattending ya ymeeting

An yemployee ynumber

yA ysales ymeeting

A ymeeting ycode y- yCORRECT yANSWER y-An yemployee

ynumber yA ymeeting ycode




Which ydelete yrule ysets ycolumn yvalues yin ya ychild ytable yto ya ymissing yvalue ywhen ythe
ymatching ydata yis ydeleted yfrom ythe yparent ytable? y- yCORRECT yANSWER y-Set-to-Null




In ythis yentity-relationship ydiagram, ySalesperson y361 yis yrelated yto ytwo ycustomers. yThe
ytable yfollows ythe yrestrict ydelete yrule.




What yhappens yif ysomeone ytries yto ydelete ySalesperson y361 yfrom ythe ycustomer yrecords? y-
yCORRECT yANSWER y-The ydelete yis yprohibited.

,Refer yto ythe ygiven ySQL ystatement.

, CREATE yTABLE

ymember y(

member_id yINT yUNSIGNED yNOT yNULL yAUTO_INCREMENT,

PRIMARY yKEY y(member_id),

last_name yVARCHAR(20) yNOT

yNULL, yfirst_name yVARCHAR(20)

yNOT yNULL, ysuffix yVARCHAR(5)

yNULL,

expiration yDATE yNULL,

yemail yVARCHAR(100)

yNULL, ystreet

yVARCHAR(50) yNULL, ycity

yVARCHAR(50) yNULL,

ystate yVARCHAR(2) yNULL,

yzip yVARCHAR(10) yNULL,

yphone yVARCHAR(20)

yNULL,

interests yVARCHAR(255) yNULL

);



Which ytwo ycolumns yare ycreated yas ysomething yother ythan yvariable-length ystrings yin ythis
ystatement? y- yCORRECT yANSWER y-member_id

expiration



Employee_ID yEmployee_Name

yOffice_Address y12342 yJacob y54123 yMain

yStreet

12346 yMichael y354 yCenter yAvenue