DB2302认证考题真题及参考答案 全.docx
《DB2302认证考题真题及参考答案 全.docx》由会员分享,可在线阅读,更多相关《DB2302认证考题真题及参考答案 全.docx(42页珍藏版)》请在冰豆网上搜索。
DB2302认证考题真题及参考答案全
1.Whichofthefollowingoptionsbestdescribesadomainfoundinthetablebelow?
从下表中,哪一选项正确的描述了domain
CREATETABLEEMPLOYEE(
IDINTEGERNOTNULL,
NAMEVARCHAR(30)NOTNULL,
EXTENSIONINTEGERNOTNULL,
MANAGERVARCHAR(30)NOTNULL
PRIMARYKEY(ID));
TERMINATE;
IDNAMEEXTENSIONMANAGER
1JohnS53412Y
2SusanP54123N
3JenniferL51234N
A.ManagerDomain=(N)
B.NameDomain=(SetofallPossibleNames)
C.ExtensionDoman=(53412)
D.IDDomain=(1,2,3)
答案:
B
2.WhichofthefollowingstatementsbestdescribestheXMLRegionsIndexinDB2?
下列哪个陈述最好的描述了DB2中的XML区域索引?
A.TheRegionsIndexisadescriptorforreferencinglargeobjectsintheLOBstoragearea.
B.TheRegionsIndexisanewtypeofXMLindexavailableinDB29.7.
C.TheRegionsIndexfacilitatesaccesstodocumentregionsintheXMLdataarea.
区域索引,有助于文档区域中的XML数据区的访问
D.TheRegionsIndexcanbecompressedbyissuinganofflinereorgoperationonthetable.
答案:
C
3.WhatisthepurposeofaDB2AccessPlan?
什么是一个DB2访问计划的目的?
A.SQLdeveloperscandefineAccessPlanstotellDB2thebestwaytoretrievethedatafromaSQLquery
B.DescribestheorderofoperationstoaccessdatanecessarytoexecuteaSQLorXQuerystatement描述运算次序,访问必要的数据去执行SQL或者XQuery的语句
C.ToreplicatedatabetweenaDB2databaseandrelationaldatabasesfromothervendors
D.TovisuallyconstructcomplexDMLstatementsandexaminetheresultsoftheirexecution
答案:
B
4.GiventhefollowingUPDATEstatement:
UPDATEemployeesSETworkdept=
(SELECTdeptnoFROMdepartmentWHEREdeptno='A01')
WHEREworkdeptISNULL
Whichofthefollowingdescribestheresultifthisstatementisexecuted?
如果上面的语句被执行,下面哪一个选项是正确的?
A.ThestatementwillfailbecauseanUPDATEstatementcannotcontainasubquery
B.Thestatementwillonlysucceedifthedataretrievedbythesubquerydoesnotcontainmultiplerecords语句可能成功如果数据恢复在子查询不能容纳过多的记录那之前
C.Thestatementwillsucceed;ifthedataretrievedbythesubquerycontainsmultiplerecords,onlythefirstrecordwillbeusedtoperformtheupdate
D.ThestatementwillonlysucceedifeveryrecordintheEMPLOYEEStablehasanullvalueintheWORKDEPTcolumn
答案:
B
5.Giventhefollowingtwotables:
NAMES
---------------------------
NAMENUMBER
-----------------
WayneGretzky99
JaromirJagr68
BobbyOrr4
BobbyHull23
MarioLemieux66
POINTS
----------------------------
NAMEPOINTS
-----------------
WayneGretzky244
BobbyOrr129
BrettHull121
MarioLemieux189
JoeSakic94
Howmanyrowswouldbereturnedusingthefollowingstatement?
在下面这个语句中有多少行会被返回?
SELECT*FROMnames,points
A.0
B.5
C.10
D.25
答案:
D
6.WhatisSQL/XML?
什么是SQL/XML?
A.SQL/XMLisacommunicationprotocolforDB2databases.
B.A.SQL/XMLispartoftheXQuerystandardandprovidesvariouspublishingfunctionstotransformXMLdataintorelationalformandviceversa.
C.SQL/XMLisalanguagethatprovidesvariouspublishingfunctionstotransformXMLdataintorelationalformandviceversa.
D.SQL/XMLisanextensiontoSQLstandardandprovidesvariouspublishingfunctionstotransformXMLdataintorelationalformandviceversa.
SQL/XML是延伸SQL标准和提供各种功能来转换XML数据相关性,反之亦然
答案:
D
7.WhichofthefollowingisNOTpartoftheXQueryFLOWRexpression?
下面那个选项不是部分XQueryFLOWR的表述?
A.FORclause
B.LETclause
C.ORDERBYclause
D.WITHclause
答案:
D
8.Giventhefollowingtable:
根据下面的表:
TAB1
-------------------
COL1COL2
----------
A10
B20
C30
A10
D40
C30
Assumingthefollowingresultsaredesired:
假设需要以下结果:
TAB1
-------------------
COL1COL2
----------
A10
B20
C30
D40
Whichofthefollowingstatementswillproducethedesiredresults?
下面的语句将产生预期的效果吗?
A.SELECTUNIQUE*FROMtab1
B.SELECTDISTINCT*FROMtab1
C.SELECTUNIQUE(*)FROMtab1
D.SELECTDISTINCT(*)FROMtab1
答案:
B
9.ConsideringtheSQLstatementbelow,whichoptionbestdescribeswhatAPP.TAXis:
考虑下面的SQL语句,最能说明APP.TAX的选项是:
SELECTAPP.TAX(SALARY)FROMEMPLOYEE
A.UserDefinedFunction自定义函数
B.StoredProcedure
C.Trigger
D.UserDefinedType
答案:
A
10.WhichofthefollowingisNOTtrueabouttheInformationModel?
以下不正确的信息模型是?
A.Abstractmanagementofobjectsataconceptuallevel.
B.Definesrelationshipsbetweenmanagedobjects.
C.Groupofdescriptionsexplainingobjectsofadatamodel.
组的描述信息说明的数据模型对象。
D.DatamodelscanbeusedtomapanInformationModeltoasoftwareimplementation.
答案:
C
11.ConsiderthefollowingXMLdocument:
考虑下面的XML文档:
JohnSmith
Fourth
Calgary
Alberta
M1T2A9
963-289-4136
ConsiderthefollowingUPDATEexpression:
updatexmlcustomer
setinfo=xmlquery('transform
copy$new:
=$i
modify(
doinsert777-555-3333after$new/customerinfo/addr,
for$jin$new/customerinfo/addr/phone
returndorename$jas"telephone"
)
return$new'passinginfoas"i")
wherecid=1000;
WhichofthefollowingrepresentstheXMLdocumentaftertheTRANSFORMexpressionhasbeenexecuted:
下列哪个代表了XML在文档转换表达式之前已经被执行:
A.JohnSmith
Fourth
Calgary
Alberta
M1T2A9
777-555-3333
963-289-4136
B.JohnSmith
Fourth
Calgary
Alberta
M1T2A9
777-555-3333
963-289-4136
C.JohnSmith
Fourth
Calgary
Alberta
M1T2A9
777-555-3333
963-289-4136
D.JohnSmith
Fourth
Calgary
Alberta
M1T2A9
777-555-3333
963-289-4136
答案:
A
12.Whichofthefollowingpropertiesisrelatedtothefactthatacommittedtransactionguaranteesthatalloftheoperationsarecompletedandinarollbackedtransactiontheeffectofalloperationsarereverted?
下列哪个属性是关系到一个提交的事务保证所有的操作都完成了,在一个事务回滚的影响的操作都是恢复?
A.Consistency
B.Atomicity原子性
C.Isolation
D.Durability
答案:
B
13.WhichofthefollowingisthelowestcostDB2productthatcanbelegallyinstalledonawindowsserverthathas4CPUscapableofperformingrowcompression?
下列哪项是的成本最低的,DB2产品可以合法地安装在有四个CPU的Windows服务器上能够执行压缩?
A.DB2ExpressEdition
B.DB2WorkgroupEdition
C.DB2Express-CEdition
D.DB2EnterpriseEdition
答案:
A
14.ApplicationBwantstoreadasubsetofrowsfromtableEMPLOYEEmultipletimesinsidethesametransaction.
Whichisolationlevelshouldbeusedinordertoguaranteethateverytimethesamesetofrowsisreturned?
应用程序B想多次读取表EMPLOYEE其中的一个子集中的几行数据。
应该使用隔离级别,以保证每次返回的结果都是一样的?
A.CurrentlyCommitted
B.ReadStability
C.RepeatableRead可重复读
D.UncommittedRead
答案:
C
15.HowdoesautomaticstorageworkinDB2?
在DB2中如何进行自动存储工作?
A.Automaticstoragesimplifiesstoragemanagementbyallowingyoutospecifystoragepathswherethedatabasemanagercanplacetablespacedata,andwherethedatabasemanagerallocatesspaceforvarioususes.
在允许指定存储路径中自动存储简化了存储管理,数据库管理器可以放置表空间数据同时数据库管理器为各种用途分配空间。
B.AutomaticstorageisanoptionwhichissetwhenyoucreateaDB2database.Itallowstransactionsthatarewrittentothedatabasetobeautomaticallycommitted.
C.AutomaticstorageisafunctionofDB2thatallowstablestobebackedupautomaticallyonasetschedule.
D.AutomaticStoragecanbeusedtoautomaticallyreorganizethedataonthephysicalmediainordertoimproveperformance.
答案:
A
16.WhichofthefollowingDB2client/driverpackagesisNOTsuitablefordevelopingODBCapplications?
下列哪个DB2客户机/驱动程序包是不适合开发ODBC应用程序?
A.IBMDataServerClient
B.IBMDataServerDriverforODBCandCLI
C.IBMDataServerRuntimeClientIBM数据服务器运行时客户端
D.IBMDataServerDriverPackage
答案:
C
17.InembeddedSQLcode,whichofthefollowingistrueaboutdelimiters?
在嵌入式SQL代码,关于分隔符哪项是正确的?
A.UsedbytheOStodelimitsystemvariabledeclaration.
B.Usedbythedatabasetoindicatetheendofacolumn.
C.Usedbycompilertoindicatetheendoftheprogram.
D.UsedbyPRECOMPILERtoidentifySQLstatementstobetranslated.
使用预编译程序来识别被翻译的SQL语句
答案:
D
18.WhatisaTrustedContext?
什么是受信任上下文?
A.Itisaspecialareainabufferpoolthatcanbewrittenonlybyaselectedsetofusers.
B.ItisaDB2capabilitythatallowsapplicationstochangeuserswithoutbreakingtheconnectiontothedatabase.
这是一个DB2功能,允许应用程序改变用户在没有打破了到数据库的连接。
C.ItisaDB2capabilitythatallowsuserstoestablishaconnectiontothedatabasewithoutprovidingusernameorpassword.
D.ItisatypeofcontainerinatablespacethatallowsfasterI/Ooperations.
答案:
B
19.Giventheoptionsbelow,whichofthefollowingstatementscanaddrecordstoatable?
在下面的选项中,哪个语句可以将记录添加到表中?
A.ADDREC
B.ADDRECORD
C.INSERT
D.ADD
答案:
C
20.YouwereassignedthetaskofimportingalargeamountofdataintoaDB2database.Consideringyoumusthaveloggedinformationabouttherowsimportedandthatyouwanttoperformtheloadasfastaspossible,whichofthetoolswouldyoubethebestchoiceforthejob?
你被分配的任务