Oracle 10g OCP 043 题库 141-185题 共185题

141.TheDB_BLOCK_CHECKINGinitializationparameterissettoFALSE.Whatlevelofblockcheckingwouldbeperformed?

A.TheOracledatabasewillnotperformblockcheckingforanyofthedatablocks.

B.TheOracledatabasewillperformblockcheckingforthedefaultpermanenttablespaceonly.

C.TheOracledatabasewillperformblockcheckingforthedatablocksinallusertablespaces.

D.TheOracledatabasewillperformblockcheckingforthedatablocksintheSYSTEMtablespaceonly.

E.TheOracledatabasewillperformblockcheckingforthedatablocksintheSYSTEMandSYSAUXtablespaces.

Answer:D

142.ViewtheExhibitandexaminethecharacteristicsoftheUSERStablespace.YouobservethatalargevolumeofinsertsanddeletesarehappeningontheTRANStableintheUSERStablespaceandyoususpectthattheTRANStableisfragmented.

Whichadvisorycomponentwouldyoureferto,inordertofindinformationabouttablefragmentation?Exhibit:

A.SegmentAdvisor

B.SQLAccessAdvisor

C.SQLTuningAdvisor

D.MemoryAdvisor

E.AutomaticDatabaseDiagnosticMonitor(ADDM)

Answer:A

143.WhataretheprerequisitesforenablingFlashbackDatabase?(Chooseallthatapply.)

A.ThedatabasemustbestartedintheMOUNTEXCLUSIVEstate.

B.Thedatabasemusthavemultiplexedcontrolfiles.

C.Thedatabasemustbeopenedbyusingatext-basedparameterfileinsteadofaserverparameterfile(SPFILE).

D.ThedatabasemustbeinARCHIVELOGmode.

E.ThedatabasemustbeintheNOMOUNTstate.

F.ThedatabasemustbeopenedinRESTRICTEDmode.

Answer:A,D

144.Lastnight,amediafailurecausedthelossofatemporaryfilethatbelongstoyourdatabase.Whichtwothingsmayhappenthismorningwhenyoutrytoopenyourdatabase?(Choosetwo.)

A.Thedatabasewriterwritestoatracefile,indicatingthatthetemporaryfileisnotfound.

B.Thedatabasepromptsforadatabaserecovery.

C.Thedatabaseopensnormally.

D.Thedatabasegetsmountedandthrowsanerrorindicatingthatthetemporaryfilerequiresrecovery.

Answer:A,C

145.Youconfiguredtheflashrecoveryareainthedatabase.Whichtwofileswouldyouexpecttofindintheflashrecoveryarea?(Choosetwo.)

A.backuppieces

B.copiesofalltheparameterfiles

C.tracefilegeneratedusingBACKUPCONTROLFILETOTRACE

D.controlfileautobackups

Answer:A,D

146.ThedatabaseisrunninginARCHIVELOGmodeandtheFORMAToptionisnotconfiguredinRMANfordiskbackups.YouconfiguredtheflashrecoveryarealocationandsizebyusingtheDB_RECOVERY_FILE_DESTandDB_RECOVERY_FILE_DEST_SIZEinitializationparameters.Whichstatementiscorrectinthisscenario?

A.IftheFORMAToptiontotheRMANBACKUPcommandisspecified,thenRMANcreatesbackuppiecesandimagecopiesintheflashrecoveryareawithnamesintheOracleManagedFiles(OMF)format.

B.IfanylocaldestinationsforLOG_ARCHIVE_DEST_nareset,thenarchivedredologsarestoredinthesedestinationsaswellasintheflashrecoveryarea.

C.IftheflashrecoveryarealocationisconfiguredusingtheDB_RECOVERY_FILE_DESTinitializationparameter,thentheRMANbackupofOraclemanageddatafiles(OMF)onlywillgototheflashrecoveryareabydefault.

D.Ifnootherdestinationisconfiguredforrecoveryfiles,thenRMANplacesthecontrolfileautobackupsintheflashrecoveryareabydefault.

Answer:D

147.Youhavecreatedaresourceplan,PROD_DB_PLAN,thatusestheRATIOpolicy.Thefollowingconsumergroupsandtheirrespectiveplandirectiveshavebeenassignedtothisresourceplan:

ConsumergroupHIGH_CGwithCPU_P1as10.

