db2 730认证2Word格式文档下载.docx

db2 730认证2Word格式文档下载.docx

《db2 730认证2Word格式文档下载.docx》由会员分享，可在线阅读，更多相关《db2 730认证2Word格式文档下载.docx（27页珍藏版）》请在冰豆网上搜索。

B.CREATETABLEproduct（pidVARCHAR（10）NOTNULLPRIMARYKEY,nameVARCHAR（128）,priceDECIMAL（30,2）,promopriceDECIMAL（30,2）,promostartDATE,promoendDATE,descriptionXML）;

C.CREATETABLEproduct（pidXMLNOTNULLPRIMARYKEY,nameVARCHAR（128）,priceDECIMAL（30,2）,promopriceDECIMAL（30,2）,promostartDATE,promoendDATE,descriptionVARCHAR（1000）;

D.CREATETABLEproduct（pidVARCHAR（10）NOTNULLPRIMARYKEY,nameVARCHAR（128）,priceDECIMAL（30,2）,promopriceDECIMAL（30,2）,promostartDATE,promoendDATE,descriptionVARCHAR（1000）;

WhichofthefollowingDB2productsarerequiredonaniSeriesorSystemiservertoenableanapplicationrunningonthatservertoretrievedatafromaDB2databaseonaLinuxserver?

A.DB2fori5/OSB.DB2RuntimeClientC.DB2ConnectEnterpriseEditionD.DB2fori5/OSSQLDevelopmentKitTheEMPLOYEEtablecontainsthefollowinginformation:

EMPNONAMEWORKDEPT-101SAMA11102JOHNC12103JANE-104PATRemote105ANNE-106BOBA11TheMANAGERtablecontainsthefollowinginformation:

MGRIDNAMEDEPTNOEMPCOUNT-1WUB01-2JONESA11-3CHEN-4SMITH-5THOMASC12-Afterthisstatementisexecuted:

UPDATEmanagermSETempcount=（SELECTCOUNT（workdept）FROMemployeeeWHEREworkdept=m.deptno）Whatistheresultofthefollowingquery?

SELECTmgrid,empcountFROMMANAGERWHEREempcountISNOTNULLORDERBYmgridA.MGRIDEMPCOUNT-102251B.MGRIDEMPCOUNT-1022304051C.MGRIDEMPCOUNT-1323334353D.MGRIDEMPCOUNT-1022324251Towhichofthefollowingresourcescanalockbeapplied?

A.RowB.AliasC.BitmapD.ColumnWhichofthefollowingbestdescribesthelockprotectionprovidedbyDB2forthecurrentrowofacursor?

A.Thecursorisonlyprotectedfromupdatesanddeletesbyconcurrentapplications.B.Therowisonlyprotectedfrompositionedupdatesanddeletesthatreferenceanothercursorofthesameapplication.C.Thecursorisprotectedfrompositionedupdatesanddeletesthatreferenceanothercursorofadifferentapplication.D.Therowisprotectedfromupdatesanddeletesbythecurrentapplicationandfrompositionedupdatesanddeletesthatreferenceanothercursorofthesameapplication.WhichofthefollowingSQLstatementswillreturntheyearandaveragesalaryforallemployeeshiredwithinagivenyearthathaveasalarygreaterthan$30,000?

A.SELECThyear,AVG（salary）FROM（SELECTYEAR（hiredate）AShyear,salaryFROMemployee）newgrpHAVINGsalary30000GROUPBYhyearB.SELECThyear,AVG（salary）FROM（SELECTYEAR（hiredate）AShyear,salaryFROMemployeeWHEREsalary30000）newgrpGROUPBYhyearC.SELECThyear,AVG（salary）FROM（SELECTYEAR（hiredate）AShyear,salaryFROMemployeeWHEREsalary30000）newgrpGROUPBYYEAR（hiredate）D.SELECThyear,AVG（salary）FROM（SELECTYEAR（hiredate）AShyear,salaryFROMemployeeHAVINGsalary30000）newgrpGROUPBYYEAR（hiredate）WhichofthefollowingresourcescanbereferencedintheLOCKstatement?

Locktablenameinshare/exclusivemodeA.RowB.TableC.ColumnD.TablespaceWhichofthefollowingwillbeginanewunitofwork?

