MTA DATABASE ADMINISTRATION:
EXAM 98-364 STUDENT STUDY GUIDE
UPDATE|EXAM
QUESTIONS WITH MULTIPLE
CHOICES |VERIFIED & REVISED
ANSWERS (NEW)!!!
UnderstandingmCoremDatabasemConcepts:
Identifymtablesmthatmcouldmbemusedmtomcreatemamdatabase:
a.mampartsmtable,mamcyclemtable,mandmanmaccessoriesmtable
b.monemtablemformallmparts,mcyclesmandmaccessories
c.mamtablemformeachmpart,meachmcyclemandmeachmtypemofmaccessorym(amhelmetmtable,mambikingmglov
emtable,metc.)m-mCORRECTmANSWERma
Identifymthemfieldmthatmcouldmbemusedmformcolumnmheadingsmofmthempartsmtable.
a.mpartmnumber,mpartmname,mcyclemnumbermandmcyclemname
b.mpartmnumbermandmquantitymsold
c.mpartmnumber,mpartmname,mquantity,mcolormandmcyclemidentiferm-mCORRECTmANSWERmc
Whatmismthemnamemofmthemdatamlocatedmatmthemintersectionmofmamrowmandmcolumn?
a.mfield
b.mrecord
c.mvariablem-mCORRECTmANSWERma
Whatmismthemrelationshipmbetweenmthemsuppliermtablemandmthempartsmtable?
a.monemtomone
, b.monemtommany
c.mmanymtommanym-mCORRECTmANSWERmb
Whatmismamgoodmforeignmkeymformthemrelationshipmbetweenmthemcyclemtablemandmthempartsmtable?
a.mpartmnumber
b.mcyclemmodelmnumber
c.mpartmnamem-mCORRECTmANSWERma
Whatmismamsuggestedmprimarymkeymformthemaccessorymtable?
a.maccessorymnumber
b.maccessorymname
c.maccessorymmodelm-mCORRECTmANSWERma
WhatmDMLm(datammanipulationmlanguage)mcommandmmustmbemusedmtomindicatemthatmamcyclemwa
smsold
andmshouldmbemremovedmfrommthemCyclemtable?
a.mDELETEmFROMmCyclemWHEREmcyclem_midm=mT1234
b.mREMOVEmFROMmCyclemWHEREmcyclem_midm=mT1234
c.mERASEmFROMmCyclemWHEREmcyclem_midm=mT1234m-mCORRECTmANSWERma
Whatmcommandmismusedmtomreportmonmthemcurrentmon-handmquantitiesmofmredmcycles?
a.mSELECTmcycle_modelmWHEREmcycle_colorm=m'red'
b.mSELECTm*mFROMmCyclemWHEREmcycle_colorm=m'red'
c.mFROMm*mFROMmCyclemWHEREmcycle_colorm=m'red'm-mCORRECTmANSWERmb
HowmismamnewmcyclemaddedmtomthemCyclemtableminmthemdatabase?
EXAM 98-364 STUDENT STUDY GUIDE
UPDATE|EXAM
QUESTIONS WITH MULTIPLE
CHOICES |VERIFIED & REVISED
ANSWERS (NEW)!!!
UnderstandingmCoremDatabasemConcepts:
Identifymtablesmthatmcouldmbemusedmtomcreatemamdatabase:
a.mampartsmtable,mamcyclemtable,mandmanmaccessoriesmtable
b.monemtablemformallmparts,mcyclesmandmaccessories
c.mamtablemformeachmpart,meachmcyclemandmeachmtypemofmaccessorym(amhelmetmtable,mambikingmglov
emtable,metc.)m-mCORRECTmANSWERma
Identifymthemfieldmthatmcouldmbemusedmformcolumnmheadingsmofmthempartsmtable.
a.mpartmnumber,mpartmname,mcyclemnumbermandmcyclemname
b.mpartmnumbermandmquantitymsold
c.mpartmnumber,mpartmname,mquantity,mcolormandmcyclemidentiferm-mCORRECTmANSWERmc
Whatmismthemnamemofmthemdatamlocatedmatmthemintersectionmofmamrowmandmcolumn?
a.mfield
b.mrecord
c.mvariablem-mCORRECTmANSWERma
Whatmismthemrelationshipmbetweenmthemsuppliermtablemandmthempartsmtable?
a.monemtomone
, b.monemtommany
c.mmanymtommanym-mCORRECTmANSWERmb
Whatmismamgoodmforeignmkeymformthemrelationshipmbetweenmthemcyclemtablemandmthempartsmtable?
a.mpartmnumber
b.mcyclemmodelmnumber
c.mpartmnamem-mCORRECTmANSWERma
Whatmismamsuggestedmprimarymkeymformthemaccessorymtable?
a.maccessorymnumber
b.maccessorymname
c.maccessorymmodelm-mCORRECTmANSWERma
WhatmDMLm(datammanipulationmlanguage)mcommandmmustmbemusedmtomindicatemthatmamcyclemwa
smsold
andmshouldmbemremovedmfrommthemCyclemtable?
a.mDELETEmFROMmCyclemWHEREmcyclem_midm=mT1234
b.mREMOVEmFROMmCyclemWHEREmcyclem_midm=mT1234
c.mERASEmFROMmCyclemWHEREmcyclem_midm=mT1234m-mCORRECTmANSWERma
Whatmcommandmismusedmtomreportmonmthemcurrentmon-handmquantitiesmofmredmcycles?
a.mSELECTmcycle_modelmWHEREmcycle_colorm=m'red'
b.mSELECTm*mFROMmCyclemWHEREmcycle_colorm=m'red'
c.mFROMm*mFROMmCyclemWHEREmcycle_colorm=m'red'm-mCORRECTmANSWERmb
HowmismamnewmcyclemaddedmtomthemCyclemtableminmthemdatabase?
