3023new带答案.docx

资源描述

3023new带答案.docx

《3023new带答案.docx》由会员分享，可在线阅读，更多相关《3023new带答案.docx（20页珍藏版）》请在冰豆网上搜索。

3023new带答案.docx

3023new带答案

IBMDB2302_3

1.WhichofthefollowingistrueaboutTableSpacesinDB2?

A.ATableSpaceisafilemanagedbytheoperatingsystemwhereDB2canstoredata.

B.ATableSpaceisalwaysassociatedwithabufferpool.

C.ATableSpacetostoreuser'stemporarytabledataisautomaticallycreatedwhenadatabaseiscreated.

D.ATableSpacecanbemanagedbythedatabase（DB2）orbyanexternalapplication.

2.ConsideringtheSQLstatementbelow,whichoptionbestdescribeswhatABSis:

UPDATEtb1SETcol1=ABS（col2）

A.StoredProcedure

B.Built-infunction

C.Trigger

D.UserDefinedType

3.Giventhefollowingtwotables:

TAB1

------------------

COL_1 COL_2

----- -----

A 10

B 12

C 14

TAB2

------------------

COL_A COL_B

----- -----

A 21

C 23

D 25

Assumingthefollowingresultsaredesired:

COL_1 COL_2 COL_A COL_B

A 10 A 21

B 12 - -

C 14 C 23

Whichofthefollowingjoinswillproducethedesiredresults?

A.SELECT*FROMtab1INNERJOINtab2ONcol_1=col_a

B.SELECT*FROMtab1LEFTOUTERJOINtab2ONcol_1=col_a

C.SELECT*FROMtab1RIGHTOUTERJOINtab2ONcol_1=col_a

D.SELECT*FROMtab1FULLOUTERJOINtab2ONcol_1=col_a

4.WhichofthefollowingstatementsisFALSEabouttransactions?

A.Operationsinsideatransactionareexecutedinparallel.

B.Only1COMMITstatementcanbeexecutedinsidethesametransaction.

C.Transactionsguaranteeatomicityofagroupofoperations.

D.AROLLBACKorCOMMITstatementfinalizesatransaction.

5.WhichofthefollowingistrueabouttheInformationModel?

A.Allowsspecificationofobjectsinadetailedlevel.

B.Itcandescribeobjectsbutnottherelationshipsbetweenthem.

C.Itisagroupofdescriptionsexplainingobjectsofadatamodel.

D.DatamodelscanbeusedtomapanInformationModeltoasoftwareimplementation.

6.TheauthenticationmethodinaDB2serverisdefinedwithin:

A.Thedatabaseconfiguration.

B.Thesystem'scatalog.

C.TheDB2registry.

D.Thedatabasemanagerconfiguration.

7.Whichofthefollowingoptionsbestdescribesadomainfoundinthetablebelow?

CREATETABLEEMPLOYEE（

ID INTEGERNOTNULL,

NAME VARCHAR（30）NOTNULL,

EXTENSION INTEGERNOTNULL,

MANAGER VARCHAR（30） NOTNULL

PRIMARYKEY （ID））;

TERMINATE;

ID NAME EXTENSION MANAGER

1 JohnS 53412 Y

2 SusanP 54123 N

3 JenniferL 51234 N

A.ManagerDomain=（N）

B.NameDomain=（SetofallPossibleNames）

C.ExtensionDoman=（53412）

D.IDDomain=（1,2,3）

8.WhichofthefollowingistrueaboutRelationalDatabasesandtheRelationalDataModel?

A.Atabledoesnotallowduplicatesandarelationdoes.

B.Adomainisthesmallestunitofdata.

C.Acolumnistheequivalenttoatuple.

D.Adomainisthesetofsomepossiblevaluesforaspecificfield.

9.WhichofthefollowingisNOTtrueaboutRelationalDatabases?

A.Eachcolumncontainsaspecifictypeofinformation.

B.Columnsarewheretheindividualpiecesofinformationarestored.

C.Aprimarykeycanbecomposedofonlyoneattribute.

D.Foreignkeysareanattributeinonerelationwhosevaluesmatchaprimarykeyofanotherrelation.

10.ConsidertableTB1definedasbelow:

CREATETABLETB1（

C1INTEGERPRIMARYKEY,

C2VARCHAR（10））

ConsideringthefollowingstatementsaresuccessfullyexecutedinCLPwithauto-commitdisabled,howmanyrowsareINSERTEDintableTB1

INSERTINTOTB1VALUES（1,'John'）

COMMIT

INSERTINTOTB1VALUES（1,'John'）

ROLLBACK

A.0

B.1

C.2

D.3

11.WhencreatingaDB2database,whichofthefollowingtablespacesisNOTautomaticallycreated?

A.Usertablespace

B.Usertemporarytablespace

C.Catalogtablespace

D.Systemtemporarytablespace

12.WhichofthefollowingeventswillNOTcauseatriggertobeactivated?

A.DELETE

B.SELECT

C.INSERT

D.UPDATE

13.WhichofthefollowingXMLfragmentcorrectlyindicatestheresultofthegivenstatementbelow?

values（XMLELEMENT（name"Name",

XMLNAMESPACES（DEFAULT'htpp:

//'）,

XMLATTRIBUTES（'MALE'as"Gender"）,

XMLCONCAT（

XMLELEMENT（name"FirstName",'Amitabh'）,

XMLELEMENT（name"LastName",'Patel'））））

//"Gender="MALE">

Amitabh

Patel

//">

MALE

Amitabh

Patel

AmitabhPatel

