其他类 - Oracle认证考试

单选题

Given: Whatistheresult?（）

A. Compilationfails.
B. exceptionisthrownatruntime.
C. TheattributeidintheItemTestobjectremainsunchanged.
D. TheattributeidintheItemTestobjectismodifiedtothenewvalue.
E. AnewItemTestobjectiscreatedwiththepreferredvalueintheidattribute.

查看答案

单选题

Evaluatethefollowingfunctioncode: Whichstatementistrueregardingtheabovefunction?（）

A. ThecachedresultbecomesinvalidwhenanystructuralchangeisdonetotheEMPLOYEEStable.
B. Ifthefunctionexecutionresultsinanunhandledexception,theexceptionresultisalsostoredinthecache.
C. Eachtimethefunctionisinvokedinadifferentsession,thecurrentresultintheresultcachegetsoverwritten.
D. Ifthefunctionisinvokedwithadifferentparametervalue,theexistingresultintheresultcachegetsoverwrittenbythelatestvalue.

查看答案

单选题

Youexecutedthefollowingcommand: RMAN>RECOVERCOPYOFDATAFILE'/u01/app/oracle/oradata/orcl/users01.dbf'; Whichstatementregardingtheabovecommandiscorrect?（）

A. The'/u01/app/oracle/oradata/orcl/users01.dbf'datafileisrecoveredfromtheimagecopy
B. The'/u01/app/oracle/oradata/orcl/users01.dbf'datafileisrecoveredfromthelastincrementalbackup
C. Imagecopiesofthe'/u01/app/oracle/oradata/orcl/users01.dbf'datafileareupdatedwithallchangesuptoincrementalbackupSC
D. '/u01/app/oracle/oradata/orcl/users01.dbf
E. Imagecopiesofthe'/u01/app/oracle/oradata/orcl/users01.dbf'datafilearerecoveredusingtheabovecommandifdatafilerecoveryfails

查看答案

单选题

ViewtheExhibitandexaminetheDataPumparchitecture.Identifythenumberedcomponents.（）

A. 1-OracleLoader,2-OracleDataPump,3-DirectPathAPI
B. 1-OracleDataPump,2-DirectPathAPI,3-OracleLoader
C. 1-DirectPathAPI,2-OracleLoader,3-OracleDataPump
D. 1-OracleLoader,2-DirectPathAPI,3-OracleDataPump

查看答案

单选题

Inyourdatabase,theflashrecoveryarea(FRA)isconfiguredasthedefaultforRMANbackups.YouexecutedthefollowingcommandstoconfigurethesettingsinRMAN: Whichstatementistrueabouttheoutcome?（）

A. Onlyonechannelisallocatedandthebackupiscreatedintheflashrecoveryarea
B. Onlyonechannelisallocatedandthebackupiscreatedinthedestinationspecifiedforchannel
C. Twochannelsareallocatedandbackupsetsarecreatedinthedestinationsspecifiedforchannels1and2
D. Threechannelsareallocatedandbackupsetsarecreatedinthedestinationsspecifiedforchannels1,2,andFRA

查看答案

单选题

Viewtheexhibitandexaminetheoutput. Whichstatementcanbeaninferencefromtheoutput?（）

A. TheFRAdiskgrouphasanasynchronousI/Obottleneck
B. TheleastnumberofI/Osareperformedonthelastdatafileinthelist
C. ThenumberoftimesthatthebackuporrestoreprocessdirectedtheOStowaituntilanI/Owascompleteisthehighestforthelastdatafileinthelist
D. ThenumberoftimesthatthebackuporrestoreprocessmadeanOScalltopollforI/OcompletioninNonblockingmodeistheleastfortheFRAdiskgroup

查看答案

多选题

Examinethefollowingcommandthatisusedtoduplicateadatabaseonthesamehost: Whichtwostatementsdescribetheeffectafterthedatabaseisduplicatedsuccessfully?（）

A. Thedatafilesoftheread-onlytablespacesinthetargetdatabasearenotduplicated
B. Theread-onlytablespacesinthetargetdatabasearestilldefinedinnewthedatabase
C. Theread-onlytablespacesinthetargetdatabasearechangedtoonlineafterduplication
D. Thedatafilesoftheread-onlytablespacesinthetargetdatabasegetduplicated
E. Theread-onlytablespacesinthetargetdatabasearenotdefinedinthenewdatabase

查看答案

单选题

Examinethefollowingcommandsandtheiroutput: SQL>SELECTename,salFROMempWHEREename='JAMES';ENAMESALJAMES1050 QL>UPDATEempSETsal=sal+sal*1.2WHEREename='JAMES'; 1rowupdated. SQL>SELECTename,salFROMempWHEREename='JAMES';ENAMESALJAMES2310 ViewtheexhibitandexaminetheFlashbackVersionQuerythatwasexecutedaftertheprecedingcommands. Whatcouldbethepossiblecauseforthequerynotdisplayinganyrow?（）

A. Flashbackloggingisnotenabledforthedatabase.
B. Thechangesmadetothetablearenotcommitted.
C. Supplementalloggingisnotenabledforthedatabase.
D. ThedatabaseisnotconfiguredinARCHIVELOGmode.

查看答案

多选题

TheEMPtablehassomediscrepancyindataentrywithaparticularemployeeID.YouexecutethequeryasshownintheExhibittoretrieveallversionsoftherowthatexistbetweentwoSCNs. ViewtheExhibit. WhichtwostatementsabouttheresultsofthequeryshownintheExhibitarecorrect?（）

A. TheLAST_SCNvalueinthefirstrowisNULL,whichmeansthattheversionsoftherowstillexistatSCN6636300.LAST_SCN
B. TheLAST_SCNvalueinthesecondrowinNULL,whichmeansthattheversionoftherowstillexistsatSCN6636300.
C. TheLAST_SCNvalueinthethirdrowis6636280,whichmeansthattheversionofrowexistsaboveSCN6636280.
D. TheLAST_SCNvalueinthesecondrowisNULL,whichmeansthattheversionoftherownolongerexistsbecauseitwasdeleted.LAST_SCN

查看答案

单选题

AdatabaseinstanceisusinganAutomaticStorageManagement(ASM)instance,whichhasadiskgroup,DGROUP1,createdasfollows: WhathappenswhenthewholeCONTROLLER1Failuregroupisdamaged?（）

A. Thetransactionsthatusethediskgroupwillhalt.
B. ThemirroringofallocationunitsoccurswithintheCONTROLLER2failuregroup.
C. ThedataintheCONTROLLER1failuregroupisshiftedtotheCONTROLLER2failuregroupandimplicitrebalancingistriggered.
D. TheASMdoesnotmirroranydataandnewlyallocatedprimaryallocationunits(AU)arestoredintheCONTROLLER2failuregroup.

查看答案