A.TheCONNECTstatementB.ThefirstFETCHofacursorC.TheBEGINTRANSACTIONstatementD.ThefirstexecutableSQLstatementWhichofthefollowingdescribestheobjectsofaDB2databaseandtheirrelationships?

A.InstanceB.TablespaceC.SystemcatalogD.SchemarepositoryADRDAhostdatabaseresidesonaz/OSorani5/OSsystemandlistensonport446.TheTCP/IPaddressforthissystemis192.168.10.1andtheTCP/IPhostnameismyhost.WhichofthefollowingcommandsisrequiredtoupdatethelocalnodedirectorysothataDB2clientcanaccessthisDRDAdatabase?

A.CATALOGTCPIPNODEmyhostREMOTEdb2srvSERVER446B.CATALOGTCPIPNODEmydb2srvREMOTEmyhostSERVER446C.CATALOGTCPIPNODEmyhostREMOTEdb2srvSERVER192.168.10.1D.CATALOGTCPIPNODEmydb2srvREMOTEmyhostSERVER192.168.10.1WhichofthefollowingtoolsforDB2V9allowsausertocreateanddebugaSQLstoredprocedure?

A.ControlCenterB.DevelopmentCenterC.DeveloperWorkbenchD.StoredProcedureBuilderAuserutilizinganaliastoupdateasubsetofcolumnsinatablemusthaveUPDATEprivilegesonwhichofthefollowingDB2objects?

A.TableB.ColumnsC.TableandAliasD.ColumnsandAliasGiventhefollowingtwotables:

TAB2CXCY__A21C22D23TAB1C1C2__A11B12C13Thefollowingresultsaredesired:

C1C2CXCY____A11A21C13C22-D23Whichofthefollowingquerieswillyieldthedesiredresults?

A.SELECT*FROMtab1INNERJOINtab2ONc1=cxB.SELECT*FROMtab1LEFTOUTERJOINtab2ONc1=cxC.SELECT*FROMtab1FULLOUTERJOINtab2ONc1=cxD.SELECT*FROMtab1RIGHTOUTERJOINtab2ONc1=cxWhichofthefollowingdatabaseobjectscanbeusedtoraiseanerrorifatableisupdated?

A.PackageB.TriggerC.StoredProcedureD.InformationalConstraintWhichofthefollowingDB2toolsallowsausertoexecuteanSQLstatementandviewagraphicalrepresentationoftheaccessplan?

A.TaskCenterB.CommandEditorC.DeveloperWorkbenchD.CommandLineProcessorWhendefiningareferentialconstraintbetweentheparenttableT2andthedependenttableT1,whichofthefollowingistrue?

A.ThelistofcolumnnamesintheFOREIGNKEYclausecanbeasubsetofthelistofcolumnnamesintheprimarykeyofT2oraUNIQUEconstraintthatexistsonT2.B.ThelistofcolumnnamesintheFOREIGNKEYclausecanbeasubsetofthelistofcolumnnamesintheprimarykeyofT1oraUNIQUEconstraintthatexistsonT1.C.ThelistofcolumnnamesintheFOREIGNKEYclausemustbeidenticaltothelistofcolumnnamesintheprimarykeyofT2oraUNIQUEconstraintthatexistsonT2.D.ThelistofcolumnnamesintheFOREIGNKEYclausemustbeidenticaltothelistofcolumnnamesintheprimarykeyofT1oraUNIQUEconstraintthatexistsonT1.WhattypeofconstraintisusedtoensurethateachrowinsertedintotheEMPLOYEEtablewithavalueintheWORKDEPTcolumnhasarowwithacorrespondingvalueintheDEPTNOcolumnoftheDEPARTMENTtable?

A.AcheckconstraintontheEMPLOYEEtableB.AuniqueconstraintontheEMPLOYEEtableWORKDEPTcolumnC.AforeignkeyreferencefromtheDEPARTMENTtablesDEPTNOcolumntotheWORKDEPTcolumnoftheEMPLOYEEtableD.AforeignkeyreferencefromtheEMPLOYEEtablesWORKDEPTcolumntotheDEPTNOcolumnoftheDEPARTMENTtableOnwhichofthefollowingdatabaseobjectsmaytheSELECTprivilegebecontrolled?

