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。 换言之，只有在不断的失败中尝试成功，而关于失败的总结却是很少的
页:
[1]