WGU C175/D426 Data Management Exam Review
Multiple Choice Questions and Verified Answers
100% | A+ Graded
Modality O- OCORRECT OANSWER O-Refers Oto Othe OMINIMUM Onumber Oof Otimes Oan
Oinstance Oin Oone Oentity Ocan Obe Oassociated Owith Oinstance Oof Oanother Oentity O(minima).
OAppears Oas Oa O0 Oor O1 Oon Othe Orelationship Oline, Onext Oto Ocardinality.
Referential OIntegrity O- OCORRECT OANSWER O-Requires Othat OALL Oforeign Okey Ovalues Omust
Oeither Obe Ofully ONULL Oor Omatch Osome Oprimary Okey Ovalue.
Ways OReferential OIntegrity Ocan Obe Oviolated O- OCORRECT OANSWER O-1. OPrimary Okey Ois
Oupdated O2.
Foreign Okey Ois Oupdated O3. ORow Ocontaining Oprimary Okey Ois ODELETED O4. ORow
Ocontaining Oforeign Okey Ois OINSERTED.
Actions Oto OCorrect OReferential OIntegrity OViolation O- OCORRECT OANSWER O-1. ORESTRICT O-
Orejects Oan Oinsert, Oupdate, Oor Odelete O2. OSET ONULL O- Osets Oinvalid Oforeign Okeys Oto
Onull O3. OSET ODEFAULT O- Osets Oinvalid Oforeign Okeys Oto Oa Odefault Oprimary Ovalue O4.
OCASCADE O- Opropagates Oprimary Okey Ochanges Oto Oforeign Okeys.
Important Oaspect Oof OReferential OIntegrity O- OCORRECT OANSWER O-Reference Oto Odata Oin
Oone Orelation Ois Obased Oon Ovalues Oin Oanother Orelation.
Broad Odefinition Oof Odata O- OCORRECT OANSWER O-Raw Ofacts Ocaptured Oon Oprinted Oor Odigital
Omedia.
Data O- OCORRECT OANSWER O-Facts Othat Oare Ocollected Oand Ostored Oin Oa Odatabase Osystem.
,Determining Ocharacteristic Oof Ounstructured Odata O- OCORRECT OANSWER O-It Odoes Onot
Ofollow Oa Odata Omodel.
,Flat Ofiles O- OCORRECT OANSWER O-They Ocontain Ono Ointernal Ohierarchical Oorganization.
Data Oretrieval Obefore Odatabase Omanagement Osystems O- OCORRECT OANSWER O-Sequentially
Ofrom Osimple Ofiles.
Primary OKey O- OCORRECT OANSWER O-An Oattribute Oor Ogroup Oof Oattributes Othat Ouniquely
Oidentify Oa Otuple Oin Oa Orelation.
Foreign OKey Omatching O- OCORRECT OANSWER O-A Odomain Oof Ovalues Ois Onecessary Ofor Oa
Oprimary Okey Oin Oone Orelation Oof Oa Odatabase Oto Omatch Owith Oits Ocorresponding Oforeign
Okey Oin Oanother Orelation Oof Othe Osame Odatabase.
Alternate OKey O- OCORRECT OANSWER O-What Ouniquely Oidentifies Oeach Oentity Oin Oa
Ocollection Oof Oentities Obut Ois Onot Othe Oprimary Okey.
Candidate OKey O- OCORRECT OANSWER O-A Oset Oof Ocolumns Oin Oa Otable Othat Ocan Ouniquely
Oidentify Oany Orecord Oin Othat Otable Owithout Oreferring Oto Oother Odata.
Database Oindexing O- OCORRECT OANSWER O-The Ooriginal Odata Ois Ocopied Oto Othe Oindex.
Indexes Oin Ophysical Odatabase Odesign O- OCORRECT OANSWER O-To Oretrieve Odata ODIRECTLY
Ousing Oa Opointer.
Index Ocreation Oon Oa Odatabase Ocolumn O- OCORRECT OANSWER O-To Ooptimize Odata Oretrievals.
Functional ODependency O- OCORRECT OANSWER O-Each Ovalue Oof Oa Ocolumn Orelates Oto Oat
OMOST Oone Ovalue Oof Oanother Ocolumn.
, Rules/Appearance Oof OFirst ONormal OForm O- OCORRECT OANSWER O-- OAll Onon-key Ocolumns
Odepend Oon Oprimary Okey O- OEach Otable Ocell Ocontains Oone Ovalue O- OA Otable Owith Ono
Oduplicate Orows.
Rules/Appearance Oof OSecond ONormal OForm O- OCORRECT OANSWER O-- OWhen Oall Onon-
key Ocolumns Odepend Oon Othe OWHOLE Oprimary Okey O- OMust Obe Oin O1NF O- ONon-key
Ocolumn Ocan Onot Odepend Oon Ojust Oone Opart Oof Oa Ocomposite Okey O- Oa Osingle Oprimary
Okey Ois Oautomatically Oin O2NF.
Rules/Appearance Oof OThird ONormal OForm O- OCORRECT OANSWER O-- OAll Onon-key Ocolumns
Odepend OONLY Oon Othe Oprimary Okey O- OTables Oare Ototally Ofree Oof Odata Oredundancy.
Differences Obetween Ooperational Oand Oanalytical Odatabases O- OCORRECT OANSWER O--
OVolatility O- ODetail O- OScope O- OHistory.
Volatility O- OCORRECT OANSWER O-Database Oupdates Oin Oreal Otime. OOperational OData Ois
OVolatile. OAnalytical OData Ois ONOT OVolatile.
Detail Oin Odatabases O- OCORRECT OANSWER O-- OA Odatabase Othat Okeeps Orecord Oof
Oindividual Otransactions; Oline Oitems O- OOperational: ODetailed O- OAnalytical: ODetailed.
Scope Oin Odatabases O- OCORRECT OANSWER O-- OHow Ofar Oa Odatabase Ocan Oreach O-
OOperational: Oincompatible O- OAnalytical: OEnterprise-Wide/Summary.
History Oin Odatabases O- OCORRECT OANSWER O-- OWhether ODB Ois Ocurrent Oor Otracks Oall
Odata O- OOperational: OCurrent Oonly O- OAnalytical: OTracks Otrends.
Data Owarehouse Orefresh Oprocess O- OCORRECT OANSWER O-1. OExtraction O2. OCleanse O3.
OIntegrate O4. ORestructure O5. OLoad.
Multiple Choice Questions and Verified Answers
100% | A+ Graded
Modality O- OCORRECT OANSWER O-Refers Oto Othe OMINIMUM Onumber Oof Otimes Oan
Oinstance Oin Oone Oentity Ocan Obe Oassociated Owith Oinstance Oof Oanother Oentity O(minima).
OAppears Oas Oa O0 Oor O1 Oon Othe Orelationship Oline, Onext Oto Ocardinality.
Referential OIntegrity O- OCORRECT OANSWER O-Requires Othat OALL Oforeign Okey Ovalues Omust
Oeither Obe Ofully ONULL Oor Omatch Osome Oprimary Okey Ovalue.
Ways OReferential OIntegrity Ocan Obe Oviolated O- OCORRECT OANSWER O-1. OPrimary Okey Ois
Oupdated O2.
Foreign Okey Ois Oupdated O3. ORow Ocontaining Oprimary Okey Ois ODELETED O4. ORow
Ocontaining Oforeign Okey Ois OINSERTED.
Actions Oto OCorrect OReferential OIntegrity OViolation O- OCORRECT OANSWER O-1. ORESTRICT O-
Orejects Oan Oinsert, Oupdate, Oor Odelete O2. OSET ONULL O- Osets Oinvalid Oforeign Okeys Oto
Onull O3. OSET ODEFAULT O- Osets Oinvalid Oforeign Okeys Oto Oa Odefault Oprimary Ovalue O4.
OCASCADE O- Opropagates Oprimary Okey Ochanges Oto Oforeign Okeys.
Important Oaspect Oof OReferential OIntegrity O- OCORRECT OANSWER O-Reference Oto Odata Oin
Oone Orelation Ois Obased Oon Ovalues Oin Oanother Orelation.
Broad Odefinition Oof Odata O- OCORRECT OANSWER O-Raw Ofacts Ocaptured Oon Oprinted Oor Odigital
Omedia.
Data O- OCORRECT OANSWER O-Facts Othat Oare Ocollected Oand Ostored Oin Oa Odatabase Osystem.
,Determining Ocharacteristic Oof Ounstructured Odata O- OCORRECT OANSWER O-It Odoes Onot
Ofollow Oa Odata Omodel.
,Flat Ofiles O- OCORRECT OANSWER O-They Ocontain Ono Ointernal Ohierarchical Oorganization.
Data Oretrieval Obefore Odatabase Omanagement Osystems O- OCORRECT OANSWER O-Sequentially
Ofrom Osimple Ofiles.
Primary OKey O- OCORRECT OANSWER O-An Oattribute Oor Ogroup Oof Oattributes Othat Ouniquely
Oidentify Oa Otuple Oin Oa Orelation.
Foreign OKey Omatching O- OCORRECT OANSWER O-A Odomain Oof Ovalues Ois Onecessary Ofor Oa
Oprimary Okey Oin Oone Orelation Oof Oa Odatabase Oto Omatch Owith Oits Ocorresponding Oforeign
Okey Oin Oanother Orelation Oof Othe Osame Odatabase.
Alternate OKey O- OCORRECT OANSWER O-What Ouniquely Oidentifies Oeach Oentity Oin Oa
Ocollection Oof Oentities Obut Ois Onot Othe Oprimary Okey.
Candidate OKey O- OCORRECT OANSWER O-A Oset Oof Ocolumns Oin Oa Otable Othat Ocan Ouniquely
Oidentify Oany Orecord Oin Othat Otable Owithout Oreferring Oto Oother Odata.
Database Oindexing O- OCORRECT OANSWER O-The Ooriginal Odata Ois Ocopied Oto Othe Oindex.
Indexes Oin Ophysical Odatabase Odesign O- OCORRECT OANSWER O-To Oretrieve Odata ODIRECTLY
Ousing Oa Opointer.
Index Ocreation Oon Oa Odatabase Ocolumn O- OCORRECT OANSWER O-To Ooptimize Odata Oretrievals.
Functional ODependency O- OCORRECT OANSWER O-Each Ovalue Oof Oa Ocolumn Orelates Oto Oat
OMOST Oone Ovalue Oof Oanother Ocolumn.
, Rules/Appearance Oof OFirst ONormal OForm O- OCORRECT OANSWER O-- OAll Onon-key Ocolumns
Odepend Oon Oprimary Okey O- OEach Otable Ocell Ocontains Oone Ovalue O- OA Otable Owith Ono
Oduplicate Orows.
Rules/Appearance Oof OSecond ONormal OForm O- OCORRECT OANSWER O-- OWhen Oall Onon-
key Ocolumns Odepend Oon Othe OWHOLE Oprimary Okey O- OMust Obe Oin O1NF O- ONon-key
Ocolumn Ocan Onot Odepend Oon Ojust Oone Opart Oof Oa Ocomposite Okey O- Oa Osingle Oprimary
Okey Ois Oautomatically Oin O2NF.
Rules/Appearance Oof OThird ONormal OForm O- OCORRECT OANSWER O-- OAll Onon-key Ocolumns
Odepend OONLY Oon Othe Oprimary Okey O- OTables Oare Ototally Ofree Oof Odata Oredundancy.
Differences Obetween Ooperational Oand Oanalytical Odatabases O- OCORRECT OANSWER O--
OVolatility O- ODetail O- OScope O- OHistory.
Volatility O- OCORRECT OANSWER O-Database Oupdates Oin Oreal Otime. OOperational OData Ois
OVolatile. OAnalytical OData Ois ONOT OVolatile.
Detail Oin Odatabases O- OCORRECT OANSWER O-- OA Odatabase Othat Okeeps Orecord Oof
Oindividual Otransactions; Oline Oitems O- OOperational: ODetailed O- OAnalytical: ODetailed.
Scope Oin Odatabases O- OCORRECT OANSWER O-- OHow Ofar Oa Odatabase Ocan Oreach O-
OOperational: Oincompatible O- OAnalytical: OEnterprise-Wide/Summary.
History Oin Odatabases O- OCORRECT OANSWER O-- OWhether ODB Ois Ocurrent Oor Otracks Oall
Odata O- OOperational: OCurrent Oonly O- OAnalytical: OTracks Otrends.
Data Owarehouse Orefresh Oprocess O- OCORRECT OANSWER O-1. OExtraction O2. OCleanse O3.
OIntegrate O4. ORestructure O5. OLoad.
