考试总分：138分
考试类型：模拟试题
作答时间：60分钟
已答人数：967
试卷答案：有
试卷介绍： DB2
AABEFOREtriggercanbeusedtoperformvalidationofinputdata.
BABEFOREtriggercanbeusedtoautomaticallygeneratevaluesfornewlyinsertedrows.
CABEFOREtriggerisfiredforeachrowinthesetofaffectedrowsbeforethetriggereventexecutes.
DABEFOREtriggerisfiredforeachrowinthesetofaffectedrowsinsteadofexecutingthetriggerevent.
AChangethedatatypeofthesequence.
BResetthesequencetoitsstartingvalue.
CEstablishnewminimumormaximumvalues.
DChangetheincrementbetweenfuturevalues.
ABIND
BREBIND
CBINDADD
DBIND_REBIND
AALTER
BUSAGE
CUPDATE
DCOMMENT
ADB2PersonalEdition
BDB2DevelopmentEdition
CDB2ConnectPersonalEdition
DDB2DevelopmentUnlimitedEdition
AView
BIndex
CTrigger
DCheckconstraint
AOncetherow-begin,row-end,andtransaction-start-idcolumnsarecreated,allchangesaretracked.
BAhistorytablemustbecreatedwithidenticalcolumnstothebasetableandauniqueindexmustbedefinedonthetransaction-start-idcolumn.
CAhistorytablemustbecreatedasaclonetableofthebasetableaftertherow-begin,row-end,andtransaction-start-idcolumnshavebeendefined.
DAhistorytablemustbecreatedwithidenticalcolumnstothebasetableandthenthebasetablealteredwiththeADDVERSIONINGclausetorelateittothehistorytable.
AALOBlocatorisadatatypethatisusedtostoreLOBdatainbinaryfiles.
BALOBlocatorisadatatypethatisusedtostoreLOBdatainadatabase.
CALOBlocatorrepresentsavalueforaLOBresourcethatisstoredinadatabase.
DALOBlocatorrepresentsavalueforaLOBresourcethatisstoredinabinaryfile.
ASELECTname,COUNT(*)AStransactionsFROMsales
BSELECTname,COUNT(DISTINCTname)AStransactionsFROMsales
CSELECTname,COUNT(*)AStransactionsFROMsalesGROUPBYname
DSELECTDISTINCTname,COUNT(*)AStransactionsFROMsalesGROUPBYtransactions
AAlllocksheldonthedatabaseareautomaticallyreleased.
BDatastoredinglobaltemporarytablesisautomaticallydeleted.
COpencursorsdefinedWITHHOLDareclosed,buttheirdataisretained.
DThecurrenttransactionisterminatedandanewtransactionboundaryisstarted.
AAJavastoredprocedure.
BAREXXstoredprocedure.
CAnativeSQLstoredprocedure.
DAnexternalSQLstoredprocedure.
ATheystoreuser-basedperiodinformation.
BTheydonothaveaseparatehistorytable.
CTheycanbequeriedwithoutatimeperiodspecification.
DTheymanagedatabasedontimecriteriaspecifiedbyusersorapplications.
AAtablecanhaveonlyoneforeignkey.
BForeignkeyscanonlybedefinedwhenatableiscreated.
CAforeignkeycanbedefinedonacolumnorasetofcolumnsinatable.
DForeignkeysareenforcedonlyduringtheexecutionofINSERTstatements.
AMultipleprimarykeyscanbedefinedforatable.
BAforeignkeycanreferencemultipleprimarykeys.
CAprimarykeycanbereferencedbyonlyoneforeignkey.
DPrimarykeysandforeignkeysareusedtodefinerelationships.
ACREATETABLEparts(part_noINTEGER,descCLOB))
BCREATETABLEparts(part_noINTEGER,descVARCHAR(200))
CCREATETABLEparts(part_noINTEGER,descCLOBFORBITDATA))
DCREATETABLEparts(part_noINTEGER,descVARCHAR(200)FORBITDATA)
ABIGINT
BBINARY
CDOUBLE
DDECIMAL
AWhenatransactionintendstoreadorchangedata.
BWhenatransactionintendstochangebutnotreaddata.
CWhenatransactionintendstoreadbutnotchangedata.
DWhenatransactionintendstochangethesystemcatalog.
ALocksize
BNumberoflocks
CLockmodeneeded
DAvailablerealstorage
ATrigger
BSQLProcedure
CSequenceObject
DMaterializedQueryTable
AWhenyouwanttocontroltheorderinwhichtriggersarefired.
BWhenyouwanttocontroltheorderinwhichstoredprocedurescanbeinvoked.
CWhenyouwanttoautomaticallygenerateanumericvaluethatisnottiedtoanyspecificcolumnortable.
DWhenyouwanttoautomaticallygenerateanumericvalueforeachrowthatisaddedtoaspecifictable.
AADDCOLUMN
BALTERCOLUMN
CAPPENDCOLUMN
DRENAMECOLUMN
ATable
BSchema
CPackage
DDatabase
AAtransaction-start-idcolumnmustbedefinedforthetable.
BAhistorytablemustbedefinedandassociatedwiththebasetable.
CABUSINESS_TIMEperiodmustbespecifiedinaCREATEorALTERofthetable.
DAuniqueindexmustbecreatedthatpreventsoverlappingoftheBUSINESS_TIMEperiodofthetable.
ATocombinedatafrommultiplesources.
BTodiscoverhiddenrelationshipsindata.
CToanalyzelargeamountsofdatatofindpatterns.
DTomakechangestoasmallnumberofrecordswithinasingletransaction.
AReadStability(RS)
BCursorStability(CS)
CRepeatableRead(RR)
DUncommittedRead(UR)
ATablesize
BBufferspace
CNumberoflocks
DAvailablerealstorage
AShare(S)
BUpdate(U)
CExclusive(X)
DIntentExclusive(IX)
AXMLTABLE
BXMLPARSE
CXMLEXISTS
DXMLATTRIBUTES
ASELECT*FROMemployeeWHERE(hiredate<'1999-01-01'ANDsalary<40000)OR(education='University')
BSELECT*FROMemployeeWHERE(hiredate<'1999-01-01')OR(salary<40000)OR(education='University')
CSELECT*FROMemployeeWHERE(hiredate<'1999-01-01'OR(salary<40000AND(education='University')
DSELECT*FROMemployeeWHERE(hiredate<'1999-01-01'ANDsalary<40000AND(education='University')
ASELECTempno,hiredate,salaryFROMemployeeFORhiredate<'1998-01-01'ANDsalary<35000
BSELECTempno,hiredate,salaryFROMemployeeWHEREhiredate<'1998-01-01'ANDsalary<35000
CSELECTempno,hiredate,salaryFROMemployeeWHEREhiredate<'1998-01-01'ORsalary<35000
DSELECTempno,hiredate,salaryFROMemployeeFORhiredate<'1998-01-01'ORsalary<35000
ASELECTlastname,firstnme,salary,jobFROMemployeeORDERBY3FETCHFIRST5ROWSONLY
BSELECTlastname,firstnme,salary,jobFROMemployeeORDERBY3DESCFETCHFIRST5ROWSONLY
CSELECTlastname,firstnme,salary,jobFROMemployeeORDERBY3FETCHFIRST5ROWS
DSELECTlastname,firstnme,salary,jobFROMemployeeORDERBY3DESCFETCHFIRST5ROWS
AItmustnotcontainmorethanonecolumn.
BItcannotbeusedinareferentialconstraint.
CItmustbedefinedwiththeUNIQUEattribute.
DItmustbedefinedasUNIQUEWHERENOTNULL.
AOnlyoneINSERT,UPDATE,orDELETEtriggercanbedefinedpertable.
BTriggerscannotbemodified,theymustbedroppedandrecreatedwithnewdefinitions.
CAddingatriggertoatablethatalreadyhasrowsinitwillcausetriggeredactionstobefired.
DTriggerscanonlybefiredonetimeperstatementirrespectiveofthenumberofrowsaffected.
AAnerrorwillbereturnedandtheoperationwillfail.
BAwarningwillbereturnedandtheuniqueindexINDX1willbecometheindexfortheprimarykey.
CTheprimarykeywillbesuccessfullyaddedandtheuniqueindexINDX1willbedroppedandrecreatedastheprimarykeyindex.
DTheprimarykeywillbesuccessfullyadded,theuniqueindexINDX1willbedropped,andanewindexwillbecreatedfortheprimarykey.
AThedatainthetableisdeletedandthetablepersists.
BThedatainthetableisdeletedandthetableisimplicitlydropped.
CThetemporarytableisconvertedtoabasetableandthedataisdeleted.
DThetemporarytableisconvertedtoabasetableandthedataispersistent.
AUSER1canonlyremovetheSALEStable.
BUSER1canonlyremoverecordsfromtheSALEStable.
CUSER1canremovetheSALEStableandgranttheprivilegetoremovetheSALEStabletootherusers.
DUSER1canremoverecordsfromtheSALEStableandgranttheprivilegetoremoverecordsfromtheSALEStabletootherusers.
AAuthentication
BAuthoritiesandprivileges
CLabel-basedaccesscontrol
DRowandcolumnaccesscontrol
AREVOKEUSEOFTABLESPACEmytbspFROMuser1
BREVOKEALTERONTABLESPACEmytbspFROMuser1
CREVOKEUPDATEOFTABLESPACEmytbspFROMuser1
DREVOKECREATETABONTABLESPACEmytbspFROMuser1
ALocked
BWaiting
CPending
DUnconnected
AWhenmandatoryaccesscontrol(MAC)isusedtoprotectthetable.
BWhendiscretionaryaccesscontrol(DAC)isusedtoprotectthetable.
CWhenlabel-basedaccesscontrol(LBAC)isusedtoprotectthetable.
DWhenrowandcolumnaccesscontrol(RCAC)isusedtoprotectthetable.
AType-1connect
BType-2connect
CType-3connect
DType-4connect
ABitemporaltablesaresystemtablesandcanonlybequeriedbytheschemaowner.
BCreatingabitemporaltableissimilartocreatingaregulartableexceptusersmustspecifyasystemtimeperiodcolumn.
CWhendatainabitemporaltableisupdated,arowisaddedtoit'sassociatedhistorytable.
DQueryingabitemporaltablewillproduceresultsforacompletetimeline;aviewmustbecreatedtoobtainresultsforaspecifictimeperiod.
ASchema
BTablespace
CStoragegroup
DStoredprocedure
ASELECT*FROMemployeeWHEREsalary<100000
BSELECTsalaryFROMemployeeWHEREsalary>100000
CSELECTsalaryFROMemployeeWHEREsalary>100,000.00
DSELECT*FROMemployeeWHEREsalaryGREATERTHAN100000
ASELECTjob,MIN(salary),MAX(salary)FROMemployeeGROUPBYjobORDERBYjob;
BSELECTjob,MIN(salary),MAX(salary)FROMemployeeORDERBYjob;
CSELECTjob,MIN(salary),MAX(salary)FROMemployeeGROUPBYSALARYORDERBYjob;
DSELECTjob,MIN(salary),MAX(salary)FROMemployeeGROUPBYMIN(salary),MAX(salary)ORDERBYjob;
A0
B1
C10
D99
ASELECTdept_info(dept_id,dept_name)
BSELECTdept_id,dept_nameFROMdept_info()
CSELECTTABLEdept_id,dept_nameFROMdept_info()
DSELECTdept_id,dept_nameFROMTABLE(dept_info())ASresults
AAlias
BView
CIndex
DSequence
ADefineaviewononeormoretablesorviews.
BRevalidateallinvalidobjectsthatarereferencedonaview'sfullselect.
CEnsurethatanyinsertedorupdatedrowsconformtothedefinitionoftheview.
DDefineaviewthatonlyconsistsofcolumnsthathavecheckconstraintsdefined.
ACheck
BUnique
CReferential
DInformational
AExecutionofanINSERTstatement.
BExecutionofLOADREPLACEoperation.
CExecutionofanINSERToperationofaMERGEstatement.
DExecutionofanUPDATEoperationofaMERGEstatement.
ATooverridethelimitonindexkeycolumns.
BTofurtherenforcetheuniquenessofindexvalues.
CTocombinetwoormoreindexestocreateasingleuniqueindex.
DToimproveperformanceofsomequeriesbyallowingindex-onlyaccess.
ACursorStability(CS)
BRepeatableRead(RR)
CReadStability(RS)withCurrentlyCommittedsemantics
DCursorStability(CS)withCurrentlyCommittedsemantics
AReadstability(RS)
BCursorstability(CS)
CRepeatableread(RR)
DUncommittedread(UR)
ABitemporal
BTime-period
CSystem-period
DApplication-period
AInthetabledefinition.
BInthesystemcatalog.
CIntheschemathattheindexresidesin.
DInthemetadataofthetabletheindexwascreatedfor.
ApureScale
BWorkloadmanager
CDatapartitioningfeature
DSelf-tuningmemorymanager
Alocator
Bpointer
Caddress
Dreference
ABIND
BDROP
CGRANT
DSELECT
AAlllocksheldonthedatabaseareautomaticallyreleased.
BDatastoredinglobaltemporarytablesisautomaticallydeleted.
COpencursorsdefinedWITHHOLDareclosed,buttheirdataisretained.
DThecurrenttransactionisterminatedandanewtransactionboundaryisstarted.
ACOMMIT
BROLLBACK
CCOMMITTOSAVEPOINT
DROLLBACKTOSAVEPOINT
ACALLconv_temp(climate_info.avg_temp);
BCALLconvert_ftoc(climate_info.avg_temp);
CSELECTconv_temp(avg_temp)FROMclimate_info;
DSELECTconvert_ftoc(avg_temp)FROMclimate_info;
ALoadoperations
BBackup/copytablespaces
CCreateanddropdatabases
DMonitordatabaseperformance
ATodefineexactlywhataspecificusercandowithinaparticulardatabaseoncetheyhavebeenauthenticated.
BTogroupacollectionofprivilegestogethersothattheycanbesimultaneouslygrantedtoandrevokedfrommultipleusers.
CToestablishacrediblerelationshipbetweenDB2andanexternalentity,suchasadatabaseadministratororamiddlewareserver.
DTogroupacollectionofuserstogethersothattheycanbesimultaneouslygrantedandrevokedspecificauthoritiesandprivileges.
AGRANTALTERONSEQUENCEmyseqTOuser1
BGRANTUSAGEONSEQUENCEmyseqTOuser1
CGRANTSELECTONSEQUENCEmyseqTOuser1
DGRANTCOMMENTONSEQUENCEmyseqTOuser1
AThecolumnmaskmustbeenabled;theEMPLOYEEtablemustbealteredtoactivatecolumnaccesscontrol.
BThecolumnmaskmustbeenabled(columnaccesscontrolfortheEMPLOYEEtablewillbeactivatedautomatically).
CTheEMPLOYEEtablemustbealteredtoactivatecolumnaccesscontrol(thecolumnmaskwillbeenabledautomatically).
DTheEMPLOYEEtablemustbealteredtoactivatecolumnaccesscontrol;rowpermissionmustbegrantedtoeveryonewhoneedstousethecolumnmask.
ANofractionaldigitsortimezone.
B6fractionaldigitsandnotimezone.
C12fractionaldigitsplusatimezone.
D12fractionaldigitsandnotimezone.
AToallowqueriestorunmoreefficiently.
BToenforceconstraintssuchasuniquenessonindexkeys.
CToorderthecolumnsofatableinascendingordescendingsequenceaccordingtovaluesinarow.
DToordertherowsofatableinascendingordescendingsequenceaccordingtothevaluesinacolumn.
AUniqueconstraint
BPrimarykeyconstraint
CInformationalconstraint
DColumndefaultconstraint
AAtablecanonlyhaveoneuniquekeyconstraint.
BAtablecanhavemultipleprimarykeyconstraints.
CInformationalconstraintstellDB2whatrulesthedataconformsto,buttherulesarenotenforced.
DForeignkeyconstraintsareenforcedonthevalueswithintherowsofatable,orbetweentherowsoftwotables,byauniqueindexonaforeignkey.
AArowmask'saccesscontrolruleisdefinedbyanSQLCASEexpression;acolumnpermission'saccesscontrolruleisdefinedbyanSQLsearchcondition.
BArowpermission'saccesscontrolruleisdefinedbyanSQLCASEexpression;acolumnmask'saccesscontrolruleisdefinedbyanSQLsearchcondition.
CArowmask'saccesscontrolruleisdefinedbyanSQLsearchcondition;acolumnpermission'saccesscontrolruleisdefinedbyanSQLCASEexpression.
DArowpermission'saccesscontrolruleisdefinedbyanSQLsearchcondition;acolumnmask'saccesscontrolruleisdefinedbyanSQLCASEexpression.
AMaterializedquerytable
BSystem-periodtemporaltable
CDeclaredglobaltemporarytable
DApplication-periodtemporaltable
ACREATEDISTINCTALIAScanadian_dollarASDECIMAL(9,3)WITHCOMPARISONS
BCREATEDISTINCTTYPEcanadian_dollarASDECIMAL(9,3)WITHCOMPARISONS
CCREATEDISTINCTPROCEDUREcanadian_dollarASDECIMAL(9,3)WITHCOMPARISONS
DCREATEDISTINCTFUNCTIONcanadian_dollarASDECIMAL(9,3)WITHCOMPARISONS
AView
BBufferpool
CStoragegroup
DTemporarytable
ADB2Connect
BDB2pureScale
CWorkloadManager
DHighAvailabilityDisasterRecovery
Ainline
Bbinary
Cinternal
Dpartitioned
AIBMDataStudio
BIBMAdministrator
CIBMDataManager
DIBMCommandCenter
ADB2fori
BDB2forAIX
CDB2forz/OS
DDB2forLinux
AAIX
BiOS
Cz/OS
DWindows
ATheUPDATEstatementlogsthebeforeandaftervalueofeverycolumnitmodifies.
BAsearchedUPDATEisusedtoupdateoneormorerowsandapositionedUPDATEisusedtoupdateexactlyonerow.
CWhentheUPDATEstatementmodifiesparentkeycolumns,thevalueofcorrespondingforeignkeycolumnsarealsomodified.
DTheUPDATEstatementmodifiesthevaluesofspecifiedcolumnsintherowsofatable,view,orunderlyingtable(s)ofaspecifiedfullselect.
AJoeSmith
BJoeSmith
CJoeSmith>DB2
DJoeSmith
ASELECTstate_cd,COUNT(*)FROMstatesORDERBYCOUNT(*);
BSELECTstate_cd,COUNT(*)FROMstatesGROUPBYstate_cdORDERBYstate_cd;
CSELECTregion_cd,COUNT(*)FROMstatesGROUPBYstate_cdORDERBYCOUNT(*);
DSELECTregion_cd,COUNT(*)FROMstatesGROUPBYregion_cdORDERBYCOUNT(*);
ATheSYSIBMschema.
BTheSYSFUNschema.
CAschemawiththenameoftheUDF.
DAschemawiththeuseridoftheUDFdefiner.
A1)CreateaprimarykeyontableTAB1;2)CreateaforeignkeyontableTAB2thatreferencestheprimarykeyontableTAB1andadherestotheONDELETECASCADErule.
B1)CreateaprimarykeyontableTAB2;2)CreateaforeignkeyontableTAB1thatreferencestheprimarykeyontableTAB2andadherestotheONDELETECASCADErule.
C1)CreateaprimarykeyontableTAB1;2)CreateaforeignkeyontableTAB2thatreferencestheprimarykeyontableTAB1andadherestotheONDELETERESTRICTrule.
D1)CreateaprimarykeyontableTAB2;2)CreateaforeignkeyontableTAB1thatreferencestheprimarykeyontableTAB2andadherestotheONDELETERESTRICTrule.
AThevictimwillberolledback.
BThevictimwillreadthroughthelock.
CBothvictimandholderarerolledback.
DThevictimmustwaituntiltheholderreleasesthelock.
ALockwait
BLocktimeout
CLockescalation
DLockconversion
ALockexchange
BLockpromotion
CLockescalation
DLockconversion
AALTERTABLEsalesADDCOLUMNitemCHAR(40);
BALTERTABLEsalesALTERCOLUMNitemCHAR(40);
CALTERTABLEsalesMODIFYCOLUMNitemCHAR(40);
DALTERTABLEsalesALTERCOLUMNitemSETDATATYPECHAR(40);
ACLI
BXML
CJDBC
DRUBY
Ainline
Bbinary
Cinternal
Dpartitioned
AControlCenter
BIBMDataStudio
CUniversalConnectionExpert
DDB2ConnectionPoolManager
ALOCKTABLEtab1INREADMODE
BLOCKTABLEtab1INSHAREMODE
CLOCKTABLEtab1INEXCLUSIVEMODE
DLOCKTABLEtab1INREAD-ONLYMODE
ALockescalation
BLocksubstitution
CLockswitch/exchange
DLockconversion/promotion
ASELECTemployees.name,sales.revenueFROMemployeesINNERJOINsalesONemployees.id=sales.emp_id
BSELECTemployees.name,sales.revenueFROMemployeesINNERJOINsalesONsales.emp_id=employees.id
CSELECTemployees.name,sales.revenueFROMsalesLEFTOUTERJOINemployeesONemployees.id=sales.emp_id
DSELECTemployees.name,sales.revenueFROMsalesRIGHTOUTERJOINemployeesONemployees.id=sales.emp_id
ATRIM
BDROP
CDELETE
DTRUNCATE
ATheINSERTstatementisusedtoinsertrowsintoatable,view,ortablefunction.
BInsertedvaluesmustsatisfytheconditionsofanycheckconstraintsdefinedonthetable.
CIfanINSERTstatementomitsanycolumnfromtheinsertedrowthatisdefinedasNULLorNOTNULLWITHDEFAULT,thestatementwillfail.
DIftheunderlyingtableofaviewbeingreferencedbyanINSERTstatementhasoneormoreuniqueindexes,eachrowinserteddoesnothavetoconformtotheconstraintsimposedbythoseindexes.
ASELECTjob,MIN(salary),MAX(salary)FROMemployeeGROUPBYjob;
BSELECTjob,MIN(salary),MAX(salary)FROMemployeeORDERBYjob;
CSELECTjob,MIN(salary),MAX(salary)FROMemployeeGROUPBYjob,MIN(salary),MAX(salary);
DSELECTJOB,MIN(salary),MAX(salary)FROMemployeeORDERBYjob,MIN(salary),MAX(salary);
AAssigntheSSNcolumntoarestrictedrolethatonlyauthorizeduserscanaccess.
BOnlygrantACCESSCTRLauthorityfortheSSNcolumntouserswhoneedtoaccessSSNdata.
CAlterthetabledefinitionsothatSSNdataisstoredinaseparateschemathatonlyauthorizeduserscanaccess.
DCreateaviewfortheEMPLOYEEtablethatdoesnotcontaintheSSNcolumnandrequireunauthorizeduserstousetheview.
ADBCTRLauthority
BSQLADMauthority
CDATAACCESSauthority
DACCESSCTRLauthority
AAtriggerisdesignedtoreturnspecifictypesofvaluesandcontainsexecutablecode.
BAtriggerisdesignedtoreturnspecifictypesofvaluesbutcontainsnoexecutablecode.
CAtriggerperformsactionstocapturedetailsaboutanactivitylikeajoinoperationagainstmultipletables.
DAtriggerperformsactionsinresponsetoaneventlikeanINSERT,UPDATEorDELETEoperationonatable.
AToenableuniqueness.
BToensuredataclustering.
CTocombinedatafrommultipletables.
DTooptimizequeriesranagainstmultipletables.
AInanXMLindex.
BInlinewiththerestofthedataforthetable.
CInanXMLstorageobjectthatisseparatefromthetable.
DInlinewiththerestofthedataforthetable,forXMLcolumnslessthan32KB.
APrimarykey
BPartitioningkey
CCheckconstraint
DUniqueconstraint
AINSERT
BSELECT
CCREATE
DTRIGGER
AGRANTEXECUTEONAPPLICATIONbenefitsTOuser1
BGRANTEXECUTEONPACKAGEcorpdata.pkgaTOuser1
CGRANTEXECUTEONAPPLICATIONPACKAGEcorpdata.pkgaTOuser1
DGRANTEXECUTEONAPPLICATIONbenefitsUSINGPACKAGEcorpdata.pkgaTOuser1
ASALEScanbethenameofaschema.
BSALEScanbethenameofapackage.
CSALEScanbethenameofanexistingalias.
DSALEScanbethenameofadeclaredglobaltemporarytable.
A0
B1
C2
D3
AView
BTable
CSequence
DIdentityColumn
ADatabase
BBufferpool
CTablespace
DPackagecache
AControlCenter
BIBMDataStudio
CUniversalConnectionExpert
DDB2ConnectionPoolManager
AWhenaROLLBACKstatementisexecuted,alllocksheldbytheterminatingtransactionarereleased.
BWhenaROLLBACKTOSAVEPOINTstatementisexecuted,alllocksacquireduptothesavepointarereleased.
CWhenaROLLBACKTOSAVEPOINTstatementisexecuted,alllocksacquiredafterthesavepointarereleased.
DWhenaROLLBACKstatementisexecuted,alllocksacquiredforopencursorsthatweredeclaredWITHHOLD,areheld.
ASELECTworkdept,AVG(salary)FROMemployeeORDERBYworkdeptGROUPBY2
BSELECTworkdept,AVG(salary)FROMemployeeORDERBYworkdeptARRANGEBY2
CSELECTworkdept,AVERAGE(salary)FROMemployeeGROUPBYworkdeptORDERBY2
DSELECTworkdept,AVG(salary)FROMemployeeGROUPBYworkdeptORDERBY2
AThestatementwillfailbecauseasubquerycannotbeusedinanUPDATEstatement.
BThestatementwillfailbecausetheresultsetproducedbythesubquerywillcontainmorethanonerow.
CThestatementwillsucceed;thelastrecordretrievedbythesubquerywillbeusedtoprovideaWORKDEPTvaluefortheupdateoperation.
DThestatementwillsucceed;thefirstrecordretrievedbythesubquerywillbeusedtoprovideaWORKDEPTvaluefortheupdateoperation.
AToprovideamethodofavoidingduplicateentriesforacolumn.
BToprovideamethodofensuringacolumn'svaluesarewithinaspecificrange.
CToensurethatXMLcolumnsareproperlypopulatedinanassociatedXMLtablespace.
DToenforcerelationshipsbetweentablesbycheckingtheexistenceofrowsinonetableagainstanother.
ABaseTable
BTemporalTable
CTransitionTable
DTemporaryTable
AToupdatedatainothertables.
BToperforminsert,update,anddeleteoperationsagainstcomplexviews.
CTocheckormodifyvaluesbeforetheyareactuallystoredinadatabase.
DTorunnon-databaseoperationsthatarecodedinuser-definedfunctions.
ATrigger
BProcedure
CTablefunction
DScalarfunction
AConcurrentapplicationprocessesfromperforminganyoperationsonthetable.
BConcurrentapplicationprocessesfromperforminganyread-onlyoperationsonthetable.
CConcurrentapplicationsprocessesthatarerunningunderthecursorstability(CS)isolationlevelfromperformingread-onlyoperationsonthetable.
DConcurrentapplicationsprocessesthatarerunningundertheuncommittedread(UR)isolationlevelfromperformingread-onlyoperationsonthetable.
AReadStability(RS)
BCursorStability(CS)
CRepeatableRead(RR)
DUncommittedRead(UR)
A4
B8
C16
D32
AOracleconnect
BTrustedcontext
COraclefederation
DDistributedrequest
AAlias
BIndex
CSchema
DCollection
AToautomaticallycaptureandstoproguequeries.
BToproviderecommendationsandanalysisfortuningasinglequery.
CToproviderecommendationsandanalysisfortuningupto100queries.
DTorecommendindexesandtoguideDBAsthroughtheprocessofcreatingnewindexes.
AReadStability(RS)
BRepeatableRead(RR)
CUncommittedRead(UR)
DCursorStability(CS)
AWhenatransactionintendstoreadorchangedata.
BWhenatransactionintendstochangebutnotreaddata.
CWhenatransactionintendstoreadbutnotchangedata.
DWhenatransactionintendstochangethesystemcatalog.
AReadstability(RS)
BCursorstability(CS)
CRepeatableread(RR)
DUncommittedread(UR)
AThelast5rowsinthetablewillbedeleted.
BThefirst5rowsinthetablewillbedeleted.
CThestatementwillfailbecauseasubquerycannotbeusedwithaDELETEstatement.
DThestatementwillfailbecauseatablenamewasnotspecifiedwiththeDELETEstatement.
AConsistsofexplicitly-suppliedtimestampsandaseparateassociatedhistorytable.
BIsbasedonexplicitly-suppliedtimestampsthatdefinethetimeperiodsduringwhichdataisvalid.
CIsusefulwhenonewantstokeepbothuser-basedperiodinformationandsystem-basedhistoricalinformation.
DConsistsofapairofcolumnswithdatabase-managermaintainedvaluesthatindicatetheperiodwhenarowiscurrent.
ALocked
BWaiting
CPending
DUnconnected
ADBADM
BDBCTRL
CSECADM
DDBMAINT
AGRANTCREATETABONDATABASETOuser1
BGRANTSELECTONTABLEemployeeTOuser1
CGRANTCREATEVIEWONDATABASETOuser1
DGRANTREFERENCESONTABLEemployeeTOuser1
ACALL
BUSAGE
CEXECUTE
DREFERENCES
ATheSYSIBMschema.
BTheSYSFUNschema.
CAschemawiththenameoftheUDF.
DAschemawiththeuseridoftheUDFdefiner.
ATheforeignkeyconstraintcolumnsmustbesupportedbyanindex.
BTheforeignkeyconstraintcolumnsmustbedefinedasNOTNULL.
CThenumberanddatatypesofforeignkeyconstraintcolumnsmustmatchtheparentkey.
DThecolumnsofoneforeignkeyconstraintcannotbeusedinanotherforeignkeyconstraint.
ETodefineaforeignkeyconstrainttheremustbeanassociatedprimarykeyoruniquekeyinthesameordifferenttable.
ACALLstatements.
BExternalfileaccess.
CUseofascratchpad.
DCOMMITstatements.
ESQLcontrolstatements.
AConfirmproductinventory.
BMonitorproductavailability.
CSummarizesalesbyregion.
DIdentifypatternsforproductssoldinthelastfiveyears.
EAssociateoneormoreproductswithapurchaseorder.
ATree
BNode
CTrigger
DContexts
ESequence
AView
BIndex
CTable
DTrigger
EProcedure
