MSSQL编程：明天考数据库,这是标题和我的谜底!

提供TCP/IP、ODBC和JDBC等多种数据库连接路径。数据|数据库
标题:

一.单项选择





1.







Withrespecttoarelationaltable,whatisakey?















(a)Aminimalsubsetofcolumnsthatuniquelyidentifiesarowinthetable(b)TheIDandpasswordneededtoaccessthetable(c)Thesubsetofalltherowsandcolumnsinthetablethatarevisibletoallusersinthedatabasesystem(d)Theonecolumnthatuniquelyidentifiesarowinthetable















2.







Whichofthefollowingistrueaboutthenumberofprimarykeysandalternatekeyswithrespecttoatable?















(a)Therecanbemanyprimarykeys,butonlyonealternatekey.(b)Therecanbeonlyoneprimarykey,butmanyalternatekeys.(c)Therecanbeonlyoneprimarykeyandonlyonealternatekey.(d)Therecanbemanyprimarykeysandmanyalternatekeys.















3.







Aninsertionoperationwill_____iftheinsertionviolatestheuniquenesspropertyofakey.















(a)succeedwithwarning(b)crashthesystem(c)fail(d)succeedwithoutwarning















4.







Aninsertionoperationwill_____iftheinsertedprimarykeyhasaNULLvalue.















(a)succeedwithwarning(b)succeedwithoutwarning(c)fail(d)crashthesystem















5.







Fortwotablestobeunioncompatible,correspondingcolumnsfromeachtableshouldhavewhichofthefollowing?















(a)differentdomains(b)differentnames(c)thesamedomain(d)thesamename















6.







Intherelationalmodel,whichofthefollowingistrueaboutthedatatypeofacolumn?















(a)Itneednotbeatomicanditcannotbeanabstractdatatype.(b)Itmustbeatomicanditcannotbeanabstractdatatype.(c)Itneednotbeatomicanditcanbeanabstractdatatype.(d)Itmustbeatomicanditcanbeanabstractdatatype.















7.







Whatisanalternatekey?















(a)Anykeythatisnotaprimarykey(b)Thekeytousewhentheprimarykeydoesnotwork(c)Akeythatwasaddedtothetableafterthetablewasdesigned(d)Akeythatwillbecometheprimarykeywhentheprimarykeyisdeleted















8.







Whatdoesaprojectionoperationdo?















(a)Itextendsthenumberofcolumnsinatable.(b)Itselectsrowsfromatable.(c)Itextendsthenumberofrowsinatable.(d)Itselectscolumnsfromatable.















9.







Theresultofasetdifferenceoperationr-swillbe















(a)tuplesinrafterdeductingtheirvaluesbythecorrespondingvaluesinthetuplesins(b)tuplesinsafterdeductingtheirvaluesbythecorrespondingvaluesinthetuplesinr(c)thosetuplesthatareinsbutnotinr(d)thosetuplesthatareinrbutnotins















10.







WhichofthefollowingistrueaboutprimarykeysandforeignkeysholdingNULLvalue?















(a)AprimarykeycanholdaNULLvalueandaforeignkeycannotholdaNULLvalue(b)AprimarykeycannotholdaNULLvalueandaforeignkeycannotholdaNULLvalue(c)AprimarykeycanholdaNULLvalueandaforeignkeycanholdaNULLvalue(d)AprimarykeycannotholdaNULLvalueandaforeignkeycanholdaNULLvalue















11.







Incontrastto_____tables,aviewrefersto_____.















(a)base,avirtualtable(b)empty,non-emptytables(c)non-empty,emptytables(d)virtual,basetables















12.







Whenremovingatablefromtheschema,usingtheCASCADEoptionwould















(a)removethetableandallreferencestoit(b)recursivelyremovethetableandallothertablesthattheremovedtablerefersto(c)removethetableandallothertablesthatthespecifiedtablerefersto.(d)removethetableiftherearenoreferencestoit















13.







Inatransaction,COMMITspecifiesthat















