DB2考试题库3022Word格式.docx
- 文档编号:21605499
- 上传时间:2023-01-31
- 格式:DOCX
- 页数:18
- 大小:23.29KB
DB2考试题库3022Word格式.docx
《DB2考试题库3022Word格式.docx》由会员分享,可在线阅读,更多相关《DB2考试题库3022Word格式.docx(18页珍藏版)》请在冰豆网上搜索。
D.DROPFROMsalesWHEREYEAR(sales_date)=1995
3.WhichofthefollowingisthelowestcostDB2productthatcanbelegallyinstalledonawindowsserverthathas4CPUscapableofperformingrowcompression?
A
A.DB2ExpressEdition
B.DB2WorkgroupEdition
C.DB2Express-CEdition
D.DB2EnterpriseEdition
4.WhenusingaRelationalDatabase,whichofthefollowingdoesNOTapply?
C
A.AccessesdatausingDataManipulationLanguage(DML)suchasSQL.
B.DefineyourdatabaseschemausingaDataDefinitionLanguage(DDL).
C.Dataisstoredinahierarchicalmodel.
D.Youcanusenormalizationtoavoidredundantdatainyourtables.
5.WhichofthefollowingisNOTtrueabouttheInformationModel?
D
A.Abstractmanagementofobjectsataconceptuallevel.
B.Definesrelationshipsbetweenmanagedobjects.
C.Groupofdescriptionsexplainingobjectsofadatamodel.
D.DatamodelscanbeusedtomapanInformationModeltoasoftwareimplementation.
5.Whatisauthorization?
A.Authorizationisaprocessthatcheckswhetheryouhavesufficientprivilegestoperformthedesireddatabaseoperation.
B.AuthorizationistheprocesswheretheDBAgathersinformationtoseewhowillhaveaccesstothedatabase.
C.AuthorizationistheprocesswheretheDB2databasecheckswithWindowssecuritytoseeifyouhaveaccesstotheDB2database.
D.AuthorizationisaprocessthatvalidatesthatyouarewhoyouclaimtobebyverifyingyouruserIDandpassword.
6.WhichofthefollowingisFALSEaboutviews?
A.Donotcontainrealdata
B.Anyviewcanbeupdated,independentofitsdefinition
C.Whenchangesaremadetodatathroughaview,thedataischangedintheunderlyingtable
D.Canbeusedinterchangeablywithtableswhenretrievingdata
7.WhataretheentitiesusedtomodeldataintheRelationalModel?
A.Acollectionofinstancesofentities.
B.Relations,attributesandtuples
C.Acollectionofinstancesofrecordtypes.
D.Table,rowsandcolumns
8.Whichofthefollowingisatooltoconfigureautomaticdatabasebackup?
A.ConfigureAutomaticMaintenancewizard
B.DesignAdvisor
C.Explaintool
D.EXPORTutility
10.Whichofthefollowingisawell-formedXMLdocument?
A.<
Namexmlns="
htpp:
//"
Gender="
MALE"
>
<
FirstName>
Amitabh<
/FirstName>
LastName>
Patel<
/LastName>
/Name>
B.<
"
MALE="
Gender"
/name>
C.<
Name
Gender="
Amitabh<
D.<
Gender=FEMALE>
没有引号
<
Jaya<
11.Whenauserisconnectedtoadatabase,whichofthefollowingprivilegesisrequiredfortheusertouseapackage?
A.BIND
B.BINDADD
C.EXECUTE
D.USE
12.Whichofthefollowingpropertiesisrelatedtothefactthatacommittedtransactionguaranteesthatalloftheoperationsarecompletedandinarollbackedtransactiontheeffectofalloperationsarereverted?
A.Consistency
B.Atomicity
C.Isolation
D.Durability
13.HowdoesautomaticstorageworkinDB2?
A.Automaticstoragesimplifiesstoragemanagementbyallowingyoutospecifystoragepathswherethedatabasemanagercanplacetablespacedata,andwherethedatabasemanagerallocatesspaceforvarioususes.
B.AutomaticstorageisanoptionwhichissetwhenyoucreateaDB2database.Itallowstransactionsthatarewrittentothedatabasetobeautomaticallycommitted.
C.AutomaticstorageisafunctionofDB2thatallowstablestobebackedupautomaticallyonasetschedule.
D.AutomaticStoragecanbeusedtoautomaticallyreorganizethedataonthephysicalmediainordertoimproveperformance.
14.ApplicationBwantstoreadasubsetofrowsfromtableEMPLOYEEmultipletimesinsidethesametransaction.B
A.CurrentlyCommitted
B.ReadStability
C.RepeatableRead
D.UncommittedRead
15.Whichofthefollowingistrueaboutawell-formedXMLdocument?
A.Hasoneormorerootnodes
B.Tagscanhaveatmostoneattribute.
C.Alwayshasasingledocumentnode.
D.Endtagsareoptional.
16.WhichDataModelwascreatedwiththefocusofprovidingbetterdataindependence?
A.Relational
B.Hierarchical
C.Semantic
D.Network
17.WhichofthefollowingisNOTasupportedtypeoftrigger?
A.AFTER
B.BEFORE
C.DURING
D.INSTEADOF
18.WhichofthefollowingstatementsisFALSEabouttransactions?
A.Operationsinsideatransactionareexecutedinparallel.
B.Only1COMMITstatementcanbeexecutedinsidethesametransaction.
C.Transactionsguaranteeatomicityofagroupofoperations.
D.AROLLBACKorCOMMITstatementfinalizesatransaction.
19.AfterthefollowingSQLstatementisexecuted:
GRANTALLPRIVILEGESONTABLEstudentTOUSERuser1
AssuminguserUSER1hasnootherauthoritiesorprivileges,whichofthefollowingactionsisUSER1allowedtoperform?
A.GrantallprivilegesontableSTUDENTtootherusers.
B.DropaviewassociatedtothetableSTUDEN.
C.DropthetableSTUDENT.
D.Noneoftheabove.
20.ADirtyReadoccurswhen?
A.Atransactionreadthesamerowofdatatwiceandreturnsdifferentdatavalueswitheachread.
B.Asearchbasedonsomecriterionreturnsadditionalrowsafterconsecutivesearchesduringatransaction.
C.Uncommitteddataisreturned,butthetransactionthatoriginatedthemwasrolledback.
D.Twotransactionsreadandthenattempttoupdatethesamedata,thesecondupdatewilloverwritethefirstupdatebeforeitiscommitted.
21.Giventhefollowingtwotables:
TAB1
COL_1
COL_2
-----
-----
A
10
B
12
C
14
TAB2
COL_A
COL_B
21
23
D
25
Assumingthefollowingresultsaredesired:
COL_2
A
10
A
B
12
-
-
C
14
C
-
-
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
22.Whichofthefollowingistrueaboutcolumns?
A.Eachcolumnconsistsofoneormorerecords
B.Columnsarewheretheindividualpiecesofinformationarestoredforeachrecord
C.Columnsmustbedesignatedaspecificdatatype
D.Columnsarealsoknownasrecords
23.Giventheoptionsbelow,whichofthefollowingstatementscanaddrecordstoatable?
A.ADDREC
B.ADDRECORD
C.INSERT
D.ADD
24.IfTAB1iscreatedusingthefollowingstatement
CREATETABLEtab1(
col1INTEGERNOTNULL,
col2CHAR(3),
CONSTRAINTcst1CHECK(col1in(1,2,3,4)))
WhichofthefollowingstatementswillsuccessfullyinsertarecordintotableTAB1?
A.INSERTINTOtab1VALUES(0,'
a'
)
B.INSERTINTOtab1VALUES(NULL,'
abc'
C.INSERTINTOtab1VALUES(4,'
D.INSERTINTOtab1VALUES(4,'
abcdefhijklmnopq'
25.GiventhefollowingUPDATEstatement:
UPDATEemployeesSETworkdept=
(SELECTdeptnoFROMdepartmentWHEREdeptno='
A01'
WHEREworkdeptISNULL
Whichofthefollowingdescribestheresultifthisstatementisexecuted?
A.ThestatementwillfailbecauseanUPDATEstatementcannotcontainasubquery
B.Thestatementwillonlysucceedifthedataretrievedbythesubquerydoesnotcontainmultiplerecords
C.Thestatementwillsucceed;
ifthedataretrievedbythesubquerycontainsmultiplerecords,onlythefirstrecordwillbeusedtoperformtheupdate
D.ThestatementwillonlysucceedifeveryrecordintheEMPLOYEEStablehasanullvalueintheWORKDEPTcolumn
26.Acompanyhasalargeamountofdatatostoreandwantstobeabletodothefollowingwiththedata:
Haveastandardinterfaceforaccessingthedata.
Havemultipleuserswiththeabilitytoinsert,updateanddeletedata.
Makechangestothedatawithoutriskoflosingdataanditsconsistency.
Havethecapabilitytohandlehugevolumesofdataandusers.
Havetoolsfordatabackup,restoreandrecovery.
Whatdatastoragemethodisthemostoptimalsolutionforthecompany?
A.Textfiles
B.Commadelimiteddatafiles
C.Spreadsheets
D.Database
27.Considerthefollowingscenario.Youhave3tableswiththesamename(TABLE_1)under3differentschemas(SYSIBM,DEFAULTandDB2INST1).YouareconnectedtoaDB2databaseinyourLinuxserverasdb2inst1andissuethefollowingstatement:
SELECT*FROMtable_1
Whichtablewillyoubeselectingdatafrom:
A.Yougetanerrorbecauseyourqueryisambiguous,asthetableschemaisnotspecified
B.SYSIBM.table_1
C.DEFAULT.table_1
D.DB2INST1.table_1
28.WhichofthefollowingstatementsgrantsuserJohntheabilitytoinsertdatatotabletab1?
A.GRANTADDONTABLEtab1TOJohn
B.GRANTINSERTONTABLEtab1TOJohn
C.
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- DB2 考试 题库 3022