WGU C170 Data Management Applications (over 400 Quest
z z z z z z z
ions And Answers) Recent Update 2023 Download to Pass.
z z z z z z z z
Azsalespersonziszauthorizedztozsellzmanyzproductszandzazproductzcanzbezsoldzbyzmanyzsalespersons.
z
Whichzkindzofzbinaryzrelationshipzdoeszthiszscenariozdescribe?
AzOne-to-one
BzOne-to-many
CzOne-to-onezbinary
DzMany-to-manyz-zcorrectzanswerzD
Whichzkindzofzrelationshipziszdisplayedzinzthiszentity-relationshipzdiagram?
AzMany-to-manyzunary
BzMany-to-manyzbinary
CzOne-to-onezunary
DzOne-to-onezbinaryz-zcorrectzanswerzA
Whichzkindzofzrelationshipziszdisplayedzinzthiszentity-relationshipzdiagram?
AzBinaryzmany-to-many
BzUnaryzone-to-one
CzTernaryzmany-to-many
DzTernaryzone-to-one
DzUnaryzmany-to-many
EzBinaryzone-to-onez-zcorrectzanswerzB
Howziszthiszportionzofzthezentity-relationshipzdiagramzread,zfromzleftztozright?
AzAtzleastzonezbookzwaszwrittenzbyzanzauthor.
P a g e z1z|z98
,BzOnlyzonezbookzwaszwrittenzbyzonezauthor.
CzNozbookszarezwrittenzbyzanzauthor.
DzOnezbookzwaszwrittenzbyzmorezthanzonezauthor.z-zcorrectzanswerzA
Whichztwozexampleszarezattributes?
Choosez2zanswers
1zAzmeetingzcode
2zAzpersonzattendingzazmeeting
3zAnzemployeeznumber
4zAzsaleszmeeting
Az1,3
Bz2,4z-zcorrectzanswerzA
Whichzdeletezrulezsetszcolumnzvalueszinzazchildztableztozazmissingzvaluezwhenzthezmatchingzdatazisz
deletedzfromzthezparentztable?
AzRestrict
BzCascade
CzMatching
DzSet-to-Nullz-zcorrectzanswerzD
Inzthiszentity-
relationshipzdiagram,zSalespersonz361ziszrelatedztoztwozcustomers.zTheztablezfollowszthezrestrictzd
eletezrule.
WhatzhappenszifzsomeoneztriesztozdeletezSalespersonz361zfromzthezcustomerzrecords?
AzThezdeletezoccurszimmediately.
BzThezlackzofzazsalespersonziszflaggedzforzlater.
P a g e z2z|z98
,CzAznewzsalespersonziszassignedzinstead.
DzThezdeleteziszprohibited.z-zcorrectzanswerzD
ReferztozthezgivenzSQLzstatement.
CREATEzTABLEzmember(member_idINTzUNSIGNEDzNOTzNULLzAUTO_INCREMENT,PRIMARYzKEYz(
member_id),last_nameVARCHAR(20)zNOTzNULL,first_nameVARCHAR(20)zNOTzNULL,suffixVARCH
AR(5)zNULL,expirationDATEzNULL,emailVARCHAR(100)zNULL,streetVARCHAR(50)zNULL,cityVARCH
AR(50)zNULL,stateVARCHAR(2)zNULL,zipVARCHAR(10)zNULL,phoneVARCHAR(20)zNULL,interestsV
ARCHAR(255)zNULL);
Whichztwozcolumnszarezcreatedzaszsomethingzotherzthanzvariable-lengthzstringszinzthiszstatement?
Choosez2zanswers
1zmember_id
2zexpiration
3zsuffix
4zemail
5zlastzname
6zcity
Az1,2
Bz3,4z-zcorrectzanswerzA
Thiszdatabaseztablezhasztenzdifferentzemployeeznumberszinzthezfirstzcolumn.zEmployee_IDziszthezpr
imaryzkey.zInzaddition,zitzhasztenzdifferentznameszinzthezsecondzcolumnzandztwozofficezaddresseszre
peatedzfiveztimeszeachzinzthezthirdzcolumn.
Whichzactionzshouldzbezusedztoztranslatezthiszdatazintozthirdznormalzform?
AzMovezthezdatazfromzthezthirdzcolumnzintozthezfirstzcolumn.
BzMovezthezdatazfromzthezthirdzcolumnzintozitszownztable.
P a g e z3z|z98
, CzMovezthezdatazfromzthezfirstztwozcolumnszintozseparateztables.
DzMovezthezdatazfromzthezsecondzcolumnzintozthezthirdzcolumn.z-zcorrectzanswerzB
Azdatabasezmanagerzstartsztozconvertzdatazthatzhaszbeenznormalizedzintozazformzthatzconformsztozt
hezrelationalzmodel.zAzsimplezprimaryzkeyzhaszbeenzestablishedzandzallzthezrepeatingzgroupszhavez
beenzdeleted.
Inzwhichzformziszthiszdata?
AzFirstznormalzform
BzSecondznormalzform
CzThirdznormalzform
DzFourthznormalzformz-zcorrectzanswerzB
Twozattributeszinztwozrelatedztableszhavezthezexactzsamezdomainzofzvalues.zThezattributeziszazprima
ryzkeyzinzoneztable.
Whichzkindzofzkeyziszthezattributezinzthezotherztable?
AzCompound
BzComposite
CzPrimary
DzForeignz-zcorrectzanswerzD
Inzthiszentity-relationshipzdiagram,zmanyzsalespersonszarezshownzaszworkingzinzatzleastzonezoffice.
Howziszthezrelationshipzbetweenzsalespersonszandzofficeszrepresentedzinzthezdiagram?
AzItziszlinkedzthroughzthezsalespersonzID.
BzItziszindicatedzbyztheztables'zadjacency.
CzItziszundefined.
DzItziszlinkedzthroughzthezofficezID.z-zcorrectzanswerzD?
P a g e z4z|z98
z z z z z z z
ions And Answers) Recent Update 2023 Download to Pass.
z z z z z z z z
Azsalespersonziszauthorizedztozsellzmanyzproductszandzazproductzcanzbezsoldzbyzmanyzsalespersons.
z
Whichzkindzofzbinaryzrelationshipzdoeszthiszscenariozdescribe?
AzOne-to-one
BzOne-to-many
CzOne-to-onezbinary
DzMany-to-manyz-zcorrectzanswerzD
Whichzkindzofzrelationshipziszdisplayedzinzthiszentity-relationshipzdiagram?
AzMany-to-manyzunary
BzMany-to-manyzbinary
CzOne-to-onezunary
DzOne-to-onezbinaryz-zcorrectzanswerzA
Whichzkindzofzrelationshipziszdisplayedzinzthiszentity-relationshipzdiagram?
AzBinaryzmany-to-many
BzUnaryzone-to-one
CzTernaryzmany-to-many
DzTernaryzone-to-one
DzUnaryzmany-to-many
EzBinaryzone-to-onez-zcorrectzanswerzB
Howziszthiszportionzofzthezentity-relationshipzdiagramzread,zfromzleftztozright?
AzAtzleastzonezbookzwaszwrittenzbyzanzauthor.
P a g e z1z|z98
,BzOnlyzonezbookzwaszwrittenzbyzonezauthor.
CzNozbookszarezwrittenzbyzanzauthor.
DzOnezbookzwaszwrittenzbyzmorezthanzonezauthor.z-zcorrectzanswerzA
Whichztwozexampleszarezattributes?
Choosez2zanswers
1zAzmeetingzcode
2zAzpersonzattendingzazmeeting
3zAnzemployeeznumber
4zAzsaleszmeeting
Az1,3
Bz2,4z-zcorrectzanswerzA
Whichzdeletezrulezsetszcolumnzvalueszinzazchildztableztozazmissingzvaluezwhenzthezmatchingzdatazisz
deletedzfromzthezparentztable?
AzRestrict
BzCascade
CzMatching
DzSet-to-Nullz-zcorrectzanswerzD
Inzthiszentity-
relationshipzdiagram,zSalespersonz361ziszrelatedztoztwozcustomers.zTheztablezfollowszthezrestrictzd
eletezrule.
WhatzhappenszifzsomeoneztriesztozdeletezSalespersonz361zfromzthezcustomerzrecords?
AzThezdeletezoccurszimmediately.
BzThezlackzofzazsalespersonziszflaggedzforzlater.
P a g e z2z|z98
,CzAznewzsalespersonziszassignedzinstead.
DzThezdeleteziszprohibited.z-zcorrectzanswerzD
ReferztozthezgivenzSQLzstatement.
CREATEzTABLEzmember(member_idINTzUNSIGNEDzNOTzNULLzAUTO_INCREMENT,PRIMARYzKEYz(
member_id),last_nameVARCHAR(20)zNOTzNULL,first_nameVARCHAR(20)zNOTzNULL,suffixVARCH
AR(5)zNULL,expirationDATEzNULL,emailVARCHAR(100)zNULL,streetVARCHAR(50)zNULL,cityVARCH
AR(50)zNULL,stateVARCHAR(2)zNULL,zipVARCHAR(10)zNULL,phoneVARCHAR(20)zNULL,interestsV
ARCHAR(255)zNULL);
Whichztwozcolumnszarezcreatedzaszsomethingzotherzthanzvariable-lengthzstringszinzthiszstatement?
Choosez2zanswers
1zmember_id
2zexpiration
3zsuffix
4zemail
5zlastzname
6zcity
Az1,2
Bz3,4z-zcorrectzanswerzA
Thiszdatabaseztablezhasztenzdifferentzemployeeznumberszinzthezfirstzcolumn.zEmployee_IDziszthezpr
imaryzkey.zInzaddition,zitzhasztenzdifferentznameszinzthezsecondzcolumnzandztwozofficezaddresseszre
peatedzfiveztimeszeachzinzthezthirdzcolumn.
Whichzactionzshouldzbezusedztoztranslatezthiszdatazintozthirdznormalzform?
AzMovezthezdatazfromzthezthirdzcolumnzintozthezfirstzcolumn.
BzMovezthezdatazfromzthezthirdzcolumnzintozitszownztable.
P a g e z3z|z98
, CzMovezthezdatazfromzthezfirstztwozcolumnszintozseparateztables.
DzMovezthezdatazfromzthezsecondzcolumnzintozthezthirdzcolumn.z-zcorrectzanswerzB
Azdatabasezmanagerzstartsztozconvertzdatazthatzhaszbeenznormalizedzintozazformzthatzconformsztozt
hezrelationalzmodel.zAzsimplezprimaryzkeyzhaszbeenzestablishedzandzallzthezrepeatingzgroupszhavez
beenzdeleted.
Inzwhichzformziszthiszdata?
AzFirstznormalzform
BzSecondznormalzform
CzThirdznormalzform
DzFourthznormalzformz-zcorrectzanswerzB
Twozattributeszinztwozrelatedztableszhavezthezexactzsamezdomainzofzvalues.zThezattributeziszazprima
ryzkeyzinzoneztable.
Whichzkindzofzkeyziszthezattributezinzthezotherztable?
AzCompound
BzComposite
CzPrimary
DzForeignz-zcorrectzanswerzD
Inzthiszentity-relationshipzdiagram,zmanyzsalespersonszarezshownzaszworkingzinzatzleastzonezoffice.
Howziszthezrelationshipzbetweenzsalespersonszandzofficeszrepresentedzinzthezdiagram?
AzItziszlinkedzthroughzthezsalespersonzID.
BzItziszindicatedzbyztheztables'zadjacency.
CzItziszundefined.
DzItziszlinkedzthroughzthezofficezID.z-zcorrectzanswerzD?
P a g e z4z|z98
