//"Gender="MALE">
Amitabh
Patel
B.
Amitabh
Patel
C.
AmitabhPatel
D.没有引号
Jaya
Patel
11.Whenauserisconnectedtoadatabase,whichofthefollowingprivilegesisrequiredfortheusertouseapackage?
C
A.BIND
B.BINDADD
C.EXECUTE
D.USE
12.Whichofthefollowingpropertiesisrelatedtothefactthatacommittedtransactionguaranteesthatalloftheoperationsarecompletedandinarollbackedtransactiontheeffectofalloperationsarereverted?
B
A.Consistency
B.Atomicity
C.Isolation
D.Durability
13.HowdoesautomaticstorageworkinDB2?
A
A.Automaticstoragesimplifiesstoragemanagementbyallowingyoutospecifystoragepathswherethedatabasemanagercanplacetablespacedata,andwherethedatabasemanagerallocatesspaceforvarioususes.
B.AutomaticstorageisanoptionwhichissetwhenyoucreateaDB2database.Itallowstransactionsthatarewrittentothedatabasetobeautomaticallycommitted.
C.AutomaticstorageisafunctionofDB2thatallowstablestobebackedupautomaticallyonasetschedule.
D.AutomaticStoragecanbeusedtoautomaticallyreorganizethedataonthephysicalmediainordertoimproveperformance.
14.ApplicationBwantstoreadasubsetofrowsfromtableEMPLOYEEmultipletimesinsidethesametransaction.B
A.CurrentlyCommitted
B.ReadStability
C.RepeatableRead
D.UncommittedRead
15.Whichofthefollowingistrueaboutawell-formedXMLdocument?
C
A.Hasoneormorerootnodes
B.Tagscanhaveatmostoneattribute.
C.Alwayshasasingledocumentnode.
D.Endtagsareoptional.
16.WhichDataModelwascreatedwiththefocusofprovidingbetterdataindependence?
A
A.Relational
B.Hierarchical
C.Semantic
D.Network
17.WhichofthefollowingisNOTasupportedtypeoftrigger?
C
A.AFTER
B.BEFORE
C.DURING
D.INSTEADOF
18.WhichofthefollowingstatementsisFALSEabouttransactions?
A
A.Operationsinsideatransactionareexecutedinparallel.
B.Only1COMMITstatementcanbeexecutedinsidethesametransaction.
C.Transactionsguaranteeatomicityofagroupofoperations.
D.AROLLBACKorCOMMITstatementfinalizesatransaction.
19.AfterthefollowingSQLstatementisexecuted:
GRANTALLPRIVILEGESONTABLEstudentTOUSERuser1
AssuminguserUSER1hasnootherauthoritiesorprivileges,whichofthefollowingactionsisUSER1allowedtoperform?
D
A.GrantallprivilegesontableSTUDENTtootherusers.
B.DropaviewassociatedtothetableSTUDEN.
C.DropthetableSTUDENT.
D.Noneoftheabove.
20.ADirtyReadoccurswhen?
C
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
----- -----
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
- - D 25
Whichofthefollowingjoinswillproducethedesiredresults?
D
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?
C
A.Eachcolumnconsistsofoneormorerecords
B.Columnsarewheretheindividualpiecesofinformationarestoredforeachrecord
C.Columnsmustbedesignatedaspecificdatatype
D.Columnsarealsoknownasrecords
23.Giventheoptionsbelow,whichofthefollowingstatementscanaddrecordstoatable?
C
A.ADDREC
B.ADDRECORD
C.INSERT
D.ADD
24.IfTAB1iscreatedusingthefollowingstatement
CREATETABLEtab1(
col1INTEGERNOTNULL,
col2CHAR(3),
CONSTRAINTcst1CHECK(col1in(1,2,3,4)))
WhichofthefollowingstatementswillsuccessfullyinsertarecordintotableTAB1?
C
A.INSERTINTOtab1VALUES(0,'a')
B.INSERTINTOtab1VALUES(NULL,'abc')
C.INSERTINTOtab1VALUES(4,'a')
D.INSERTINTOtab1VALUES(4,'abcdefhijklmnopq')
25.GiventhefollowingUPDATEstatement:
UPDATEemployeesSETworkdept=
(SELECTdeptnoFROMdepartmentWHEREdeptno='A01')
WHEREworkdeptISNULL
Whichofthefollowingdescribestheresultifthisstatementisexecuted?
B
A.ThestatementwillfailbecauseanUPDATEstatementcannotcontainasubquery
B.Thestatementwillonlysucceedifthedataretrievedbythesubquerydoesnotcontainmultiplerecords
C.Thestatementwillsucceed;ifthedataretrievedbythesubquerycontainsmultiplerecords,onlythefirstrecordwillbeusedtoperformtheupdate
D.ThestatementwillonlysucceedifeveryrecordintheEMPLOYEEStablehasanullvalueintheWORKDEPTcolumn
26.Acompanyhasalargeamountofdatatostoreandwantstobeabletodothefollowingwiththedata:
Haveastandardinterfaceforaccessingthedata.
Havemultipleuserswiththeabilitytoinsert,updateanddeletedata.
Makechangestothedatawithoutriskoflosingdataanditsconsistency.
Havethecapabilitytohandlehugevolumesofdataandusers.
Havetoolsfordatabackup,restoreandrecovery.
Whatdatastoragemethodisthemostoptimalsolutionforthecompany?
D
A.Textfiles
B.Commadelimiteddatafiles
C.Spreadsheets
D.Database
27.Considerthefollowingscenario.Youhave3tableswiththesamename(TABLE_1)under3differentschemas(SYSIBM,DEFAULTandDB2INST1).YouareconnectedtoaDB2databaseinyourLinuxserverasdb2inst1andissuethefollowingstatement:
SELECT*FROMtable_1
Whichtablewillyoubeselectingdatafrom:
A
A.Yougetanerrorbecauseyourqueryisambiguous,asthetableschemaisnotspecified
B.SYSIBM.table_1
C.DEFAULT.table_1
D.DB2INST1.table_1
28.WhichofthefollowingstatementsgrantsuserJohntheabilitytoinsertdatatotabletab1?
D
A.GRANTADDONTABLEtab1TOJohn
B.GRANTINSERTONTABLEtab1TOJohn
C.