SSD7選擇題題庫(kù)完美版

alternatekeysAweakentitytypeimpliesa(a)relationshipwithtotalparticipationconstraint(b)weakrelationshiptype(c)relationshipwithpartialparticipationconstraint(d)strongrelationshiptypeCorrectansweris(a)Multiple-ChoiceQuiz11.AnE-Commercesystemconsistsofthefollowingcomponents.Whichofthesesamecomponentsmustbeincludedinadatabase?Thedata,suchasinformationaboutthegoodsavailableforsale,customers,ordersplaced,shippinginformation,etc.Adatabasemustincludeacollectionofprogramsthatcontrolthedata,suchasprogramstocreate,maintain,andmanipulatethedata.Theseprogramscanbeeasilyusedtocreate,maintain,andmanipulatedatainotherdomains.Adatabasemustincludeacollectionofprogramsthatoperateonthedata,butarespecifictotheE-commercesystem.Theseprogramsenableuserstobrowsethroughthestore-items,placeorders,trackshipping,etc.(a)I,II,andIII(b)Ionly(c)IandIIonly(d)IIonlyCorrectansweris(b)Yourscoreonthisquestionis:14.29Feedback:Databasereferstojustthedata2.Inadatabasesystem,whoseresponsibilityisittoprovidedataconsistency?(a)thedatabaseadministrator's(b)theuser's(c)theapplicationprogrammer's(d)theDBMS'sCorrectansweris(d)3.AnE-Commercesystemconsistsofthefollowingcomponents.Whichofthesamecomponentsmustbeincludedinadatabasemanagementsystem?Thedata,suchasinformationaboutthegoodsavailableforsale,customers,ordersplaced,shippinginformation,etc.Acollectionofprogramsmustbeincludedthatcontrolthedata,suchasprogramstocreate,maintain,andmanipulatethedata.Theseprogramscanbeeasilyusedtocreate,maintain,andmanipulatedatainotherdomains,suchasinalibraryinformationsystem.Acollectionofprogramsthatoperateonthedata,butarespecifictotheE-commercesystem.Theseprogramsenableuserstobrowsethroughthestore-items,placeorders,trackshipping,etc.(a)IIandIIIonly(b)IIonly(c)Ionly(d)I,II,andIIICorrectansweris(b)Feedback:ADBMSreferstojustthesetofgeneral-purposeprogramstocontroldata.4.AnE-Commercedatabasecontainsdataaboutcustomers,products,orders,systemresponsetimes,etc.WhichofthefollowingcanbespecifiedasintegrityconstraintsinanE-Commercedatabasesystem?NotwoproductscanhavethesameproductID.TheDBMSresponsetimeforallWebrequestsshouldbeatmost2seconds.Acustomerordercannothavemorethanoneshippingaddress.(a)Ionly(b)IandIIonly(c)IandIIIonly(d)I,II,andIIICorrectansweris(c)Feedback:TheconstraintsI,IIandIIIspecifytheapplicationsemanticsofthedatacapturedintheE-Commercedatabase.ConstraintIII,althoughitseemscontrarytocommonsense,isnotsomethingthatcanbeprohibitedbytheDBMSbecausetheDBMSisgeneralpurpose.TheresponsetimeoftheDBMScannotbeenforcedbytheDBMS.Itdependsonfactorssuchtheprocessorspeed,memoryavailable,etc.5.AnE-Commercesystemconsistsofthefollowingcomponents.Whichofthesesamecomponentswillconstituteadatabasesystem?Thedata,suchasinformationaboutthegoodsavailableforsale,customers,ordersplaced,shippinginformation,etc.Acollectionofprogramsthatcontrolthedata,suchasprogramstocreate,maintain,andmanipulatethedataconstitutesadatabasesystem.Theseprogramscanbeeasilyusedtocreate,maintain,andmanipulatedatainotherdomainssuchasinalibraryinformationsystem.Acollectionofprogramsthatoperateonthedata,butarespecifictotheE-commercesystem,constitutesadatabasesystem.Theseprogramsenableuserstobrowsethroughthestore-items,placeorders,trackshipping,etc.(a)IandIIonly(b)Ionly(c)IIonly(d)I,II,andIIICorrectansweris(d)Feedback:Adatabasesystemincludesthedata,theDBMS,andtheapplication-specificprogramsthatoperateonthatdata.6.Adatabaseisneededforwhichofthefollowingapplicationscenarios?IAvideostorethatneedstokeeptrackofdataaboutmembers,aboutvideoscarriedbythestore,aboutvideosrentedbymembers,aswellasdataconcerningborrow-date,return-date,andpaymentinformation.II．Inthehumanresourcesdepartmentofacompany,informationaboutemployees,theirtitles,theirsalariesandsickdays,andaboutvacationdaystakenbyeachemployee.III．Acomputer-simulatedvideogamewhichneedstocalculateanddisplay,thephysical(x,y)locationofeachactorinthegame,thespeedwithwhichtheyaremovingatthecurrentinstant,thedirectioninwhichtheyaremoving,theactiontheyareperforming,theangleatwhichthegame-playerisviewingthescene.(a)IandIIonly(b)IandIIIonly(c)I,II,andIII(d)IonlyCorrectansweris(a)Feedback:(c)Unrelateddatasuchassitedowntimes,priceofgoods,employees,etcdonotconstituteadatabase.7.Thephysicalstoragestructurewillbe_____totheapplicationprogrammerinadatabaseapproach,andwillbe_____totheapplicationprogrammerinafilesystemapproach.(a)hidden,hidden(b)visible,visible(c)hidden,visible(d)visible,hiddenCorrectansweris(c)MultipleChoice21.Thecardinalityofatableisthenumberof_____inthetable.(a)columns(b)keys(c)rows(d)foreignkeysCorrectansweris(c)2.Thedegreeofatableisthenumberof_____inthetable.(a)foreignkeys(b)columns(c)rows(d)keysCorrectansweris(b)Yourscoreonthisquestionis:10.004.Thearity元數(shù)ofatableisthenumberof_____inthetable.(a)rows(b)foreignkeys(c)columns(d)keysCorrectansweris(c)3.Whatinformationisnecessarywhenspecifyingthestructureofatable?(a)thenameofthetable,thenamesofthetable'sattributes,thedatatypesofattributes,andtheformatsofattributes(b)thenameofthetableandthenamesofthetable'sattributes(c)thenameofthetableandtheamountofstoragespacetobeallocatedtothetable(d)thenameofthetable,thethetable'sattributes,thedatatypesofthetable'sattributes,theformatsofthetable'sattributes,andthemaximumnumberofrowsthatthetablecanhaveCorrectansweris(a)Yourscoreonthisquestionis:10.005.Ajoinoperationjoins_____tablesinto_____.(a)three,one(b)two,one(c)four,two(d)three,twoCorrectansweris(b)Yourscoreonthisquestionis:10.006.WhichofthefollowingSQLstatementscanbeusedtoremovearowfromatable?(a)REMOVE(b)ERASE(c)DESTROY(d)DELETECorrectansweris(d)8.WhichofthefollowingSQLstatementscanbeusedtomodifyjustonerow(outofmanyrows)inatable?(a)CHANGE(b)ALTER(c)MODIFY(d)UPDATECorrectansweris(d)Yourscoreonthisquestionis:10.009.WhichofthefollowingSQLstatementscanbeusedtoaddarowtoatable?(a)CREATE(b)APPEND(c)INSERT(d)ADDCorrectansweris(c)Yourscoreonthisquestionis:10.007.DMLisusedto(a)manipulatethestructureofdatabaseapplications.(b)specifythestructureofadatabase.(c)add/modify/deletedatainthedatabase.(d)addanddeletetables.Correctansweris(c)8.DDLisusedto(a)definethestructureofdatabaseapplications.(b)specifythestructureofadatabase.(c)accessthecontentsoftables.(d)addcontentstotables.Correctansweris(b)9.WhichofthefollowingSQLstatementscanbeusedtocreatearelationaltable?(a)APPEND(b)INSERT(c)ADD(d)CREATECorrectansweris(d)Yourscoreonthisquestionis:10.0010.Thetermquerybyexamplerefersto(a)aqueryforSQLexamples(b)exampleSQLqueriesprovidedbyotherusersthatcanbemodifiedtosuitcurrentneeds(c)avisualquerylanguagedevelopedbyIBM(d)exampleSQLqueriesprovidedbytheDBMSthatuserscanmodifytosuittheircurrentneedsCorrectansweris(c)Yourscoreonthisquestionis:10.001.TheforeignkeyinatableT1_____thesame_____asthecorrespondingprimarykeyintableT2.musthave,nameneednothave,namemusthave,domain(a)IandIII(b)IandII(c)IIandIII(d)I,II,andIIICorrectansweris(c)Yourscoreonthisquestionis:10.005.WhatcanbespecifiedintheselectionconditionofaSELECTstatement?(a)aBooleanoperation(b)theconditionsunderwhichthestatementshouldbeexecuted(c)thetimeatwhichtheselectionshouldbeperformed(d)anarithmeticoperationCorrectansweris(a)6.TheSQLclausetoperformasetUNIONoperationis(a)MELD(b)UNION(c)UNITE(d)COMBINECorrectansweris(b)Yourscoreonthisquestionis:10.005.TheSQLclausetoperformasetdifferenceoperationis(a)DIFFER(b)OMIT(c)REJECT(d)EXCEPTCorrectansweris(d)Yourscoreonthisquestionis:10.008.Adifferenceoperationcanbeappliedtotablesthat(a)arethesamesize(b)havethesamecolumnnames(c)areunioncompatible(d)havethesamenameCorrectansweris(c)Yourscoreonthisquestionis:0.009.Adeletionoperationwill_____ifthedeletionleadstotheviolation違反ofareferentialintegrityconstraint.(a)succeedwithoutwarning(b)succeedwithwarning(c)fail(d)crashthesystemCorrectansweris(c)Yourscoreonthisquestionis:10.00Multiple-ChoiceQuiz31.WhenastringwhoselengthisstrictlylessthannisenteredasthevalueofafieldwhoseSQLdatatypeisVARCHAR(n),thesystemrespondsby(a)paddingtheendofthestringwithspacestolengthnbeforestoringit.(b)paddingtheendofthestringwithNULLcharacterstolengthnbeforestoringit.(c)re-promptingfortheentryofastringwhoselengthisexactlyn.(d)storingthestringasis.Correctansweris(d)2.InSQL,whendestroyingadatabase,theRESTRICToptionremoves(a)theschemaifthedatabasehasnodata(emptytables)(b)thedataandschemafromthespecifieddatabase,butnotfromrelateddatabases(c)thedatabutnottheschema(d)everythinginthespecifieddatabase:thedata,schema,etc.Correctansweris(a)Yourscoreonthisquestionis:10.003.Whenremovingatablefromtheschema,usingtheRESTRICToptionwould(a)removethetableandallothertablesthatthespecifiedtablerefersto(b)recursivelyremovethetableandallothertablesthattheremovedtablerefersto(c)removethetableandallreferencestoit(d)removethetableiftherearenoreferencestoitCorrectansweris(d)Yourscoreonthisquestionis:10.004.InSQL,onefunctionoftheASoperatoristo(a)definethedomainofanattribute(b)controltheorderinwhichaquery’srowsaresorted(c)limitthecardinalityofarelation(d)customizethenamesofcolumnsinaquery’sresultCorrectansweris(d)Yourscoreonthisquestionis:10.00Feedback:Seesection2.1.2,subsection"AliasinginSQL:TheASoperator,"inthecoursenotes.5.InSQL,adatabasecanbecreatedbywhichofthefollowing?(a)thecommandADDDATABASE(b)thecommandCREATESCHEMA(c)thecommandINSERTDATABASE(d)aseriesofCREATETABLEcommandsCorrectansweris(b)Yourscoreonthisquestionis:10.006.InSQL,adatabasecanbedestroyedbywhichofthefollowing?(a)thecommandDESTROYDATABASE(b)aseriesofDESTROYTABLEcommands(c)thecommandDROPSCHEMA(d)thecommandDELETEDATABASECorrectansweris(c)Yourscoreonthisquestionis:10.007.InSQL,whichofthefollowingclausescanbeusedtosortresultsinascendingordescendingorderofattributevalues?(a)SORT(b)GROUPBY(c)ORDERBY(d)ARRANGEBYCorrectansweris(c)Yourscoreonthisquestionis:10.008.WhenspecifyingaselectioncriterioninSQL,attributescanberenamedwithwhichofthefollowingoperators?(a)AS(b)RENAME(c)ALIAS(d)@Correctansweris(a)Yourscoreonthisquestionis:10.00FROMSELECT7.InaclauseofastatementinSQL,atablecanbealiasedwithwhichofthefollowingoperators?AS(a)ALIAS(b)@(c)RENAME(d)Correctansweris(a)Yourscoreonthisquestionis:8.WhenspecifyingaselectioncriterioninSQL,attributescanberenamedwithwhichofthefollowingoperators?AS(a)RENAME(b)ALIAS(c)@(d)Correctansweris(a)Yourscoreonthisquestionis:9.InaFROMclauseofaSELECTstatementinSQL,atablecanbealiasedwithwhichofthefollowingoperators?(a)ALIAS(b)@(c)RENAME(d)ASCorrectansweris(d)Yourscoreonthisquestionis:10.0010.InSQL,whichofthefollowingoperatorscanbeusedtoexpresssearchesthattestforarangeinaselectioncondition?(a)FROMandTO(b)RANGE(c)BETWEEN(d)STARTandENDCorrectansweris(c)Multiple-ChoiceQuiz41.Averticalviewallowsusersaccessto(a)onlytheusertables(b)onlyspecificcolumnsofthedefiningtables(c)onlyspecificrowsofthedefiningtables(d)onlythesystemtablesCorrectansweris(b)Yourscoreonthisquestionis:10.002.Whichofthefollowingistrueaboutupdateabilityofviews?(a)Aviewisupdateableifitinvolvesmultipletablesandnokeys.(b)Aviewisupdateableifitinvolvesonetableanddoesnotcontainakey.(c)Aviewisnotupdateableunderanycircumstance.(d)Aviewisupdateableifitinvolvesonetableandcontainsakey.Correctansweris(d)2.Whichofthefollowingistrueaboutupdateabilityofviews?(a)Aviewisupdateableunderallcircumstances.(b)Aviewisnotupdateableifitinvolvesonetableandcontainsakey.(c)Aviewisnotupdateableifitinvolvesaggregatefunctionsandnestedqueries.(d)Aviewisnotupdateableunderanycircumstance.Correctansweris(c)3.Ahorizontalviewallowsusersaccessto(a)onlyspecificcolumnsofthedefiningtables(b)onlythesystemtables(c)onlyspecificrowsofthedefiningtables(d)onlythebasetablesCorrectansweris(c)Yourscoreonthisquestionis:10.004.Considertwotables,Employee(EmpNo,Name,DeptNo)andDepartment(DeptNo,Name,Manager)withprimarykeysbeingEmpNoandDeptNorespectively.TheDeptNoattributeoftheEmployeetablehasaNOTNULLconstraintandisaforeignkeythatreferencestheDeptNoattributeoftheDepartmenttable.TheManagerattributeoftheDepartmenttablehasaNOTNULLconstraintandisaforeignkeythatreferencestheEmpNoattributeoftheEmployeetable.Whenthetablesareempty,theonlywaytoinsertrowsintothetwotablesis(a)nottouseatransactionatall(b)touseatransactioneitherinDEFERRABLEmodeorinNOTDEFERRABLEmode(c)touseatransactioninNOTDEFERRABLEmode(d)touseatransactioninDEFERRABLEmodeCorrectansweris(d)Yourscoreonthisquestionis:10.005.WhichofthefollowingreferentiallytriggeredactionsaresupportedinSQLwhenareferentialintegrityconstraintisviolatedSETNULLREJECTCASCADESETDEFAULT(a)I,II,andIIIonly(b)I,III,andIVonly(c)IIandIIIonly(d)IandIVonlyCorrectansweris(b)6.Whichofthefollowingcommandscanbeusedtogiveaccesspermissionstoatable?(a)ALLOW(b)AUTHORIZE(c)PERMIT(d)GRANTCorrectansweris(d)7.Whocanalwaysgiveaccesspermissionstoatable?(a)theownerofthetable(b)onlythesuper-user(c)onlythedatabaseadministrator(DBA)(d)theuserofthetableCorrectansweris(a)8.Whichofthefollowingcommandscanbeusedtoremoveaccessprivilegesassociatedwithatable?(a)REVOKE(b)REMOVE(c)DENY(d)RETRACTCorrectansweris(a)9.WhenisembeddedSQLreferredtoasstaticSQL?(a)whentheembeddedSQListranslatedintoDBMScallsatcompile-time(b)whentheembeddedSQLalwaysreturnsthesamesetofresults(c)whentheembeddedSQLoperatesonthestaticpartofthedatabase(d)whentheSQLstatementscanneverbechangedCorrectansweris(a)Yourscoreonthisquestionis:10.0010.WhenisembeddedSQLreferredtoasdynamicSQL?(a)whentheSQLstatementsarechangedineveryrun(b)whentheembeddedSQListranslatedintoDBMScallsatrun-time(c)whentheembeddedSQLalwaysreturnsdifferentsetsofresults(d)whentheembeddedSQLoperatesonthedynamicpartofthedatabaseCorrectansweris(b)2.Whichofthefollowingistrueaboutviewsbeinguptodate?(a)Viewscanbeautomaticallymadeuptodateperiodicallybythesystem.(b)Viewsareuptodateonlyafterthesynchronizationoperationbytheuser.(c)Viewsareneveruptodate;thereisalwaysalagtime.(d)Viewsarealwaysuptodate.Correctansweris(d)5.TheSQLkeyword_____makesthemodificationsofthetransactionpermanent,whiletheSQLkeyword_____discardsthemodificationsofthetransaction.(a)COMMIT,ROLLBACK(b)UPDATE,SELECT(c)SAVE,CANCEL(d)WRITE,ABORTCorrectansweris(a)Exam1Multiple-Choice1.Aninsertionoperationwill_____iftheinsertedprimarykeyhasaNULLvalue.(a)crashthesystem(b)fail(c)succeedwithoutwarning(d)succeedwithwarningCorrectansweris(b)2.Whatisanalternatekey?(a)Thekeytousewhentheprimarykeydoesnotwork(b)Anykeythatisnotaprimarykey(c)Akeythatwasaddedtothetableafterthetablewasdesigned(d)AkeythatwillbecometheprimarykeywhentheprimarykeyisdeletedCorrectansweris(b)Yourscoreonthisquestionis:5.003.Whichofthefollowingistrueaboutthenumberofprimarykeysandalternatekeyswithrespecttoatable?(a)Therecanbemanyprimarykeys,butonlyonealternatekey.(b)Therecanbemanyprimarykeysandmanyalternatekeys.(c)Therecanbeonlyoneprimarykey,butmanyalternatekeys.(d)Therecanbeonlyoneprimarykeyandonlyonealternatekey.Correctansweris(c)Yourscoreonthisquestionis:5.004.Whatdoesaprojectionoperationdo?(a)Itextendsthenumberofcolumnsinatable.(b)Itselectsrowsfromatable.(c)Itselectscolumnsfromatable.(d)Itextendsthenumberofrowsinatable.Correctansweris(c)5.Theresultofasetdifferenceoperationr-swillbe(a)tuplesinsafterdeductingtheirvaluesbythecorrespondingvaluesinthetuplesinr(b)thosetuplesthatareinsbutnotinr(c)tuplesinrafterdeductingtheirvaluesbythecorrespondingvaluesinthetuplesins(d)thosetuplesthatareinrbutnotinsCorrectansweris(d)6.Intherelationalmodel,whichofthefollowingistrueaboutthedatatypeofacolumn?(a)Itmustbeatomicanditcanbeanabstractdatatype.(b)Itneednotbeatomicanditcannotbeanabstractdatatype.(c)Itneednotbeatomicanditcanbeanabstractdatatype.(d)Itmustbeatomicanditcannotbeanabstractdatatype.Correctansweris(d)7.Aninsertionoperationwill_____iftheinsertionviolatestheuniquenesspropertyofakey.(a)succeedwithoutwarning(b)fail(c)succeedwithwarning(d)crashthesystemCorrectansweris(b)8.WhichofthefollowingistrueaboutprimarykeysandforeignkeysholdingNULLvalue?(a)AprimarykeycanholdaNULLvalueandaforeignkeycanholdaNULLvalue(b)AprimarykeycannotholdaNULLvalueandaforeignkeycannotholdaNULLvalue(c)AprimarykeycanholdaNULLvalueandaforeignkeycannotholdaNULLvalue(d)AprimarykeycannotholdaNULLvalueandaforeignkeycanholdaNULLvalueCorrectansweris(d)9.Withrespecttoarelationaltable,whatisakey?(a)Theonecolumnthatuniquelyidentifiesarowinthetable(b)Thesubsetofalltherowsandcolumnsinthetablethatarevisibletoallusersinthedatabasesystem(c)Aminimalsubsetofcolumnsthatuniquelyidentifiesarowinthetable(d)TheIDandpasswordneededtoaccessthetableCorrectansweris(c)10.Fortwotablestobeunioncompatible,correspondingcolumnsfromeachtableshouldhavewhichofthefollowing?(a)differentnames(b)differentdomains(c)thesamename(d)thesamedomainCorrectansweris(d)11.InSQL,theresultsofa_____statementcanbeusedtoprocessa_____statement.(a)INSERT,SELECT(b)DELETE,INSERT(c)SELECT,INSERT(d)INSERT,DELETECorrectansweris(c)12.Incontrastto_____tables,aviewrefersto_____.(a)virtual,basetables(b)non-empty,emptytables(c)empty,non-emptytables(d)base,avirtualtableCorrectansweris(d)13.InSQL,whichofthefollowingoperatorsareusedtocheckforsetmembershipinaSELECTstatement?(a)SUBSETandNOTSUBSET(b)MEMBERandNOTMEMBER(c)COMPONENTandNOTCOMPONENT(d)INandNOTINCorrectansweris(d)14.WhichofthefollowingSQLcommandscanbeusedtodestroyandremoveatablefromtheschema?(a)DESTROYTABLE(b)DROPTABLE(c)REMOVETABLE(d)DELETETABLECorrectansweris(b)15.Whichofthefollowingistrueaboutthephysicalstorageoftablesdefinedbyviews?(a)Thereisnoextraphysicalstorageneededtostoretablesthataviewdefines.(b)Extraphysicalstorageisneededforstoringthetablesdefinedbyviews,onlyifviewsdefineadditionalnon-existingcolumns.(c)Extraphysicalstorageisneededtostoretablesthataviewdefines,onlywhenrowsareinsertedintotheview.(d)Extraphysicalstorageisalwaysneededtostoretablesthataviewdefines.Correctansweris(a)16.WhenastringwhoselengthisstrictlylessthannisenteredasthevalueofafieldwhoseSQLdatatypeisCHAR(n),thesystemrespondsby(a)storingthestringasis(b)paddingtheendofthestringwithspacestolengthnbeforestoringit(c)re-promptingfortheentryofastringwhoselengthisexactlyn(d)paddingtheendofthestringwithNULLcharacterstolengthnbeforestoringitCorrectansweris(b)17.Whenremovingatablefromtheschema,usingtheCASCADEoptionwould(a)recursivelyremovethetableandallothertablesthattheremovedtablerefersto(b)removethetableandallothertablesthatthespecifiedtablerefersto.(c)removethetableandallreferencestoit(d)removethetableiftherearenoreferencestoitCorrectansweris(c)18.Inatransaction,aROLLBACKisusedto(a)discardalltheupdates(includinginserts,deletes,modifications)ofatransactionfromthedatabase(b)discardonlytheinsertsandupdatesofatransactionfromthedatabase(c)rollalltheupdates(includinginserts,deletes,modifications)ofanabortedtransactionintothedatabase(d)rollonlytheinsertsanddeletesofanabortedtransactionintothedatabaseCorrectansweris(a)19.WhichofthefollowingSQLcommandscanbeusedtochange,add,ordropcolumndefinitionsfromatable?(a)UPDATETABLE(b)MODIFYTABLE(c)CHANGETABLE(d)ALTERTABLECorrectansweris(d)20.Inatransaction,COMMITspecifiesthat(a)onlytheinsertsanddeletesofatransactionaretobemadepermanentinthedatabase(b)allupdates(includinginserts,deletes,modifications)ofatransactionaretobemadepermanentinthedatabase(c)allupdates(includinginserts,deletes,modifications)ofatransactionareabouttobemadepermanentinthedatabase(d)onlytheinsertsanddeletesofatransactionareabouttobemadepermanentinthedatabaseCorrectansweris(b)Multiple-ChoiceQuiz51.InanERmodel,thecardinalityratioofarelationshiptypeis(a)thenumberofrelationshipsofthatrelationshiptypeinwhichanentitycanparticipate(b)theminimumnumberofentitiesthatcanparticipateinthatrelationshiptype(c)thenumberofinstancesofrelationshipsofthatrelationshiptype(d)thenumberofentitytypesinvolvedinthatrelationshiptypeCorrectansweris(a)2.IntheEntity-Relationshipmodel,aderivedattributeisone(a)thatiscomposedofmultipleatomicattributes(b)thatmayhavemultiplevaluessimultaneously(c)thatcharacterizesarelationshipinsteadofanentity(d)whosevaluecanbecomputedfromthevaluesofotherattributesCorrectansweris(d)Feedback:Seesection3.2.1,subsection"Attributes,"inthecoursenotes.3.Aweakentitytypeimpliesa(a)relationshipwithtotalparticipationconstraint(b)weakrelationshiptype(c)relationshipwithpartialparticipationconstraint(d)strongrelationshiptypeCorrectansweris(a)4.InanERmodel,whatisarecursiverelationshiptype?(a)Thetypeofrelationshipthatdoesnotbelonganywhere(b)Therelationshiptypewheretherelatedentitiesareoneandthesame(c)Thetypeofrelationshipbetweenentitiesofoneentitytype(d)Anever-endingtypeofrelationshipCorrectansweris(c)5.IntheEntity-Relationshipmodel,thedegreeofarelationshipspecifieswhichofthefollowing?(a)Thenumberofintegrityconstraintsrequiredtoimplementtherelationship(b)Thenumberofentitiesthatparticipateintherelationship(c)Thecardinalityratiooftherelationship(d)ThenumberofattributesthatcharacterizetherelationshipCorrectansweris(b)Feedback:Seesection3.2.1,subsection"EntitiesandRelationships,"inthecoursenotes.6.InanERmodel,whichofthefollowingistrueaboutacomponentattribute?(a)Componentattributesmustalwaysbecombinedbyanaggregationoperation.(b)Acomponentattributealwayscontainsothercomponents.(c)Acomponentattributeisalwaysatomic.(d)Acomponentattributecanbeacompositeattribute.Correctansweris(d)7.Whichofthefollowingistrueaboutstorageforderivedattributes?(a)Derivedattributesareusuallynotstoredbecausetheycanbecomputed.(b)Derivedattributesareusuallystoredbecausestorageimprovesretrievalperformance.(c)Derivedattributesmustnotbestored.(d)Derivedattributesmustbestored.Correctansweris(a)8.InEERmodeling,generalizationistheprocessofgenerating(a)superclassesoutofsubclasses(b)subclassesoutofsuperclasses(c)entitiesoutofattributes(d)attributesoutofentitiesCorrectansweris(a)9.Whichofthefollowingistrueaboutattributesinarelationalmodel?Attributescanbemulti-valued.Attributescanbecomposite.(a)Ionly(b)NeitherInorII(c)BothIandII(d)IIonlyCorrectansweris(b)10.WhenmappingfromanERmodeltoarelationalmodel,entityismappedintoa(a)column(b)table(c)key(d)rowCorrectansweris(b)7.WhatisanidentifyingownerinanERmodel?(a)Theentityuponwhichastrongentity'sexistencedepends(b)Theentityuponwhichaweakentity'sexistencedepends(c)Therelationshipthatidentifiesastrongentity'sowner(d)Therelationshipthatidentifiesaweakentity'sownerCorrectansweris(b)Multiple-ChoiceQuiz61.Throughnormalization,dataredundancy(a)areusuallyleftunchanged(b)canbeminimizedbutnoteliminated(c)canbemaximized(d)canbeeliminatedCorrectansweris(d)2.Whichofthefollowingproblemscanbecausedbydataredundancyinarelationalschema?InefficientuseofspaceUpdateanomaliesandpossiblelossofdataInefficientuseofprocessingtime(a)IandIIonly(b)IandIIIonly(c)I,II,andIII(d)IIonlyCorrectansweris(c)Feedback:Seesection3.3.1inthecoursenotes.3.Whichofthefollowingisaproperty(areproperties)exhibitedbygoodrelationalschemas?Theuseofnullvaluesintuples（元組）ThegroupingofasmanyattributesaspossibleintoonemaintableTheeliminationofdataredundancytoavoidupdateanomalies(a)None(b)IIandIIIonly(c)IIIonly(d)IandIIonlyCorrectansweris(c)Feedback:Seesection3.3.1inthecoursenotes.4.Whichofthefollowingstatementsconcerningnormalformsistrue?(a)Arelationthatisinsecondnormalformisalsoinfirstnormalform.(b)Eachnormalformcontainsastateofindependentproperties,unrelatedtoothernormalforms.(c)Thelowerthenormalformnumber,thebettertheschemadesignis.(d)Schemasthatareinsecondnormalformareconsideredthebest.Correctansweris(a)Feedback:Seesection3.3.1inthecoursenotes.5.Throughnormalization,updateanomalies(a)isusuallyleftunchanged(b)canbeeliminated(c)canbemaximized(d)canbeminimizedbutnoteliminatedCorrectansweris(b)6.ConsideratablewithatomicattributesA,B,andCandthefollowingfunctionaldependencies.A->BB->CIftheprimarykeyofthistableisattributeA,thenthisrelationsatisfieswhichofthefollowingnormalforms?FirstSecondThird(a)None(b)I,IIandIII(c)Ionly(d)IandIIonlyCorrectansweris(d)Feedback:Seesection3.3.2inthecoursenotes.7.Forarelationtobein3NF,itshouldnotcontain_____attributethatistransitivelydependenton_____.(a)anon-primarykey,aforeignkey(b)aprimarykey,anon-primar