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