x
x
x
x
x
x
x
Data Management Foundation C175 WGU
x x x x
x
questions and answers latest top score.
x x x x x
x
x
x
x
x
x
x
x
x
x
x
x
Associative xEntity x- xcorrect xanswers.An xassociative xentity xis xan xelement xof xthe
xentity-
x
relationship xmodel. xAll xrelationships xfor xthe xassociative xentity xshould xbe
xmany.
x
Attribute x- xcorrect xanswers.An xattribute xis xa xproperty xor xcharacteristic xof xan xentity. x
x
Binary xrelationship x- xcorrect xanswers.A xbinary xrelationship xis xa xrelationship xbetween
xtwo x
x
entity
xtypes.
x
Candidate xKey x- xcorrect xanswers.Is xany xcolumn xor xa xcombination xof xcolumns xthat
xcan x
x
qualify xas xunique xkey xin
xdatabase.
x
Cardinality x- xcorrect xanswers.Cardinality xrepresents xthe xmaximum xnumber xof
xentities x
x
that xcan xbe xinvolved xin xa xparticular
xrelationship.
x
Cartesian xproduct x- xcorrect xanswers.Usually xthe xresult xof xa xmissing xjoin xcondition xor
xa xmethod xof xexpanding xthe xdata xof x1 xtable xby xthe xnumber xof xrows xin xthe xsecond
xtable. x
x
Cascade xDelete x- xcorrect xanswers.Will xdelete xall xrecords xthat xreference xthe xprimary
xkey x
x
column xsubquery x- xcorrect xanswers.Returns xa xsingle xcolumn xof xone xor xmore xvalues.
x
x
data xencryption x- xcorrect xanswers.When xdata xis xencrypted, xit xis xchanged, xbit xby
xbit xor x
x
character xby xcharacter, xinto xa xform xthat xlooks xtotally xgarbled. xIt xcan xand xmust
xbe
, x
reconverted, xor xdecrypted, xback xto xits xoriginal xform xto xbe xof
xuse.
Data xnormalization x- xcorrect xanswers.Is xa xmethodology xfor xorganizing xattributes
xinto x
x
tables xso xthat xredundancy xamong xthe xnon-key xattributes xis
xeliminated.
x
Data xvolatility x- xcorrect xanswers.Describes xhow xoften xstored xdata xis xupdated. x
x
Data xVolume xAssessment x- xcorrect xanswers.Understanding xof xhow xmuch xdata xwill
xbe xin x
x
a xdatabase xor xa xtable xwithin xa
xdatabase
x
Database x- xcorrect xanswers.A xdatabase xis xa xcollection xof xinformation xthat xis
xorganized x
x
so xthat xit xcan xeasily xbe xaccessed, xmanaged, xand
xupdated.
x
DCL x- xcorrect xanswers.Data xcontrol xlanguage xis xused xto xcontrol xaccess xto xdata
xstored xin x
x
a
xdatabase.
x
DDL x- xcorrect xanswers.Data xdefinition xlanguage x- xinvolves xinstructing xthe xDBMS
xsoftware xon xwhat xtables xwill xbe xin xthe xdatabase, xwhat xattributes xwill xbe xin xthe
xtables, xwhich xattributes xwill xbe xindexed, xand xso xforth. x
x
Definer x- xcorrect xanswers.Definer xis xa xMySQL xterm xwhere xAuthID xis xthe xsame
xfor x
x
another
xDBMS
x
Denormalization x- xcorrect xanswers.The xact xof xduplicating xdata xin xa xdatabase
xfor x
x
performance xor xthe xpreservation xof xhistorical
xinformation
x
disaster xrecovery x- xcorrect xanswers.Involves xrebuilding xan xentire xinformation xsystem
xor x
x
significant xparts xof xone xafter xa xcatastrophic xnatural xdisaster xsuch xas xa
xhurricane,
x
tornado, xearthquake, xbuilding xcollapse, xor xeven xa xmajor
xfire.
x
DML x- xcorrect xanswers.Data xmanipulation xlanguage xrefers xto xthe xfour xbasic
xoperations x
x
x
x
x
x
x
Data Management Foundation C175 WGU
x x x x
x
questions and answers latest top score.
x x x x x
x
x
x
x
x
x
x
x
x
x
x
x
Associative xEntity x- xcorrect xanswers.An xassociative xentity xis xan xelement xof xthe
xentity-
x
relationship xmodel. xAll xrelationships xfor xthe xassociative xentity xshould xbe
xmany.
x
Attribute x- xcorrect xanswers.An xattribute xis xa xproperty xor xcharacteristic xof xan xentity. x
x
Binary xrelationship x- xcorrect xanswers.A xbinary xrelationship xis xa xrelationship xbetween
xtwo x
x
entity
xtypes.
x
Candidate xKey x- xcorrect xanswers.Is xany xcolumn xor xa xcombination xof xcolumns xthat
xcan x
x
qualify xas xunique xkey xin
xdatabase.
x
Cardinality x- xcorrect xanswers.Cardinality xrepresents xthe xmaximum xnumber xof
xentities x
x
that xcan xbe xinvolved xin xa xparticular
xrelationship.
x
Cartesian xproduct x- xcorrect xanswers.Usually xthe xresult xof xa xmissing xjoin xcondition xor
xa xmethod xof xexpanding xthe xdata xof x1 xtable xby xthe xnumber xof xrows xin xthe xsecond
xtable. x
x
Cascade xDelete x- xcorrect xanswers.Will xdelete xall xrecords xthat xreference xthe xprimary
xkey x
x
column xsubquery x- xcorrect xanswers.Returns xa xsingle xcolumn xof xone xor xmore xvalues.
x
x
data xencryption x- xcorrect xanswers.When xdata xis xencrypted, xit xis xchanged, xbit xby
xbit xor x
x
character xby xcharacter, xinto xa xform xthat xlooks xtotally xgarbled. xIt xcan xand xmust
xbe
, x
reconverted, xor xdecrypted, xback xto xits xoriginal xform xto xbe xof
xuse.
Data xnormalization x- xcorrect xanswers.Is xa xmethodology xfor xorganizing xattributes
xinto x
x
tables xso xthat xredundancy xamong xthe xnon-key xattributes xis
xeliminated.
x
Data xvolatility x- xcorrect xanswers.Describes xhow xoften xstored xdata xis xupdated. x
x
Data xVolume xAssessment x- xcorrect xanswers.Understanding xof xhow xmuch xdata xwill
xbe xin x
x
a xdatabase xor xa xtable xwithin xa
xdatabase
x
Database x- xcorrect xanswers.A xdatabase xis xa xcollection xof xinformation xthat xis
xorganized x
x
so xthat xit xcan xeasily xbe xaccessed, xmanaged, xand
xupdated.
x
DCL x- xcorrect xanswers.Data xcontrol xlanguage xis xused xto xcontrol xaccess xto xdata
xstored xin x
x
a
xdatabase.
x
DDL x- xcorrect xanswers.Data xdefinition xlanguage x- xinvolves xinstructing xthe xDBMS
xsoftware xon xwhat xtables xwill xbe xin xthe xdatabase, xwhat xattributes xwill xbe xin xthe
xtables, xwhich xattributes xwill xbe xindexed, xand xso xforth. x
x
Definer x- xcorrect xanswers.Definer xis xa xMySQL xterm xwhere xAuthID xis xthe xsame
xfor x
x
another
xDBMS
x
Denormalization x- xcorrect xanswers.The xact xof xduplicating xdata xin xa xdatabase
xfor x
x
performance xor xthe xpreservation xof xhistorical
xinformation
x
disaster xrecovery x- xcorrect xanswers.Involves xrebuilding xan xentire xinformation xsystem
xor x
x
significant xparts xof xone xafter xa xcatastrophic xnatural xdisaster xsuch xas xa
xhurricane,
x
tornado, xearthquake, xbuilding xcollapse, xor xeven xa xmajor
xfire.
x
DML x- xcorrect xanswers.Data xmanipulation xlanguage xrefers xto xthe xfour xbasic
xoperations x
