db2考试自测题2带答案选项文档格式.docx

db2考试自测题2带答案选项文档格式.docx

《db2考试自测题2带答案选项文档格式.docx》由会员分享，可在线阅读，更多相关《db2考试自测题2带答案选项文档格式.docx（21页珍藏版）》请在冰豆网上搜索。

A.Journal

B.SQLAssist

C.DB2AlertCenter

D.DB2CommandCenter

（3/55）WhichofthefollowingDB2CLPoptionsspecifythefilethatcontains

thestatementstobeexecuted?

A.-f

B.-b

C.-o

D.-w

（4/55）Whichofthefollowingwillrebuildapackageinthedatabasefromthe

existingcataloginformation?

A.bind

B.rebind

C.update

D.rebuild

（5/55）WhichtwoofthefollowingtypesofstoragemanagementmethodissupportedbyDB2

OLAPServer?

（Selectallthatapply）

A.Object

B.Network

C.Relational

D.Hierarchical

E.Multi-dimensional

（6/55）WhichofthefollowingDB2componentscanlimittheresourceconsumptionofqueries?

A.DB2Connect

B.DB2QueryPatroller

C.DB2PerformanceMonitor

D.DB2NetSearchExtender

（7/55）HowmanyDB2AdministrationServer（DAS）Instancescanbesetupperphysical

machine?

（Selectthecorrectresponse）

A.0

B.1

C.Oneforeachinstanceonthephysicalmachine

D.Oneforeachdatabaseonthephysicalmachine

（8/55）WhichofthefollowingmustbesetuptoallowtheControlCentertoview

databaseobjects?

A.ODBC

B.JAVA

C.DB2AdministrationServer

D.ClientConfigurationAssistant

（9/55）Whichofthefollowingprivilegesisnecessarytopopulatethetablewith

largeamountsofdata?

A.LOAD

B.ALTER

C.UPDATE

D.IMPORT

（10/55）AtablecalledEMPLOYEEhascolumns:

name,department,andphone_number.Which

ofthefollowingcanlimitaccesstothephone_numbercolumn?

A.Usingaviewtoaccessthetable

B.Usinganindexonthecolumn

C.Usingareferentialconstraintonthetable

D.Usingatablecheckconstraintonthetable

E.Revokingaccessfromthephone_numbercolumn

（11/55）Whichofthefollowingisthebestwaytorestrictuseraccesstoasubsetof

columnsinatable?

A.Onlygrantaccesstothecolumnswithinatablethatauserisallowedtosee.

B.Createaviewthatonlyincludesthecolumnsauserisallowedtosee.Grantthe

useraccesstotheview,notthebasetable.

C.Createtwotables:

onewiththecolumnsthatauserisallowedtosee,andonethat

hastheconfidentialcolumns,anduseajoinwhenalldatamustbepresented.

D.Createtwotables:

onewiththecolumnsthatauserisallowedtosee,andonethath

astheconfidentialcolumns,anduseaunionwhenalldatamustbepresented.

（12/55）Whichofthefollowingisthemostappropriatereasontoconsiderrevokingthe

SELECTprivilegeonthecatalogtablesfromPUBLICaftercreatingadatabase?

A.Topreventusersfromcreatingtableswithoutproperauthority.

B.Somesystemcatalogsrecorduserdatainsomecolumns,andthisdatamaybe

confidential.

C.TopreventusersfromviewingpasswordsforotherDB2useridsthatDB2storesin

thecatalogtables.

D.Somecatalogtablesarelarge,sopreventingusersfromviewingthemisagoodway

tokeepusersfromsubmittinglong-runningqueriesagainstthecatalogs.

（13/55）WhenmanuallyestablishingcommunicationsfromaWindowsNTclientthroughaDB2

ConnectgatewaytoDB2UDBforOS/390,whichofthefollowingisNOTrequiredtocatalog?

A.Theclient.

B.ThedatabaseontheDRDAserver.

C.TheDatabaseConnectionServicedatabase.

D.ThenodewheretheDB2ConnectGatewayis.

（14/55）Whichofthefollowingcanbeusedtodeterminetheviewsthatareaffected

byaDROPTABLEstatement?

A.DB2ScriptCenter

B.DB2PerformanceMonitor

C.DB2ControlCenter,ShowRelated

D.DB2ControlCenter,SampleContents

（15/55）UsingtheControlCenterCreateTabledialogbox,whichofthefollowingdialogs

allowsthetablecreationDDLtobeviewed?

A.Copy

B.ShowSQL

C.ShowRelated

D.SampleContents

（16/55）Giventhetabledefinition:

CREATETABLEstudent（nameCHAR（30）,ageINTEGER）

Tolistthenamesofthe10youngeststudents,whichofthefollowingindexdefinition

statementsonthestudenttablemayimprovethequeryperformance?

A.CREATEINDEXyoungestONstudent（age,name）

B.CREATEINDEXyoungestONstud