D.Noneoftheabove

14.Giventhefollowingtabledefinition:

SALES

--------------------------

SALES_DATE DATE

SALES_PERSON CHAR（20）

REGION CHAR（20）

SALES INTEGER

WhichofthefollowingSQLstatementswillremoveallsalesthatoccurredin1995?

A.DELETE*FROMsalesWHEREYEAR（sales_date）=1995

B.DELETEFROMsalesWHEREYEAR（sales_date）=1995

C.REMOVE*FROMsalesWHEREYEAR（sales_date）=1995

D.REMOVEFROMsalesWHEREYEAR（sales_date）=1995

15.WhichofthefollowingisNOTtrue?

A.StructuredQueryLanguageisthestandardlanguageformanipulatingdatainaRelationalDatabaseManagementSystem.

B.DatabaseManagementSystemsactasaninterfaceusedtocommunicatewithdatabases.

C.TheHierarchicaldatamodelorganizesdataintableswithcolumnsandrows.

D.DB2isaDatabaseManagementSystem.

16.WhichofthefollowingischaracteristicdifferencebetweenCursorStabilityandCurrentlyCommitted?

A.ReaderblocksReader

B.ReaderblocksWriter

C.WriterblocksReader

D.WriterblocksWriter

17.Whichofthefollowingisa characteristic ofHighAvailability?

A.Itallowscompressionofdata.

B.Itallowsdefinitionofapolicytoguaranteequalityofservicetoapplications.

C.Itallowsreplicationofdatatoastandbyserverthatcantakeoverincaseoffailure

D.ItallowshighperformanceofaDB2serverbydistributingworkloadacrossseveralmachines.

18.WhichDataModelwascreatedwiththefocusofprovidingbetterdataindependence?

A.Semi-structured

B.Hierarchical

C.Relational

D.Entity-Relationship

19.Whichofthefollowingprivilegespermitsausertoupdatethecommentassociatedwithatable?

A.ALTER

B.CONTROL

C.CREATEIN

D.REFERENCES

20.WhichofthefollowingisNOTaFeaturePackthatcanaddextrafunctionalitytoaDB2server?

A.AdvancedAccessControl

B.StorageOptimization

C.PerformanceOptimization

D.pureXML

21.Considerthefollowingscenario.Wehaveatable,table_1,whichhasonlyonecolumnstoringanintegervalue.Thefollowingstatementsareexecutedsuccessfullyintheordershown:

CREATESEQUENCEmy_seqSTARTWITH1INCREMENTBY1CACHE5

INSERTINTOtable_1VALUES（NEXTVALUEFORmy_seq）;

Afteradb2terminateandreconnectiontothedatabase,thefollowingstatementwasissued:

INSERTINTOtable_1VALUES（NEXTVALUEFORmy_seq）;

SELECT*FROMtable_1

Whatvaluewillbethelastvaluereturnedbythequery?

A.1

B.2

C.3

D.6

22.Ifsecondarylogfilesaretobeallocateduntiltheunitofworkcommitsorstorageisexhausted,whichtypeofloggingisused?

A.Circularlogging

B.Archivallogging

C.Infinitelogging

D.ItcannotbedoneinDB2

23.Whendoesauthenticationtakesplace?

A.JustbeforeDB2executesaSQLstatementsentbyaclientapplication.

B.Whentheuserconnectstothedatabase.

C.Whentheuserdisconnectsfromadatabase.

D.ItispartofDB2serverstartupprocess

24.AssumingthatyouarecurrentlyconnectedtoaDB2database,whichofthefollowingcommandswillterminateyourconnection?

A.db2connectreset

B.db2connectend

C.db2connectkill

D.db2connectfinalize

25.Whichofthefollowingoptionscanbeusedtochecktheminimumpointintime（PIT）foratablespacerestore?

A.LISTTABLESPACESSHOWALL

B.RESTOREDATABASESAMPLETABLESPACE（MYTBSP）FROM/tbspbkp

C.RESTOREDATABASESAMPLETABLESPACE（MYTBSP）ONLINEFROM/tbspbkp

D.GETSNAPSHOTFORTABLESPACEON

26.Giventheoptionsbelow,whichofthefollowingstatementscanremoveatablefromadatabase?

A.REMOVE

B.DELETE

C.DEL

D.DROP

27.Yourcompanyhasaskedyoutocreateadatabasetostoreandorganizedataaboutthestructureofthecompany.Youwanttostorebranchandemployeedataaswellasdataontheproductsthateachemployeeinyourcompanydealswith.Inordertoreduceredundancy,howmanytablesshouldyoucreate?

ConsiderthatyourmodelshouldbetailoredtoreducethepossiblenumberofNULLvaluesinthetable（s）.

A.1

B.2

C.3

D.4

28.WhichofthefollowingstatementsrevokeaccesstoSAMPLEdatabasefromuserTOM?

A.REVOKECONNECTONsampleFROMUSERtom

B.REVOKEACCESSFROMUSERtomONDATABASE

C.REVOKEACCESSFROMUSERtomONsample

D.REVOKECONNECTONDATABASEFROMUSERtom

29.GiventhefollowingUPDATEstatement:

UPDATEemployeesSETworkdept=

（SELECTdeptnoFROMdepartment）

WHEREworkdept=NULL

Whichofthefollowingdescribestheresultifthisstatementisexecuted?

A.ThestatementwillfailbecauseanUPDATEstatementcannotcontainasubquery

B.ThestatementwillfailbecausetheWORKDEPTcolumnappearsintheSE

展开阅读全文