ConsumergroupMEDIUM_CGwithCPU_P1as5.

ConsumergroupLOW_CGwithCPU_P1as2.

ConsumergroupOTHER_GROUPSwithCPU_P1as1.

Whichstatementiscorrectinthisscenario?

A.TheCPUallocationwouldbeequalbetweentheHIGH_CGandMEDIUM_CGconsumergroupsiftherearenosessionsexistingfortheLOW_CGandOTHER_GROUPSconsumergroups.

B.ThemembersoftheHIGH_CGconsumergroupwouldget10%oftheCPU.

C.TheplanPROD_DB_PLANcanhavesubplans.

D.TheCPUallocationfortheconsumergroupswouldbebasedontheratiodefinedfortheCPU_P1.

Answer:D

148.YouwantanASMinstancetomanagethefilesofyourdatabase.Toachievethisobjective,youspecifythefollowingparametersintheparameterfileofthedatabase:

INSTANCE_TYPE=RDBMS

DB_NAME=PROD

LARGE_POOL_SIZE=8MB

DB_BLOCK_SIZE=4K

LOG_ARCHIVE_DEST=+dgroupA

LOG_ARCHIVE_FORMAT="$ORACLE_SID_%s_%t.%t"

DB_CREATE_FILE_DEST=+dgroupA

COMPATIBLE=10.1.0.2.0

CONTROL_FILES=+dgroupA

WhichparameterwouldbeignoredwhilestartinguptheinstanceforthedatabasePROD?

A.LARGE_POOL_SIZE

B.DB_CREATE_FILE_DEST

C.LOG_ARCHIVE_DEST

D.CONTROL_FILES

E.LOG_ARCHIVE_FORMAT

F.DB_BLOCK_SIZE

Answer:E

149.Youlosttheindextablespaceinyourdatabase.Youdecidedtore-createtheindextablespaceandtheindexesinthetablespace.Whatmethodscanyouusetore-createtheindexes?(Chooseallthatapply.)

A.SQLscripts

B.RecoveryManager(RMAN)script

C.DataPump

D.SQL*Loader

E.Flashbackdatabase

Answer:A,C

150.FromtheV$SESSION_LONGOPSview,youfindthatsomeofthedatabaseusershavelong-runningqueriesthatconsumealotofCPUtime.Thiscausesperformanceproblemsforotherusersinthedatabase,whohavemuchshorterqueries.YouwouldliketomakesurethattheuserswithlargequeriesdonotusealltheCPUtime,butyoustilldonotwanttoterminatethemwithanerrormessage.Whichmethodwouldyoufollowtoachievethis?

A.settheCPUtimepercallintheusersprofile

B.settheCPUtimepersessionintheusersprofiles

C.settheTIMED_STATISTICSparametertoTRUEintheparameterfile

D.settheCPUlevelsfortheusers'groupusingResourceManager

Answer:D

151.YounoticedthatlargememoryallocationsfortheOraclebackupandrestoreoperationsarecausingaperformanceoverheadonthesharedpool.Whichmemorystructurewouldyouconfiguretoavoidthisperformanceoverhead?

A.recyclebuffercache

B.largepool

C.streamspool

D.keepbuffercache

E.redologbuffer

Answer:B

152.InyourAutomaticStorageManagement(ASM)instance,oneofthenonemptydiskgroups,DGROUP1,isnolongerrequiredandyouwantthisdiskgrouptoberemoved.Youexecutethefollowingcommandtoachievethisobjective:

DROPDISKGROUPdgroup1EXCLUDINGCONTENTS;

Whatwouldbetheresultofthiscommand?

A.Thiscommandwouldresultinanerrorbecausethediskgroupisnotempty.

B.Thecommandwoulddistributethecontentsofthespecifieddiskgroupamongallotherdiskgroupsandthendropthespecifieddiskgroup.

C.Thecommandwouldresultinthecontentsbeingmovedtotheparentdiskgroupanddroppingofthediskgroup.

D.ThecommandwouldresultinthediskgroupbeingmarkedasINVALIDbecauseitcannotbedropped.

E.Thecommandwoulddropthediskgroup,ignoringtheEXCLUDINGCONTENTSoption.

Answer:A

153.ViewtheExhibitandexaminethepropertiesoftheUSERStablespace.YouexecutethefollowingstatementtoshrinktheTRANStableexistingontheUSERStablespace:

