WGU - D426: OBJECTIVE ASSESSMENT
DatabasejoApplicationjo-joans--
✔✔Softwarejothatjohelpsjobusinessjousersjointeractjowithjodatabasejosystems.
DatabasejoAdministratorjo-joans--
✔✔Responsiblejoforjosecuringjothejodatabasejosystemjoagainstjounauthorizedjousers.joAjod
atabasejoadministratorjoenforcesjoproceduresjoforjouserjoaccessjoandjodatabasejosystemjo
availability.
Authorizationjo-joans--
✔✔Manyjodatabasejousersjoshouldjohavejolimitedjoaccessjotojospecificjotables,jocolumns,jo
orjorowsjoofjoajodatabase.joDatabasejosystemsjoauthorizejoindividualjousersjotojoaccessjosp
ecificjodata.
Rulesjo-joans--
✔✔Databasejosystemsjoensurejodatajoisjoconsistentjowithjostructuraljoandjobusinessjorules
.
QueryjoProcessorjo-joans--
✔✔Interpretsjoqueries,jocreatesjoajoplanjotojomodifyjothejodatabasejoorjoretrievejodata,joandj
oreturnsjoqueryjoresultsjotojothejoapplication.joPerformsjoqueryjooptimizationjotojoensurejoth
ejomostjoefficientjoinstructionsjoarejoexecutedjoonjothejodata.
StoragejoManagerjo-joans--✔✔Translatesjothejoqueryjoprocessorjoinstructionsjointojolow-
leveljofile-
systemjocommandsjothatjomodifyjoorjoretrievejodata.joDatabasejosizesjorangejofromjomega
bytesjotojomanyjoterabytes,josojothejostoragejomanagerjousesjoindexesjotojoquicklyjolocatejo
data.
TransactionjoManagerjo-joans--
✔✔Ensuresjotransactionsjoarejoproperlyjoexecuted.joThejotransactionjomanagerjopreventsj
oconflictsjobetweenjoconcurrentjotransactions.joThejotransactionjomanagerjoalsojorestoresjo
thejodatabasejotojoajoconsistentjostatejoinjothejoeventjoofjoajotransactionjoorjosystemjofailure.
Metadatajo-joans--
✔✔Datajoaboutjothejodatabase,josuchjoasjocolumnjonamesjoandjothejonumberjoofjorowsjoinjo
eachjotable.
, RelationaljoDatabasejo-joans--
✔✔Storesjodatajoinjotables,jocolumns,joandjorows,josimilarjotojoajospreadsheet.
RelationaljoDatabasejo-joans--
✔✔Alljo_________jo________josystemsjosupportjothejoSQLjoqueryjolanguage.
RelationaljoDatabasejo-joans--
✔✔Relationaljosystemsjoarejoidealjoforjodatabasesjothatjorequirejoanjoaccuratejorecordjoofjo
everyjotransaction,josuchjoasjobanking,joairlinejoreservationjosystems,joandjostudentjorecor
ds.
MongoDBjo(NoSQL)jo-joans--✔✔Thejonewerjonon-
relationaljosystemsjoarejocalledjoNoSQL,joforjo'notjoonlyjoSQL',joandjoarejooptimizedjoforjobi
gjodata.
SQLjoStatementsjo-joans--✔✔INSERTjoinsertsjorowsjointojoajotable.
SELECTjoretrievesjodatajofromjoajotable.
UPDATEjomodifiesjodatajoinjoajotable.
DELETEjodeletesjorowsjofromjoajotable.
CREATEjoTABLEjo(Statement)jo-joans--
✔✔Ajostatementjothatjocreatesjoajonewjotablejobyjospecifyingjothejotablejoandjocolumnjonam
es.joEachjocolumnjoisjoassignedjoajodatajotypejothatjoindicatesjothejoformatjoofjocolumnjovalu
es.joDatajotypesjocanjobejonumeric,jotextual,joorjocomplex.
DatajoTypejo-joans--✔✔INTjostoresjointegerjovalues.
DECIMALjostoresjofractionaljonumericjovalues.
VARCHARjostoresjotextualjovalues.
DATEjostoresjoyear,jomonth,joandjoday.
DatabasejoDesignjo-joans--✔✔Analysis
Logicaljodesign
Physicaljodesign
AnalysisjoPhase,joConceptualjoDesign,joEntity-
RelationshipjoModelingjo(DatabasejoDesign)jo-joans--
✔✔Thisjophasejospecifiesjodatabasejorequirementsjowithoutjoregardjotojoajospecificjodatab
asejosystem.joRequirementsjoarejorepresentedjoasjoentities,jorelationships,joandjoattributes
.joAnjoentityjoisjoajoperson,joplace,joactivity,joorjothing.joAjorelationshipjoisjoajolinkjobetweenjo
entities,joandjoanjoattributejoisjoajodescriptivejopropertyjoofjoanjoentity.
LogicaljoDesignjo(DatabasejoDesign)jo-joans--
✔✔Thisjophasejoimplementsjodatabasejorequirementsjoinjoajospecificjodatabasejosystem.jo
Forjorelationaljodatabasejosystems,jo_________jodesignjoconvertsjoentities,jorelationships,
joandjoattributesjointojotables,jokeys,joandjocolumns.
DatabasejoApplicationjo-joans--
✔✔Softwarejothatjohelpsjobusinessjousersjointeractjowithjodatabasejosystems.
DatabasejoAdministratorjo-joans--
✔✔Responsiblejoforjosecuringjothejodatabasejosystemjoagainstjounauthorizedjousers.joAjod
atabasejoadministratorjoenforcesjoproceduresjoforjouserjoaccessjoandjodatabasejosystemjo
availability.
Authorizationjo-joans--
✔✔Manyjodatabasejousersjoshouldjohavejolimitedjoaccessjotojospecificjotables,jocolumns,jo
orjorowsjoofjoajodatabase.joDatabasejosystemsjoauthorizejoindividualjousersjotojoaccessjosp
ecificjodata.
Rulesjo-joans--
✔✔Databasejosystemsjoensurejodatajoisjoconsistentjowithjostructuraljoandjobusinessjorules
.
QueryjoProcessorjo-joans--
✔✔Interpretsjoqueries,jocreatesjoajoplanjotojomodifyjothejodatabasejoorjoretrievejodata,joandj
oreturnsjoqueryjoresultsjotojothejoapplication.joPerformsjoqueryjooptimizationjotojoensurejoth
ejomostjoefficientjoinstructionsjoarejoexecutedjoonjothejodata.
StoragejoManagerjo-joans--✔✔Translatesjothejoqueryjoprocessorjoinstructionsjointojolow-
leveljofile-
systemjocommandsjothatjomodifyjoorjoretrievejodata.joDatabasejosizesjorangejofromjomega
bytesjotojomanyjoterabytes,josojothejostoragejomanagerjousesjoindexesjotojoquicklyjolocatejo
data.
TransactionjoManagerjo-joans--
✔✔Ensuresjotransactionsjoarejoproperlyjoexecuted.joThejotransactionjomanagerjopreventsj
oconflictsjobetweenjoconcurrentjotransactions.joThejotransactionjomanagerjoalsojorestoresjo
thejodatabasejotojoajoconsistentjostatejoinjothejoeventjoofjoajotransactionjoorjosystemjofailure.
Metadatajo-joans--
✔✔Datajoaboutjothejodatabase,josuchjoasjocolumnjonamesjoandjothejonumberjoofjorowsjoinjo
eachjotable.
, RelationaljoDatabasejo-joans--
✔✔Storesjodatajoinjotables,jocolumns,joandjorows,josimilarjotojoajospreadsheet.
RelationaljoDatabasejo-joans--
✔✔Alljo_________jo________josystemsjosupportjothejoSQLjoqueryjolanguage.
RelationaljoDatabasejo-joans--
✔✔Relationaljosystemsjoarejoidealjoforjodatabasesjothatjorequirejoanjoaccuratejorecordjoofjo
everyjotransaction,josuchjoasjobanking,joairlinejoreservationjosystems,joandjostudentjorecor
ds.
MongoDBjo(NoSQL)jo-joans--✔✔Thejonewerjonon-
relationaljosystemsjoarejocalledjoNoSQL,joforjo'notjoonlyjoSQL',joandjoarejooptimizedjoforjobi
gjodata.
SQLjoStatementsjo-joans--✔✔INSERTjoinsertsjorowsjointojoajotable.
SELECTjoretrievesjodatajofromjoajotable.
UPDATEjomodifiesjodatajoinjoajotable.
DELETEjodeletesjorowsjofromjoajotable.
CREATEjoTABLEjo(Statement)jo-joans--
✔✔Ajostatementjothatjocreatesjoajonewjotablejobyjospecifyingjothejotablejoandjocolumnjonam
es.joEachjocolumnjoisjoassignedjoajodatajotypejothatjoindicatesjothejoformatjoofjocolumnjovalu
es.joDatajotypesjocanjobejonumeric,jotextual,joorjocomplex.
DatajoTypejo-joans--✔✔INTjostoresjointegerjovalues.
DECIMALjostoresjofractionaljonumericjovalues.
VARCHARjostoresjotextualjovalues.
DATEjostoresjoyear,jomonth,joandjoday.
DatabasejoDesignjo-joans--✔✔Analysis
Logicaljodesign
Physicaljodesign
AnalysisjoPhase,joConceptualjoDesign,joEntity-
RelationshipjoModelingjo(DatabasejoDesign)jo-joans--
✔✔Thisjophasejospecifiesjodatabasejorequirementsjowithoutjoregardjotojoajospecificjodatab
asejosystem.joRequirementsjoarejorepresentedjoasjoentities,jorelationships,joandjoattributes
.joAnjoentityjoisjoajoperson,joplace,joactivity,joorjothing.joAjorelationshipjoisjoajolinkjobetweenjo
entities,joandjoanjoattributejoisjoajodescriptivejopropertyjoofjoanjoentity.
LogicaljoDesignjo(DatabasejoDesign)jo-joans--
✔✔Thisjophasejoimplementsjodatabasejorequirementsjoinjoajospecificjodatabasejosystem.jo
Forjorelationaljodatabasejosystems,jo_________jodesignjoconvertsjoentities,jorelationships,
joandjoattributesjointojotables,jokeys,joandjocolumns.