WGU - D426: Objective Assessment Exam with
Multiple Choice Questions and Verified Answers
100% | A+ Graded
Database jApplication j- jCORRECT jANSWER j-Software jthat jhelps jbusiness jusers jinteract jwith
jdatabase jsystems.
Database jAdministrator j- jCORRECT jANSWER j-Responsible jfor jsecuring jthe jdatabase jsystem
against junauthorized jusers. jA jdatabase jadministrator jenforces jprocedures jfor juser jaccess jand
jdatabase jsystem javailability.
Authorization j- jCORRECT jANSWER j-Many jdatabase jusers jshould jhave jlimited jaccess jto
jspecific jtables, jcolumns, jor jrows jof ja jdatabase. jDatabase jsystems jauthorize jindividual jusers
jto jaccess jspecific jdata.
Rules j- jCORRECT jANSWER j-Database jsystems jensure jdata jis jconsistent jwith jstructural jand
jbusiness jrules.
Query jProcessor j- jCORRECT jANSWER j-Interprets jqueries, jcreates ja jplan jto jmodify jthe
jdatabase jor jretrieve jdata, jand jreturns jquery jresults jto jthe japplication. jPerforms jquery
joptimization jto jensure jthe jmost jefficient jinstructions jare jexecuted jon jthe jdata.
Storage jManager j- jCORRECT jANSWER j-Translates jthe jquery jprocessor jinstructions jinto jlow-
level jfile-system jcommands jthat jmodify jor jretrieve jdata. jDatabase jsizes jrange jfrom
jmegabytes jto jmany jterabytes, jso jthe jstorage jmanager juses jindexes jto jquickly jlocate jdata.
Transaction jManager j- jCORRECT jANSWER j-Ensures jtransactions jare jproperly jexecuted. jThe
jtransaction jmanager jprevents jconflicts jbetween jconcurrent jtransactions. jThe jtransaction
,manager jalso jrestores jthe jdatabase jto ja jconsistent jstate jin jthe jevent jof ja jtransaction jor
jsystem jfailure.
Metadata j- jCORRECT jANSWER j-Data jabout jthe jdatabase, jsuch jas jcolumn jnames jand jthe
jnumber jof jrows jin jeach jtable.
Relational jDatabase j- jCORRECT jANSWER j-Stores jdata jin jtables, jcolumns, jand jrows, jsimilar jto
ja jspreadsheet.
Relational jDatabase j- jCORRECT jANSWER j-All j systems jsupport jthe
jSQL jquery jlanguage.
Relational jDatabase j- jCORRECT jANSWER j-Relational jsystems jare jideal jfor jdatabases jthat
jrequire jan jaccurate jrecord jof jevery jtransaction, jsuch jas jbanking, jairline jreservation
jsystems, jand jstudent jrecords.
MongoDB j(NoSQL) j- jCORRECT jANSWER j-The jnewer jnon-relational jsystems jare jcalled jNoSQL,
jfor j'not jonly jSQL', jand jare joptimized jfor jbig jdata.
SQL jStatements j- jCORRECT jANSWER j-INSERT jinserts jrows jinto ja jtable.
jSELECT jretrieves jdata jfrom ja jtable.
UPDATE jmodifies jdata jin ja jtable.
jDELETE jdeletes jrows jfrom ja jtable.
CREATE jTABLE j(Statement) j- jCORRECT jANSWER j-A jstatement jthat jcreates ja jnew jtable jby
jspecifying jthe jtable jand jcolumn jnames. jEach jcolumn jis jassigned ja jdata jtype jthat jindicates
jthe jformat jof jcolumn jvalues. jData jtypes jcan jbe jnumeric, jtextual, jor jcomplex.
Data jType j- jCORRECT jANSWER j-INT jstores jinteger jvalues.
, DECIMAL jstores jfractional jnumeric jvalues.
jVARCHAR jstores jtextual jvalues.
DATE jstores jyear, jmonth, jand jday.
Database jDesign j- jCORRECT jANSWER j-Analysis
jLogical jdesign
Physical jdesign
Analysis jPhase, jConceptual jDesign, jEntity-Relationship jModeling j(Database jDesign) j- jCORRECT
jANSWER j-This jphase jspecifies jdatabase jrequirements jwithout jregard jto ja jspecific jdatabase
jsystem. jRequirements jare jrepresented jas jentities, jrelationships, jand jattributes. jAn jentity jis
ja jperson, jplace, jactivity, jor jthing. jA jrelationship jis ja jlink jbetween jentities, jand jan jattribute
jis ja jdescriptive jproperty jof jan jentity.
Logical jDesign j(Database jDesign) j- jCORRECT jANSWER j-This jphase jimplements jdatabase
requirements jin ja jspecific jdatabase jsystem. jFor jrelational jdatabase jsystems, j design
jconverts jentities, jrelationships, jand jattributes jinto jtables, jkeys, jand jcolumns.
Physical jDesign j- jCORRECT jANSWER j-Specifies jindexes, jtable jstructures, jand jpartitions.
jThis jphase jadds jindexes jand jspecifies jhow jtables jare jorganized jon jstorage jmedia.
jAffects jquery jprocessing jspeed jbut jnever jaffects jthe jquery jresult.
Data jIndependence j- jCORRECT jANSWER j-Allows jdatabase jdesigners jto jtune jquery
jperformance jwithout jchanges jto japplication jprograms.
Application jProgramming jInterface j(API) j- jCORRECT jANSWER j-To jsimplify jthe juse jof jSQL
jwith ja jgeneral-purpose jlanguage, jdatabase jprograms jtypically juse jan j
.
Multiple Choice Questions and Verified Answers
100% | A+ Graded
Database jApplication j- jCORRECT jANSWER j-Software jthat jhelps jbusiness jusers jinteract jwith
jdatabase jsystems.
Database jAdministrator j- jCORRECT jANSWER j-Responsible jfor jsecuring jthe jdatabase jsystem
against junauthorized jusers. jA jdatabase jadministrator jenforces jprocedures jfor juser jaccess jand
jdatabase jsystem javailability.
Authorization j- jCORRECT jANSWER j-Many jdatabase jusers jshould jhave jlimited jaccess jto
jspecific jtables, jcolumns, jor jrows jof ja jdatabase. jDatabase jsystems jauthorize jindividual jusers
jto jaccess jspecific jdata.
Rules j- jCORRECT jANSWER j-Database jsystems jensure jdata jis jconsistent jwith jstructural jand
jbusiness jrules.
Query jProcessor j- jCORRECT jANSWER j-Interprets jqueries, jcreates ja jplan jto jmodify jthe
jdatabase jor jretrieve jdata, jand jreturns jquery jresults jto jthe japplication. jPerforms jquery
joptimization jto jensure jthe jmost jefficient jinstructions jare jexecuted jon jthe jdata.
Storage jManager j- jCORRECT jANSWER j-Translates jthe jquery jprocessor jinstructions jinto jlow-
level jfile-system jcommands jthat jmodify jor jretrieve jdata. jDatabase jsizes jrange jfrom
jmegabytes jto jmany jterabytes, jso jthe jstorage jmanager juses jindexes jto jquickly jlocate jdata.
Transaction jManager j- jCORRECT jANSWER j-Ensures jtransactions jare jproperly jexecuted. jThe
jtransaction jmanager jprevents jconflicts jbetween jconcurrent jtransactions. jThe jtransaction
,manager jalso jrestores jthe jdatabase jto ja jconsistent jstate jin jthe jevent jof ja jtransaction jor
jsystem jfailure.
Metadata j- jCORRECT jANSWER j-Data jabout jthe jdatabase, jsuch jas jcolumn jnames jand jthe
jnumber jof jrows jin jeach jtable.
Relational jDatabase j- jCORRECT jANSWER j-Stores jdata jin jtables, jcolumns, jand jrows, jsimilar jto
ja jspreadsheet.
Relational jDatabase j- jCORRECT jANSWER j-All j systems jsupport jthe
jSQL jquery jlanguage.
Relational jDatabase j- jCORRECT jANSWER j-Relational jsystems jare jideal jfor jdatabases jthat
jrequire jan jaccurate jrecord jof jevery jtransaction, jsuch jas jbanking, jairline jreservation
jsystems, jand jstudent jrecords.
MongoDB j(NoSQL) j- jCORRECT jANSWER j-The jnewer jnon-relational jsystems jare jcalled jNoSQL,
jfor j'not jonly jSQL', jand jare joptimized jfor jbig jdata.
SQL jStatements j- jCORRECT jANSWER j-INSERT jinserts jrows jinto ja jtable.
jSELECT jretrieves jdata jfrom ja jtable.
UPDATE jmodifies jdata jin ja jtable.
jDELETE jdeletes jrows jfrom ja jtable.
CREATE jTABLE j(Statement) j- jCORRECT jANSWER j-A jstatement jthat jcreates ja jnew jtable jby
jspecifying jthe jtable jand jcolumn jnames. jEach jcolumn jis jassigned ja jdata jtype jthat jindicates
jthe jformat jof jcolumn jvalues. jData jtypes jcan jbe jnumeric, jtextual, jor jcomplex.
Data jType j- jCORRECT jANSWER j-INT jstores jinteger jvalues.
, DECIMAL jstores jfractional jnumeric jvalues.
jVARCHAR jstores jtextual jvalues.
DATE jstores jyear, jmonth, jand jday.
Database jDesign j- jCORRECT jANSWER j-Analysis
jLogical jdesign
Physical jdesign
Analysis jPhase, jConceptual jDesign, jEntity-Relationship jModeling j(Database jDesign) j- jCORRECT
jANSWER j-This jphase jspecifies jdatabase jrequirements jwithout jregard jto ja jspecific jdatabase
jsystem. jRequirements jare jrepresented jas jentities, jrelationships, jand jattributes. jAn jentity jis
ja jperson, jplace, jactivity, jor jthing. jA jrelationship jis ja jlink jbetween jentities, jand jan jattribute
jis ja jdescriptive jproperty jof jan jentity.
Logical jDesign j(Database jDesign) j- jCORRECT jANSWER j-This jphase jimplements jdatabase
requirements jin ja jspecific jdatabase jsystem. jFor jrelational jdatabase jsystems, j design
jconverts jentities, jrelationships, jand jattributes jinto jtables, jkeys, jand jcolumns.
Physical jDesign j- jCORRECT jANSWER j-Specifies jindexes, jtable jstructures, jand jpartitions.
jThis jphase jadds jindexes jand jspecifies jhow jtables jare jorganized jon jstorage jmedia.
jAffects jquery jprocessing jspeed jbut jnever jaffects jthe jquery jresult.
Data jIndependence j- jCORRECT jANSWER j-Allows jdatabase jdesigners jto jtune jquery
jperformance jwithout jchanges jto japplication jprograms.
Application jProgramming jInterface j(API) j- jCORRECT jANSWER j-To jsimplify jthe juse jof jSQL
jwith ja jgeneral-purpose jlanguage, jdatabase jprograms jtypically juse jan j
.