SQL>ALTERTABLEtransSHRINKSPACECASCADE;

Whichobjectswouldbeaffectedbythiscommand?(Chooseallthatapply.)Exhibit:

A.thematerializedviewsbasedontheTRANStable

B.thematerializedviewslogoftheTRANStable

C.theTRANStable

D.theB*TreeindexesontheTRANStable

E.thelargeobject(LOB)segmentsoftheTRANStable

Answer:C,D

154.YourdatabaseoperatesinARCHIVELOGmodeandallthetablespacesareonline.Duetoausererror,youdecidedtoperformanincompleterecovery.Whichtwotaskswouldyouberequiredtoperformintherecoveryprocess?(Choosetwo.)

A.openthedatabasewiththeRESTRICTEDoption

B.openthedatabasewiththeRESETLOGSoption

C.recovertotherequiredSCNonlythatdatafileinwhichtheerroroccurred

D.recoverallthedatafilestothesamesystemchangenumber(SCN)

Answer:B,D

155.WhichtwostatementsregardingcompressedbackupsinRecoveryManager(RMAN)aretrue?(Choosetwo.)

A.Backupcompressionisdisabledbydefault.

B.Backupcompressioncanbeusedwithbothbackupsetsandimagecopies.

C.BackupcompressioncannotbeenabledusingtheCONFIGUREcommand.

D.BackupcompressionworksonlyiftheCOMPATIBILITYparameterissetto9.0.0.0orhigher.

E.Backupcompressionappliestoonlybackupsets.

F.Backupcompressionappliestoonlyimagecopies.

Answer:A,E

156.YoulostthePRODSTDtablespace,whichwasread-only.Thetablespacewasread-onlywhenthelastbackupwastaken.Howwouldyourecoverthetablespace?

A.restorethetablespacefromthebackup,andthenperformanincompleterecovery

B.restorethetablespacefromthebackup,andthenapplyalltheredoinformation

C.restoreallthedatafilesinthedatabase,andthenperformanincompleterecovery

D.restorethetablespacefromthebackup

Answer:D

157.Thelossofthecontrolfileforcedyoutore-createthecontrolfile.Afterre-creatingitandopeningthedatabase,youfindthatsomeofthedatafilesarenamedasMISSINGnnnnn,wherennnnnisafive-digitnumberstartingwith0.Whatcouldbethepossiblereason?

A.Thesearethedatafilesthatarecorrupted.

B.ThereisnoSYSAUXtablespaceinyourdatabase

C.Thereisaread-onlytablespaceinyourdatabase.

D.Thesearethedatafilesthatcannotberecovered.

Answer:C

158.EverySunday,consistentbackupsareperformedonyourdatabase.Becauseofausererror,youperformedanincompleterecoveryonTuesdayandopenedthedatabasewiththeRESETLOGSoption.AusererroroccursagainonThursday,whichnecessitatesanincompleterecovery.Sunday'sbackupisthemostrecentbackupavailable.Whatwouldyoudointhisscenario?

A.recoverycannotbeperformedbecauseabackupwasnotperformedafterthelastincompleterecovery

B.restoreallthefilesfromSunday'sbackup,andthenrecoveruptothepointintimewhentheRESETLOGSoperationwasperformedonTuesday

C.restoreallthefilesfromSunday'sbackup,andopenthedatabasetoresetthedatabasetothepointintimewhenthebackupwasperformedonSunday

D.restoreallthefilesfromSunday'sbackup,andthenperformanincompleterecoveryuptothepointintimewhentheusererroroccurredonThursday

Answer:D

159.YouexecutedthefollowingFLASHBACKTABLEcommand:

FLASHBACKTABLEempTOTIMESTAMP('11:45','hh12:mi');

Whichtwostatementsarecorrect?(Choosetwo.)

A.TheFLASHBACKTABLEstatementwillnotbewrittentothealertlogfile.

B.TheEMPtablethatwasdroppedbymistakefromthedatabasewillberestored.

C.ThechangesmadetotheEMPtablesincethespecifiedtimewillbeundone.

D.TheFLASHBACKTABLEstatementwillnotmaintaintheexistingindexesontheEMPtable.

E.TheFLASHBACKTABLEstatementwillbeexecutedwithinasingletransaction.