(a)allupdates(includinginserts,deletes,modifications)ofatransactionareabouttobemadepermanentinthedatabase(b)allupdates(includinginserts,deletes,modifications)ofatransactionaretobemadepermanentinthedatabase(c)onlytheinsertsanddeletesofatransactionaretobemadepermanentinthedatabase(d)onlytheinsertsanddeletesofatransactionareabouttobemadepermanentinthedatabase















14.







Whichofthefollowingistrueaboutthephysicalstorageoftablesdefinedbyviews?















(a)Extraphysicalstorageisneededforstoringthetablesdefinedbyviews,onlyifviewsdefineadditionalnon-existingcolumns.(b)Thereisnoextraphysicalstorageneededtostoretablesthataviewdefines.(c)Extraphysicalstorageisalwaysneededtostoretablesthataviewdefines.(d)Extraphysicalstorageisneededtostoretablesthataviewdefines,onlywhenrowsareinsertedintotheview.















15.







WhichofthefollowingSQLcommandscanbeusedtochange,add,ordropcolumndefinitionsfromatable?















(a)MODIFYTABLE(b)UPDATETABLE(c)CHANGETABLE(d)ALTERTABLE















16.







WhichofthefollowingSQLcommandscanbeusedtodestroyandremoveatablefromtheschema?















(a)DROPTABLE(b)DESTROYTABLE(c)REMOVETABLE(d)DELETETABLE















17.







InSQL,whichofthefollowingoperatorsareusedtocheckforsetmembershipinaSELECTstatement?















(a)MEMBERandNOTMEMBER(b)INandNOTIN(c)SUBSETandNOTSUBSET(d)COMPONENTandNOTCOMPONENT















18.







InSQL,theresultsofa_____statementcanbeusedtoprocessa_____statement.















(a)INSERT,SELECT(b)SELECT,INSERT(c)INSERT,DELETE(d)DELETE,INSERT















19.







Inatransaction,aROLLBACKisusedto















(a)rollalltheupdates(includinginserts,deletes,modifications)ofanabortedtransactionintothedatabase(b)rollonlytheinsertsanddeletesofanabortedtransactionintothedatabase(c)discardalltheupdates(includinginserts,deletes,modifications)ofatransactionfromthedatabase(d)discardonlytheinsertsandupdatesofatransactionfromthedatabase















20.







WhenastringwhoselengthisstrictlylessthannisenteredasthevalueofafieldwhoseSQLdatatypeisCHAR(n),thesystemrespondsby















(a)paddingtheendofthestringwithspacestolengthnbeforestoringit(b)paddingtheendofthestringwithNULLcharacterstolengthnbeforestoringit(c)re-promptingfortheentryofastringwhoselengthisexactlyn(d)storingthestringasis

微软对CLR作了大篇幅的宣传，这是因为数据库产品终于融入.net体系中。最开始我们也是狂喜，感觉对象数据库的一些概念可以实现了。

然后最好有实践机会，能够把实践到的和实践结合起来，其实理论思考是个非常困扰和痛苦的事情

是否碎片会引发效率问题？这都是需要进一步探讨的东西。varbinary(max)代替image也让SQLServer的字段类型更加简洁统一。

SP4是一个累积性的ServicePack，包含自以前的ServicePack发布以来所有的修补程序（包括MS03-031安全公告）。

如果我们从集合论（关系代数）的角度来看，一张数据库的表就是一组数据元的关系，而每个SQL语句会改变一种或数种关系，从而产生出新的数据元的关系（即产生新的表）。

如果，某一版本可以提供强大的并发响应，但是没有Oracle的相应版本稳定，或者价格较贵，那么，它就是不适合的。

SP4包括用于以下SQLServer2000组件的程序包：Database组件（下载文件：SQL2000-KB884525-SP4-x86.EXE）更新SQLServer2000的32位Database组件，包括数据库引擎、复制、客户端连接组件及工具。有关其他信息，请参阅ReadmeSql2k32Sp4.htm。AnalysisServices组件（下载文件：SQL2000.AS-KB884525-SP4-x86.EXE）更新SQLServer2000的32位AnalysisServices。

换言之，只有在不断的失败中尝试成功，而关于失败的总结却是很少的