A.SequenceB.SchemaC.GroupD.ViewHowmanynameswillbereturnedforthisXQuery?

CREATETABLEcustomer（cidBIGINTNOTNULLPRIMARYKEY,infoXML）INSERTINTOcustomer（cid,info）VALUES（1000,KathySmith5RosewoodOntarioCalifornia91764501-555-1358）INSERTINTOcustomer（cid,info）VALUES（1002,JimNoodle25EastCreekMarkhamOntarioN9C3T6905-555-7258）INSERTINTOcustomer（cid,info）VALUES（1003,RobertShoemaker1596BaselineAuroraOntarioN8X7F8905-555-2937）XQUERYdeclaredefaultelementnamespacehttp:

/posample.org;

for$dindb2-fn:

xmlcolumn（CUSTOMER.INFO）/customerinfowhere$d/addr/prov-state=Ontarioreturn$d/nameA.0B.1C.2D.3AuserneedstocreateatriggerthatwillupdatetableT2wheneverarowisaddedtotableT1.AssumingtheuserhasallappropriateprivilegesfortableT2,whichprivilegeisrequiredontableT1tocreatethetrigger?

A.REFERENCESB.SELECTC.UPDATED.ALTERWhichofthefollowingconstrainttypescanbeusedtoensurethevalueofanINTEGERcolumnreferencesonlypositivevalues?

A.UniqueB.CheckC.ReferentialD.InformationalWhichobjectmaybeusedduringqueryoptimizationtoimprovetheperformanceforasubsetofSELECTqueries?

A.MQT（实例化的查询表是根据查询结果定义的表）B.TriggerC.ReadOnlyCursorD.StoredProcedureGiventhefollowingtwotables:

TAB2R2-AABBCCDTAB1R1-AAABBCCDEWhichofthefollowingqueriesreturnsthefollowingresultset?

RETVAL-EA.SELECTr1ASretvalFROMtab1INTERSECTSELECTr2ASretvalFROMtab2B.SELECTr1ASretvalFROMtab1EXCEPTSELECTr2ASretvalFROMtab2C.SELECTDISTINCTr1ASretvalFROMtab1,tab2WHEREr1r2D.SELECTr1ASretvalFROMtab1UNIONSELECTr2ASretvalFROMtab2AnapplicationneedsatableforeachconnectionthattrackstheIDandNameofallitemspreviouslyorderedandcommittedwithintheconnection.Thetablealsoneedstobecleanedupandautomaticallyremovedeachtimeaconnectionisended.AssumingtheITEMStablewascreatedwiththefollowingSQLstatement:

CREATETABLEitems（item_noINT,item_nameCHAR（5）,item_qtyINT）WhichofthefollowingSQLstatementswillprovidethetabledefinitionthatmeetsthespecifiedrequirements?

A.DECLAREGLOBALTEMPORARYTABLEtrackerAS（SELECTitem_no,item_nameFROMitems）WITHNODATAONCOMMITPRESERVEROWSONDISCONNECTDROPTABLEB.DECLAREGLOBALTEMPORARYTABLEtrackerAS（SELECTitem_no,item_nameFROMitems）WITHNODATAONCOMMITPRESERVEROWS（全局临时表可以通过应用程序创建或使用，在应用程序终止时自动删除）C.CREATETABLEsystmp.trackerAS（SELECTitem_num,item_nameFROMitems）WITHNODATAONCOMMITPRESERVEROWSD.CREATETABLEtrackerAS（SELECTitem_num,item_nameFROMitems）ONCOMMITPRESERVEROWSONDISCONNECTDROPTABLEWhichofthefollowingscenarioswillensurethatthevalueoftheNEXT_STEPNOcolumninagivenrowoftableTABLEXexistsasavalueofcolumnSTEPNO（usuallyinanotherrow）inthesametable?

A.DefineaUNIQUEconstraintonthecolumnsNEXT_STEPNOandSTEPNO.B.DefineaCHECKconstraintontheNEXT_STEPNOcolumn（NEXT_STEPNO=STEPNO）.C.DefinecolumnSTEPNOastheprimarykeyofTABLEXandcolumnNEXT_STEPNOasaforei