F.ThelistoftransactionsthathavemodifiedtheEMPtablesincethespecifiedtimewillbedisplayed.

Answer:C,E

160.WhichtwostatementsarecorrectregardingtheFlashbackVersionsQueryfeature?(Choosetwo.)

A.Youcanusethisfeaturetoidentifythecommittedversionsoftherows,butnottheuncommittedversions.

B.YoucanusethisfeaturetoidentifytheversionsofV$views.

C.Youcanusethisfeaturetoidentifytheinserts,deletes,andupdatesperformedonaparticularrowbutnotthedatadefinitionlanguage(DDL)operationsperformedonthetable.

D.Youcanusethisfeatureforatableonlyifrowmovementisenabledforthetable.

E.Youcanusethisfeaturetoidentifytheversionsofexternalandfixedtables.

Answer:A,C

161.Thedatabasehasthedatablocksizesetto8KB.Youneedtoimportatablespacewitha4KBblocksizeintothedatabase.Whichadditionalmemoryparameter(s)shouldbeconfiguredtoperformatransportabletablespaceimport?

A.DB_4K_CACHE_SIZEonly

B.DB_8K_CACHE_SIZEonly

C.DB_BLOCK_SIZEandDB_4K_CACHE_SIZE

D.DB_BLOCK_SIZEandDB_8K_CACHE_SIZE

E.SGA_TARGETandDB_4K_CACHE_SIZE

F.DB_CACHE_SIZEonly

Answer:A

162.Youhavecreatedajobclass,CUST_JOB_1,withtwojobs,CUST_JOB_1_AandCUST_JOB_1_B.Whichtwostatementsaretrue?(Choosetwo.)

A.Thememberjobswouldgetdroppedwhenthejobclassisdropped.

B.Boththejobswouldbeexecutedconcurrently.

C.Thememberjobswouldgetdisabledwhenthejobclassisdropped.

D.Theattributesdefinedattheclasslevelwouldbeappliedtoboththejobs.

E.Jobsinthejobclassmusthavebeenassignedthesamepriority.

Answer:C,D

163.Youaremanagingadatabaseforwhichincrementalbackupscanbeverytimeconsuming.Inordertoperformoptimizedincrementalbackupsyouenabletheblockchangetrackingfeature.HowwouldyouinstructRMANtousetheblockchangetrackingfeaturewhenperformingincrementalbackups?

A.YouneedtomentionitwitheveryBACKUPcommand.

B.TheblockchangetrackingfeatureisusedautomaticallybyRMAN.

C.YouneedtoconfigureitusingtheCONFIGUREcommand.

D.YouneedtosetthenecessaryinitializationparameterstodirectRMANtousethefeature.

Answer:B

164.YouconfiguredthelargepoolforOraclebackupandrestoreoperations.Asaresult,whichcomponentwouldrequirelessmemory?

A.streamspool

B.sharedpool

C.logbuffer

D.keepbuffercache

E.recyclebuffercache

Answer:B

165.Youhaveonlytworedologgroupsandthesegroupsgetoverwrittenseveraltimesinaday.YourdatabaseoperatesinNOARCHIVELOGmodeanduser-managedconsistentbackupsareperformedeverySundaynight.OnThursdaymorning,you

findthatanimportanttablehasbeendroppedandpurged.Withreferencetothisscenario,uptowhatpointintimecanthedataberecovered?

A.untilThursdaymorning

B.untilthatpointintimewhenthedatabaseisopened

C.untilthatpointintimewhentherecoveryisperformed

D.untillastSunday'sbackup

E.untilthatpointintimewhenthetableisdroppedandpurged

F.untilWednesdayevening

Answer:D

166.Youareworkingonadatabase,whereyouhavethreeredologgroups.Whenthedatabaseisdownforabackup,anoperatingsystem(OS)userdeletesalltheredologfilesinagroup.Whatwillhappenwhenyouopenyourdatabase?

A.Theinstancestarts,thedatabaseismounted,buteffortstoopenthedatabasefail,andanerroraboutthemissingredologgroupisdisplayed.

B.Beforetheinstancestarts,youreceiveanerroraboutthemissingredologfilesofagroup.

C.Theinstancestartsandthedatabaseopenswithanerrormessagewrittentothealertlogfile.

D.Theinstancestartsandthedatabaseopensbecausetworedologgroupsstillexist.

