WGU C170 Data Management -
Applications Exam Questions With
Correct Answers
domain c- ccorrect canswers✔✔In cdata cmodeling, cthe cconstruct cused cto corganize cand
cdescribe can cattribute's cset cof cpossible cvalues
superkey c- ccorrect canswers✔✔An cattribute cor cattributes cthat cuniquely cidentify ceach
centity cin ca ctable. cAny ccomposite ckey cwith cthis cis calso cthis.
candidate ckey c- ccorrect canswers✔✔A cminimal csuperkey; cthat cis, ca ckey cthat cdoes
cnot ccontain ca csubset cof cattributes cthat cis citself ca csuperkey
entity cintegrity c- ccorrect canswers✔✔The cproperty cof ca crelational ctable cthat
cguarantees ceach centity chas ca cunique cvalue cin ca cprimary ckey cand cthat cthe ckey
chas cno cnull cvalues
referential cintegrity c- ccorrect canswers✔✔A ccondition cby cwhich ca cdependent ctable's
cforeign ckey cmust chave ceither ca cnull centry cor ca cmatching centry cin cthe crelated
ctable
data cdictionary c- ccorrect canswers✔✔A cDBMS ccomponent cthat cstores cmetadata. cIt
ccontains cthe cdata cdefinition c& ctheir ccharacteristics cand crelationships; cmay calso
cinclude cdata cexternal cto cthe cDBMS
system ccatalog c- ccorrect canswers✔✔A cdetailed csystem cdata cdictionary cthat
cdescribes call cobjects cin ca cdatabase
homonym c- ccorrect canswers✔✔The cuse cof cthe csame cname cto clabel cdifferent
cattributes, cmuch clike csimilar-sounding cwords cwith cdifferent cmeanings
synonym c- ccorrect canswers✔✔The cuse cof cdifferent cnames cto cidentify cthe csame
cobject, csuch cas can centity, can cattribute, cor ca crelationship. cThese cshould cgenerally
cbe cavoided.
not cnull cand cunique c- ccorrect canswers✔✔Any ccandidate ckey cmust chave cthese ctwo
cconstraints cenforced
cardinality c- ccorrect canswers✔✔Term cfor chow cmany cinstances cof cone cobject care
crelated cto cinstances cof canother cobject c(maximum)
, modality c- ccorrect canswers✔✔Term cfor cwhether can cinstance cof ca cspecific centity cis
coptional cor cmandatory cin ca crelationship c(minimum)
connectivity c- ccorrect canswers✔✔Term cfor cthe cclassification cof cthe crelationship
cbetween centities. cClassifications cinclude c1:1, c1:M, cand cM:N
CREATE cSCHEMA cAUTHORIZATION c- ccorrect canswers✔✔SQL ccommand cto
ccreate ca cdatabase cschema
DEFAULT c- ccorrect canswers✔✔SQL coption cto cdefine ca cdefault cvalue cfor ca ccolumn
c(when cno cvalue cis cgiven)
CHECK c- ccorrect canswers✔✔SQL ccommand cto cvalidate cdata cin can cattribute, cused
cduring ctable ccolumn ccreation
CREATE cTABLE cAS c- ccorrect canswers✔✔SQL ccommand cto ccreate ca cnew ctable
cbased con ca cquery cin cthe cuser's cdatabase cschema
HAVING c- ccorrect canswers✔✔SQL coption cthat crestricts ca cselection cof cgrouped
crows cbased con ca ccondition
EXISTS c- ccorrect canswers✔✔SQL coption cthat cchecks cwhether ca csubquery creturns
cany crows
DECIMAL c- ccorrect canswers✔✔SQL cdata ctype clike cthe cNUMBER cspecification, cbut
cthe cstorage clength cis ca cminimum cspecification
True c- ccorrect canswers✔✔True cor cfalse: cif can cINSERT cor cSELECT ccommand cis
cembedded cinside ca cprogram cfor clater cuse, cthe cattribute clist cshould calways cbe
cused, cas cthe ctable cmay cchange cover ctime
inner cjoin c- ccorrect canswers✔✔A cjoin coperation cin cwhich conly crows cthat cmeet ca
cgiven ccriterion care cselected. cThe cmost ccommon ctype cof cjoin
outer cjoin c- ccorrect canswers✔✔A cjoin coperation cthat cproduces ca ctable cin cwhich call
cunmatched cpairs care cretained; cunmatched cvalues cin cthe crelated ctable care cleft cnull
cross cjoin c- ccorrect canswers✔✔A cjoin coperation cthat creturns cthe cCartesian cproduct
cof ctwo csets cor ctables
natural cjoin c- ccorrect canswers✔✔Join ctype cthat creturns conly cthe crows cwith
cmatching cvalues cin cthe cmatching ccolumns; cthe cmatching ccolumns cmust chave cthe
csame cnames cand csimilar cdata ctypes
left, cright, cfull c- ccorrect canswers✔✔Name cthe cthree ctypes cof couter cjoins
Applications Exam Questions With
Correct Answers
domain c- ccorrect canswers✔✔In cdata cmodeling, cthe cconstruct cused cto corganize cand
cdescribe can cattribute's cset cof cpossible cvalues
superkey c- ccorrect canswers✔✔An cattribute cor cattributes cthat cuniquely cidentify ceach
centity cin ca ctable. cAny ccomposite ckey cwith cthis cis calso cthis.
candidate ckey c- ccorrect canswers✔✔A cminimal csuperkey; cthat cis, ca ckey cthat cdoes
cnot ccontain ca csubset cof cattributes cthat cis citself ca csuperkey
entity cintegrity c- ccorrect canswers✔✔The cproperty cof ca crelational ctable cthat
cguarantees ceach centity chas ca cunique cvalue cin ca cprimary ckey cand cthat cthe ckey
chas cno cnull cvalues
referential cintegrity c- ccorrect canswers✔✔A ccondition cby cwhich ca cdependent ctable's
cforeign ckey cmust chave ceither ca cnull centry cor ca cmatching centry cin cthe crelated
ctable
data cdictionary c- ccorrect canswers✔✔A cDBMS ccomponent cthat cstores cmetadata. cIt
ccontains cthe cdata cdefinition c& ctheir ccharacteristics cand crelationships; cmay calso
cinclude cdata cexternal cto cthe cDBMS
system ccatalog c- ccorrect canswers✔✔A cdetailed csystem cdata cdictionary cthat
cdescribes call cobjects cin ca cdatabase
homonym c- ccorrect canswers✔✔The cuse cof cthe csame cname cto clabel cdifferent
cattributes, cmuch clike csimilar-sounding cwords cwith cdifferent cmeanings
synonym c- ccorrect canswers✔✔The cuse cof cdifferent cnames cto cidentify cthe csame
cobject, csuch cas can centity, can cattribute, cor ca crelationship. cThese cshould cgenerally
cbe cavoided.
not cnull cand cunique c- ccorrect canswers✔✔Any ccandidate ckey cmust chave cthese ctwo
cconstraints cenforced
cardinality c- ccorrect canswers✔✔Term cfor chow cmany cinstances cof cone cobject care
crelated cto cinstances cof canother cobject c(maximum)
, modality c- ccorrect canswers✔✔Term cfor cwhether can cinstance cof ca cspecific centity cis
coptional cor cmandatory cin ca crelationship c(minimum)
connectivity c- ccorrect canswers✔✔Term cfor cthe cclassification cof cthe crelationship
cbetween centities. cClassifications cinclude c1:1, c1:M, cand cM:N
CREATE cSCHEMA cAUTHORIZATION c- ccorrect canswers✔✔SQL ccommand cto
ccreate ca cdatabase cschema
DEFAULT c- ccorrect canswers✔✔SQL coption cto cdefine ca cdefault cvalue cfor ca ccolumn
c(when cno cvalue cis cgiven)
CHECK c- ccorrect canswers✔✔SQL ccommand cto cvalidate cdata cin can cattribute, cused
cduring ctable ccolumn ccreation
CREATE cTABLE cAS c- ccorrect canswers✔✔SQL ccommand cto ccreate ca cnew ctable
cbased con ca cquery cin cthe cuser's cdatabase cschema
HAVING c- ccorrect canswers✔✔SQL coption cthat crestricts ca cselection cof cgrouped
crows cbased con ca ccondition
EXISTS c- ccorrect canswers✔✔SQL coption cthat cchecks cwhether ca csubquery creturns
cany crows
DECIMAL c- ccorrect canswers✔✔SQL cdata ctype clike cthe cNUMBER cspecification, cbut
cthe cstorage clength cis ca cminimum cspecification
True c- ccorrect canswers✔✔True cor cfalse: cif can cINSERT cor cSELECT ccommand cis
cembedded cinside ca cprogram cfor clater cuse, cthe cattribute clist cshould calways cbe
cused, cas cthe ctable cmay cchange cover ctime
inner cjoin c- ccorrect canswers✔✔A cjoin coperation cin cwhich conly crows cthat cmeet ca
cgiven ccriterion care cselected. cThe cmost ccommon ctype cof cjoin
outer cjoin c- ccorrect canswers✔✔A cjoin coperation cthat cproduces ca ctable cin cwhich call
cunmatched cpairs care cretained; cunmatched cvalues cin cthe crelated ctable care cleft cnull
cross cjoin c- ccorrect canswers✔✔A cjoin coperation cthat creturns cthe cCartesian cproduct
cof ctwo csets cor ctables
natural cjoin c- ccorrect canswers✔✔Join ctype cthat creturns conly cthe crows cwith
cmatching cvalues cin cthe cmatching ccolumns; cthe cmatching ccolumns cmust chave cthe
csame cnames cand csimilar cdata ctypes
left, cright, cfull c- ccorrect canswers✔✔Name cthe cthree ctypes cof couter cjoins
