仓酷云

标题: MSSQL编程：明天考数据库,这是标题和我的谜底! [打印本页]

作者: 分手快乐 时间: 2015-1-16 22:42
标题: 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

作者: 变相怪杰 时间: 2015-1-19 21:33
微软对CLR作了大篇幅的宣传，这是因为数据库产品终于融入.net体系中。最开始我们也是狂喜，感觉对象数据库的一些概念可以实现了。

作者: 海妖 时间: 2015-1-25 08:43
然后最好有实践机会，能够把实践到的和实践结合起来，其实理论思考是个非常困扰和痛苦的事情

作者: 老尸 时间: 2015-2-2 17:23
是否碎片会引发效率问题？这都是需要进一步探讨的东西。varbinary(max)代替image也让SQLServer的字段类型更加简洁统一。

作者: 只想知道 时间: 2015-2-8 02:51
SP4是一个累积性的ServicePack，包含自以前的ServicePack发布以来所有的修补程序（包括MS03-031安全公告）。

作者: 乐观 时间: 2015-2-24 03:05
如果我们从集合论（关系代数）的角度来看，一张数据库的表就是一组数据元的关系，而每个SQL语句会改变一种或数种关系，从而产生出新的数据元的关系（即产生新的表）。

作者: 金色的骷髅 时间: 2015-3-7 10:38
如果，某一版本可以提供强大的并发响应，但是没有Oracle的相应版本稳定，或者价格较贵，那么，它就是不适合的。

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

作者: 飘灵儿 时间: 2015-3-21 15:39
换言之，只有在不断的失败中尝试成功，而关于失败的总结却是很少的

欢迎光临仓酷云 (http://ckuyun.com/)