E.Theinstancestartsandthedatabaseopens,buteveryattempttowritetoredologfilesfailswithanerror.

Answer:A

167.Inyourdatabase,allthetablespacesarelocallymanaged.YoustartedRecoveryManager(RMAN)usingrecoverycatalog.Thefollowingcommandsareusedintheprocessofrecoveringthedatabasebyusingthebackupcontrolfile:

1.RESTORECONTROLFILE;

2.RESTOREDATABASE;

3.ALTERDATABASEMOUNT;

4.SQLALTERTABLESPACEtempADDTEMPFILE

5.ALTERDATABASEOPENRESETLOGS;

6.RECOVERDATABASE;

7.STARTUPNOMOUNT;

Inwhatsequencewouldyouusethisprocesstoperformtherecovery?

A.2,7,3,5,1,6,4

B.2,1,7,6,3,5,4

C.7,1,3,2,6,5,4

D.7,2,3,1,4,6,5

Answer:C

168.YouareworkingonanOracleDatabase10gdatabasethatoperatesintheARCHIVELOGmode.At06:00p.m.,youdiscoveredthatatableintheSYSTEMtablespacethatdoesnotbelongtothedatadictionarywasdroppedat03:00p.m.Whatwouldyoudotorecoverthetable?

A.usetheFlashbackTransactionQueryfeaturetoidentifytherelevantSQLstatementanduseittoundropthetable

B.restoretheentiredatabasefromthemostrecentbackupandopenit

C.recoverthetablebyusingtheFlashbackTablefeature

D.performpoint-in-timerecoverytorecoverthetable

Answer:D

169.TheEMPLOYEEStableisstoredintheUSERStablespace.YouneedtocheckiftheEMPLOYEEStableisaffectedbytheblockcorruptionfoundintheUSERStablespace.Whichoptionwouldyouuse?

A.theRMANLISTcommand

B.theDBNEWIDutility

C.theRMANREPORTcommand

D.theRMANBLOCKRECOVERcommand

E.theRMANCROSSCHECKcommand

F.theANALYZEcommand

Answer:F

170.Amediafailurehasoccurred.Thishasresultedinallthemembersofthenextloggroupbeingrenderedinaccessibletothelogwriterprocess(LGWR)atalogswitch.Howdoesthisfailureaffecttheoperationaldatabase?

A.Thedatabaseallowsonlyqueries;nootherstatementsareallowed.

B.Thedatabasere-createsthemissingredologfilesautomatically.

C.Thedatabasecontinuestofunctionnormallywiththeexistingfiles.

D.Thedatabasereturnsanerrorandthedatabaseinstanceshutsdown.

E.Theusersessionsthatgenerateredologsareterminatedautomatically.

Answer:D

171.Verysoonyouwillbeperformingmaintenanceoperations.Youwouldhaveseveraljobstorunassoonasthemaintenanceperiodstarts.Whichmethodwouldyouusetocreatejobswithoutspecifyingthetimeperiodwhenthejobshouldberun?

A.useDBMS_IJOBpackage

B.useOracleScheduler

C.useDBMS_JOBpackage

D.useOracleDataPumpExportandImport

Answer:B

172.YouenabledAutomaticSharedMemoryManagement.Theinitializationparametersaresetasshownbelow:

SGA_TARGET=10GB

SGA_MAX_SIZE=14GB

STREAMS_POOL_SIZE=1GB

SHARED_POOL_SIZE=3GB

Whichtwostatementsarecorrectinthisscenario?(Choosetwo.)

A.Atotalof14GBmemorywillbeallocatedtotheautomaticallytunedmemorycomponents.

B.ReducingthevalueforSGA_TARGETto9GBwillautomaticallydecreasethememoryallocatedtosharedpoolfrom3GBto2GB.

C.ThevalueforSGA_TARGETcanbeincreaseduptoamaximumof14GB.

D.Amaximumof3GBcanbeallocatedtosharedpool.

E.IncreasingthevalueforSGA_TARGETto12GBwillautomaticallyincreasethememoryallocatedtoautotunedparameters.

F.IncreasingthevalueforSGA_TARGETwillautomaticallyincreasethememoryallocatedforSTREAMS_POOL_SIZE.

Answer:C,E

173.YouneedtocreateaschedulethatwillrunajobonthesecondFridayofeachmonth.Whatshouldtherepeatintervaloftheschedulebesetto?

