DATABASE ADMINISTRATION
FUNDAMENTALS ACTUAL EXAM ALL
QUESTIONS AND WELL
ELABORATED ANSWERS TOP RATED
VERSION FOR ALREADY A+ GRADED
HIGHLY RECOMMENDED |NEW AND
REVISED
2mNFm-
mCORRECTmANSWERmJohnmworksmasmamDatabasemAdministratormformBluewellmInc.mThemcompanym
hasmamSQLmServermdatabase.
Amtableminmthemdatabasemhasmamcandidatemkeymandmanmattributemthatmismnotmamconstituentmofmthe
candidatemkey.mThemnon-
keymattributemdependsmuponmthemwholemofmthemcandidatemkeymrathermthanmjust
ampartmofmit.mWhichmofmthemfollowingmnormalmformsmismrepresentedminmthemscenario?
LogicalmDatabasemdesignm-
mCORRECTmANSWERmYoumworkmasmamDatabasemDesignermformDataOneWorldmInc.mThemcompanymh
asmamSQLmServermdatabase.
Youmaremassignedmthemtaskmofmcreatingmamdatammodelmofmanmenterprisembasedmonmamspecificmdata
mmodel.
ThemmodelmtombemcreatedmshouldmbemindependentmofmamparticularmDBMS.mWhichmofmthemfollowin
g
databasemdesignsmwillmhelpmyoumaccomplishmthemtask?
Gatheringminformationm-
mCORRECTmANSWERmWhichmofmthemfollowingmstepsminmdatabasemplanningmhelpsmtomdeterminemth
emrequirementsmofmthe
databasemthroughminterviewing?
,Linem2m-
mCORRECTmANSWERmConsidermthemcasemofmamfruitmjuicemcompany.mThemcompanymmanufacturesmf
ruitmjuicesmandmsupplies
themmtomwholesalers.mThemDatabasemDesignermcreatesmamtablemnamedmProduction.mThemcodemism
given
below:
1.mCREATEmTablemProduction
2.m2.(Fruit_typemVarChar,
3.mFruit_namemChar(20),
4.mQuantitymInt(3))
Whichmofmthemabove-mentionedmlinesmhasmanmerror?
Relationalmmodelm-
mCORRECTmANSWERmJohnmworksmasmamDatabasemAdministratormformDataOneWorldmInc.mThemcom
panymhasmamSQLmServer
database.mJohnmwantsmtominsertmrecordsminmamtablemwheremthemdatabasemismstructuredminmamfixed
mformat.
Whichmofmthemfollowingmdatammodelsmwillmhemusemtomaccomplishmthemtask?
Filteredm-
mCORRECTmANSWERmYoummanagemamdatabasemnamedmCustomers,mwhichmincludesmamtablemname
dmOrders.mThemOrdersmtable
ismfrequentlymqueried,mbutmonlymordersmwithmamsalesmtotalmofmmoremthanm$1000.00maremrequiredm
inmthe
query.mYoumwantmtomcreatemanmindexmtomspeedmupmthesemtypesmofmqueriesmatmthemsamemtime,men
suring
themindexmismasmsmallmasmpossible.mWhatmtypemofmindexmshouldmyoumuse?
,Lockm-
mCORRECTmANSWERmWhichmofmthemfollowingmdatabasemtermsmismdescribedminmthemstatementmbel
ow?m"Itmpreventsmthe
currentmdatabasemoperationmfrommreadingmormwritingmamdatamitemmwhilemthemdatamitemmismbeing
accessedmbymanothermoperation."
Encryptionm-
mCORRECTmANSWERmYourmCompanymismdesigningmandmdevelopingmamnumbermofmdatabasesmformam
stockmexchange.mOnemofmthe
databasesmwillmcontainmhighlymsensitivemdatamformwhichmhighmlevelmofmsecuritymwillmbemrequired.
Althoughmhighmprocessingmspeedmismonemofmthemprimemrequirementsmofmthemcustomer,mformthismd
atabase,
securitymofmthemdatamwillmtakemprioritymovermthemprocessingmspeed.mItmneedsmtombemensuredmthat
meven
ifmunauthorizedmaccessmtomthemdatabasemismobtained,mthemroguemusermismunablemtomreadmthemdat
a.mWhich
ofmthemfollowingmprotectionmtechniquesmwillmyoumsuggestmformthismdatabase?
Top-downmapproach
Bottom-upmapproach
Inside-outmapproachm-
mCORRECTmANSWERmWhichmofmthemfollowingmaremthemmainmapproachesminmthemdatabasemdesign
?mEachmCORRECTmANSWER
representsmamcompletemsolution.mChoosemthree.
MyISAM
nnoDBm-
mCORRECTmANSWERmYoumaremamDatabasemAdministratormofmMySQLmdatabase.mFewmdaysmback,my
ourmservermcrashed.mNow,mit
, ismupmandmonline.mYoumneedmtomcheckmthemintegritymofmvariousmtablesmusedminmthemdatabase.mYou
mneed
tomissuemthemCHECKmTABLEmcommand.mFormwhichmofmthemfollowingmtablesmwillmthismcommandmwo
rk?
EachmCORRECTmANSWERmrepresentsmamcompletemsolution.mChoosemtwo.
DatamPump
SQL*Loader
INSERTmstatement
MERGEmstatementm-
mCORRECTmANSWERmWhichmofmthemfollowingmcanmbemusedmtompopulatemamtable?mEachmCORRECTm
ANSWERmrepresentsmamcomplete
solution.mChoosemallmthatmapply.
TheymcannotmbemwrittenmtomwithmDMLmcommandsm-
mCORRECTmANSWERmWhichmofmthemfollowingmstatementsmaboutmexternalmtablesmismtrue?
NowmmigratemthemStartmDatemattributemofm"worksmon"mrelationshipmtomthemProjectmtable.
Createmtwomtables,mEmployeemandmProject.
Createmamprimarymkeymformbothmthemtables.
MigratemthemprimarymkeymofmthemEmployeem-
mCORRECTmANSWERmYoumworkmasmamDatabasemDesignermformSoftTechmInc.mYoumhavemdevelopedmt
hemconceptualmdesignmof
themdatabasemofmanmorganization.mFollowingmismthemER-
diagram,mwhichmyoumhavemdesigned.mNowmyou
havemtomconvertmthemfollowingmdiagrammtomamlogicalmmodel.
Whichmofmthemfollowingmstepsmwillmyoumtakemtomaccomplishmthemtask?mEachmCORRECTmANSWERmr
epresents
ampartmofmthemsolution.mChoosemallmthatmapply.
FUNDAMENTALS ACTUAL EXAM ALL
QUESTIONS AND WELL
ELABORATED ANSWERS TOP RATED
VERSION FOR ALREADY A+ GRADED
HIGHLY RECOMMENDED |NEW AND
REVISED
2mNFm-
mCORRECTmANSWERmJohnmworksmasmamDatabasemAdministratormformBluewellmInc.mThemcompanym
hasmamSQLmServermdatabase.
Amtableminmthemdatabasemhasmamcandidatemkeymandmanmattributemthatmismnotmamconstituentmofmthe
candidatemkey.mThemnon-
keymattributemdependsmuponmthemwholemofmthemcandidatemkeymrathermthanmjust
ampartmofmit.mWhichmofmthemfollowingmnormalmformsmismrepresentedminmthemscenario?
LogicalmDatabasemdesignm-
mCORRECTmANSWERmYoumworkmasmamDatabasemDesignermformDataOneWorldmInc.mThemcompanymh
asmamSQLmServermdatabase.
Youmaremassignedmthemtaskmofmcreatingmamdatammodelmofmanmenterprisembasedmonmamspecificmdata
mmodel.
ThemmodelmtombemcreatedmshouldmbemindependentmofmamparticularmDBMS.mWhichmofmthemfollowin
g
databasemdesignsmwillmhelpmyoumaccomplishmthemtask?
Gatheringminformationm-
mCORRECTmANSWERmWhichmofmthemfollowingmstepsminmdatabasemplanningmhelpsmtomdeterminemth
emrequirementsmofmthe
databasemthroughminterviewing?
,Linem2m-
mCORRECTmANSWERmConsidermthemcasemofmamfruitmjuicemcompany.mThemcompanymmanufacturesmf
ruitmjuicesmandmsupplies
themmtomwholesalers.mThemDatabasemDesignermcreatesmamtablemnamedmProduction.mThemcodemism
given
below:
1.mCREATEmTablemProduction
2.m2.(Fruit_typemVarChar,
3.mFruit_namemChar(20),
4.mQuantitymInt(3))
Whichmofmthemabove-mentionedmlinesmhasmanmerror?
Relationalmmodelm-
mCORRECTmANSWERmJohnmworksmasmamDatabasemAdministratormformDataOneWorldmInc.mThemcom
panymhasmamSQLmServer
database.mJohnmwantsmtominsertmrecordsminmamtablemwheremthemdatabasemismstructuredminmamfixed
mformat.
Whichmofmthemfollowingmdatammodelsmwillmhemusemtomaccomplishmthemtask?
Filteredm-
mCORRECTmANSWERmYoummanagemamdatabasemnamedmCustomers,mwhichmincludesmamtablemname
dmOrders.mThemOrdersmtable
ismfrequentlymqueried,mbutmonlymordersmwithmamsalesmtotalmofmmoremthanm$1000.00maremrequiredm
inmthe
query.mYoumwantmtomcreatemanmindexmtomspeedmupmthesemtypesmofmqueriesmatmthemsamemtime,men
suring
themindexmismasmsmallmasmpossible.mWhatmtypemofmindexmshouldmyoumuse?
,Lockm-
mCORRECTmANSWERmWhichmofmthemfollowingmdatabasemtermsmismdescribedminmthemstatementmbel
ow?m"Itmpreventsmthe
currentmdatabasemoperationmfrommreadingmormwritingmamdatamitemmwhilemthemdatamitemmismbeing
accessedmbymanothermoperation."
Encryptionm-
mCORRECTmANSWERmYourmCompanymismdesigningmandmdevelopingmamnumbermofmdatabasesmformam
stockmexchange.mOnemofmthe
databasesmwillmcontainmhighlymsensitivemdatamformwhichmhighmlevelmofmsecuritymwillmbemrequired.
Althoughmhighmprocessingmspeedmismonemofmthemprimemrequirementsmofmthemcustomer,mformthismd
atabase,
securitymofmthemdatamwillmtakemprioritymovermthemprocessingmspeed.mItmneedsmtombemensuredmthat
meven
ifmunauthorizedmaccessmtomthemdatabasemismobtained,mthemroguemusermismunablemtomreadmthemdat
a.mWhich
ofmthemfollowingmprotectionmtechniquesmwillmyoumsuggestmformthismdatabase?
Top-downmapproach
Bottom-upmapproach
Inside-outmapproachm-
mCORRECTmANSWERmWhichmofmthemfollowingmaremthemmainmapproachesminmthemdatabasemdesign
?mEachmCORRECTmANSWER
representsmamcompletemsolution.mChoosemthree.
MyISAM
nnoDBm-
mCORRECTmANSWERmYoumaremamDatabasemAdministratormofmMySQLmdatabase.mFewmdaysmback,my
ourmservermcrashed.mNow,mit
, ismupmandmonline.mYoumneedmtomcheckmthemintegritymofmvariousmtablesmusedminmthemdatabase.mYou
mneed
tomissuemthemCHECKmTABLEmcommand.mFormwhichmofmthemfollowingmtablesmwillmthismcommandmwo
rk?
EachmCORRECTmANSWERmrepresentsmamcompletemsolution.mChoosemtwo.
DatamPump
SQL*Loader
INSERTmstatement
MERGEmstatementm-
mCORRECTmANSWERmWhichmofmthemfollowingmcanmbemusedmtompopulatemamtable?mEachmCORRECTm
ANSWERmrepresentsmamcomplete
solution.mChoosemallmthatmapply.
TheymcannotmbemwrittenmtomwithmDMLmcommandsm-
mCORRECTmANSWERmWhichmofmthemfollowingmstatementsmaboutmexternalmtablesmismtrue?
NowmmigratemthemStartmDatemattributemofm"worksmon"mrelationshipmtomthemProjectmtable.
Createmtwomtables,mEmployeemandmProject.
Createmamprimarymkeymformbothmthemtables.
MigratemthemprimarymkeymofmthemEmployeem-
mCORRECTmANSWERmYoumworkmasmamDatabasemDesignermformSoftTechmInc.mYoumhavemdevelopedmt
hemconceptualmdesignmof
themdatabasemofmanmorganization.mFollowingmismthemER-
diagram,mwhichmyoumhavemdesigned.mNowmyou
havemtomconvertmthemfollowingmdiagrammtomamlogicalmmodel.
Whichmofmthemfollowingmstepsmwillmyoumtakemtomaccomplishmthemtask?mEachmCORRECTmANSWERmr
epresents
ampartmofmthemsolution.mChoosemallmthatmapply.
