3023new带答案.docx
- 文档编号:29639778
- 上传时间:2023-07-25
- 格式:DOCX
- 页数:20
- 大小:22.05KB
3023new带答案.docx
《3023new带答案.docx》由会员分享,可在线阅读,更多相关《3023new带答案.docx(20页珍藏版)》请在冰豆网上搜索。
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')
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'))))
A. //"Gender="MALE"> B. //"> C. 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); 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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 3023 new 答案
![提示](https://static.bdocx.com/images/bang_tan.gif)