A.FREQ=MONTHLY;BYDAY=2FRI;

B.FREQ=MONTHLY;BYDAY=FRI(2);

C.FREQ=MONTHLY;BYDAY=FRI2;

D.FREQ=MONTHLY;BYDAY=-2FRI;

Answer:A

174.Youwanttocreateaconsumergroup,GROUP1,andyouexecutethefollowingcommandinthecommand-lineinterface:

SQL>EXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP

(CONSUMER_GROUP=>'group1',COMMENT=>'NewGroup');

Thiscommanderrorsoutdisplayingthefollowingmessage:

ERRORatline1:

ORA-29371:pendingareaisnotactive

ORA-06512:at"SYS.DBMS_RMIN",line115

ORA-06512:at"SYS.DBMS_RESOURCE_MANAGER",line108

ORA-06512:atline1

Whatactionwouldyoutaketoovercomethiserror?

A.activatethePendingAreabeforecreatingtheconsumergroup

B.createthePendingAreabeforecreatingtheconsumergroup

C.increasethesizeofthedatabasebuffercachetoaccommodatethePendingArea

D.increasethesizeofthesharedpooltoaccommodatethePendingArea

E.increasethesizeofthelargepooltoaccommodatethePendingArea

Answer:B

175.Youhavearead-onlytablespaceonread-onlymedia.Youwanttoperformamediarecoveryontheexistingdatafiles,butusingabackupcontrolfile.Thebackupcontrolfileindicatesthatthestatusoftheread-onlytablespacewasread/writewhenthecontrolfilewasbackedup.Whatshouldyouconsider?

A.takedatafilesfromtheread-onlytablespaceofflinebeforeperformingarecovery

B.recoveryusingbackupcontrolfileisnotpossible,sorestoreallthefilesfromthelastfulldatabasebackup,andthenopenthedatabase

C.droptheread-onlytablespaceandre-createthetablespaceafterrecovery

D.performarecovery;statusofthetablespaceincontrolfilewillbechangedautomatically

Answer:A

176.YourproductiondatabaseisrunningintheARCHIVELOGmodeandtheARCnprocessisfunctional.Youhavetwoonlineredologgroups.Whichthreebackgroundprocesseswouldbeinvolvedwhenalogswitchhappens?(Choosethree.)

A.logwriter

B.archival

C.processmonitor

D.systemmonitor

E.changetrackingwriter

F.databasewriter

Answer:A,B,F

177.OnMonday,youdroppedtheDEPTtablefromyourschemaandthenyoure-createdtheDEPTtableinyourschema.OnWednesday,youhavearequirementtorestoretheDEPTtablefromtherecyclebin.Whichstatementiscorrect?

A.YoucannotrestoretheDEPTtablebyusingtheOracleFlashbackDropfeaturebecauseatablewiththenameDEPTalreadyexistsinyourschema.

B.YoucanrestoretheDEPTtablebyusingtheOracleFlashbackDropfeature,providedyouusetheRENAMETOclause.

C.YoucannotrestoretheDEPTtablebyusingtheOracleFlashbackDropfeaturebecausethecontentsoftherecyclebinarepurgedevery12hoursbydefault.

D.YoucanrestoretheDEPTtablebyusingtheOracleFlashbackDropfeatureandasystem-generatednamewillbeassignedtotherestoredtable.

Answer:B

178.YouhaveanAutomaticStorageManagement(ASM)instancemanagingthedatabasefilesofyourproductiondatabase.ThedatabasecontainsASMfilesandnon-ASMfiles.UsingRecoveryManager(RMAN),youmigratethecompleteproductiondatabasetousetheASMinstance.Whichstatementistrue?

A.RMANwouldrelocateallthedatafilestoanASMdiskgroupandotherfilestoanoperatingsystemlocation,definedusingOracleManagedFiles(OMF).

B.RMANwouldrelocatetheASMfilestoanASMdiskgroupandthenon-ASMfilestoanoperatingsystemlocation,definedusingOMF.

C.RMANwouldrelocateallthedatabasefilestoanASMdiskgroup.

D.RMANwouldchangethefiledefinitionsinthecontrolfiletousetheASMbutwouldnotrelocatethedatabasefilesphysically.

Answer:C

179.ThebackupretentionpolicyisconfiguredasRECOVERYWINDOW2.YouexecutedthefollowingcommandinRecoveryManager(RMAN)againstyourdatabase:

RMAN>REPORTOBSOLETE;

Whatwouldyouseeintheoutput?

A.alistofallthosefilesthathavebeendeletedinthelasttwodays

B.alistofallthosefilesthathavebeenrecoveredwithinthelasttwodays

C.alistofalltheexpiredbackupsandcopies

D.alistofbackupsandcopiesthatareoutsidetherangecoveredbythecurrentretentionpolicy

Answer:D

180.YouareworkingonOracleDatabase10g,whichisinARCHIVELOGmode.Allthearchivedlogfilesareintact.InwhichscenariowouldperformingarecoveryrequiretheopeningofthedatabasewiththeRESETLOGSoption?

A.lossofoneofthetablespaces

B.lossofasystemdatafile

C.lossofoneofthecontrolfiles

D.lossofatempfile

E.lossoftheonlymemberofanunarchivedredologgroup

F.lossofamemberfromeachredologgroup

Answer:E

181.ViewtheExhibit.YouexecutedthefollowingcommandtoperformabackupoftheUSERStablespace:

RMAN>BACKUPTABLESPACEUSERS;

Whichthreetypesoffilesarebackedup?(Choosethree.)

Exhibit:

A.allthedatafilesbelongingtotheUSERStablespace

B.passwordfile

C.onlineredologfiles

D.thecurrentcontrolfile

E.archivedredologfiles

F.thecurrentserverparameterfile

G.datafilesbelongingtotheUSERStablespaceandallthedefaulttablespaces

Answer:A,D,F

182.Inwhichtwoconditionsareresumablestatementssuspended?(Choosetwo.)

A.whenauserexceedsthespacequota

B.whenausersessionisterminated

C.whenatablethatisbeingaccessedbythecurrenttransactionisnotfound

D.whenausermanuallysuspendsthestatement

E.whenthemaximumextentsofasegmentisreached

Answer:A,E

183.YouareconnectedtoRecoveryManager(RMAN)withoutarecoverycatalog.Thereisnocopyofthecontrolfileavailable.Youwanttorestorethecontrolfilefromanautobackup.Toretrievetheautobackup,youneedthedatabaseID(DBID).InwhichtwosourceswouldyoufindtheDBID?(Choosetwo.)

A.thealertlogfile

B.theserverparameterfile

C.theformattednameofacontrolfileautobackup

D.anRMANsessionlogfile

E.thetracefile

Answer:C,D

184.YouexecutedthefollowingcommandinRecoveryManager(RMAN)toperformabackupoftheDETTBStablespace:

RMAN>BACKUPTABLESPACEDETTBS;

Underwhichconditionswouldthiscommandexecutesuccessfully?(Chooseallthatapply.)

A.ThedatabaseisinNOMOUNTstate.

B.ThedatabaseisinNOARCHIVELOGmodeandthetablespaceisonline.

C.ThedatabaseisinNOARCHIVELOGmodeandthetablespaceisoffline.

D.ThedatabaseisinARCHIVELOGmodeandthetablespaceisoffline.

E.ThedatabaseisinARCHIVELOGmodeandthetablespaceisonline.

Answer:C,D,E

185.IdentifyfourusesoftheOracleScheduler.(Choosefour.)

A.enablesOracledatabasetoschedulewhichprocessesexecuteonwhichprocessorsinamultipleCPUenvironment

B.enablesOracledatabasetodopatchesaccordingtoaDBA-definedschedule

C.enablesyoutoscheduletheexecutionofjobsbasedontime

D.enablesyoutoexecutejobsinaclusteredenvironment

E.enablesyoutoperiodicallyexecuteoperatingsystemscriptfileslocatedonthesameserverasthedatabase

F.enablesyoutocreateajobthatmakesuseofsavedprogramsandschedules

G.enablesyoutoautomatethemanagementofthejobsthatarecreatedusingtheDBMS_JOBpackage

Answer:C,D,E,F

------------------------------------------------------------------------------

Blog:http://blog.youkuaiyun.com/tianlesoftware

网上资源:http://tianlesoftware.download.youkuaiyun.com

相关视频:http://blog.youkuaiyun.com/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1群:62697716();DBA2群:62697977()

DBA3群:63306533;聊天群:40132017

<!--EndFragment-->
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值