单项选择题

Whatdoestheoutputonthisreportindicate？（）RMAN>reportneedbackup；RMANretentionpolicywillbeappliedtothecommandRMANretentionpolicyissettoredundancy1Reportoffileswithlessthan1redundantbackupsFilebkpsName50C：/ORACLE/ORADATA/ORCL/MY_DATA_01.DBF
A.Themy_data_01.dbfdatafileiscorruptedandneedstoberestored.
B.Themy_data_01.dbfdatafilehasnotyetbeenbackedup.Thisreportdoesnotimplythatthedatainthedatafilecannotberecovered.
C.Themy_data_01.dbfdatafilehasnotyetbeenbackedup.Thisreportimpliesthatthedatainthedatafilecannotberecovered.
D.Themy_data_01.dbfdatafilenolongermeetstheretentioncriteriaforbackups.
E.Datafile5ismissing.

A.DBF
A.Themy_data_01.dbfdatafileiscorruptedandneedstoberestored.
B.Themy_data_01.dbfdatafilehasnotyetbeenbackedup.Thisreportdoesnotimplythatthedatainthedatafilecannotberecovered.
C.Themy_data_01.dbfdatafilehasnotyetbeenbackedup.Thisreportimpliesthatthedatainthedatafilecannotberecovered.
D.Themy_data_01.dbfdatafilenolongermeetstheretentioncriteriaforbackups.
E.Datafile5ismissing.

你可能感兴趣的试题

单项选择题

YouareusinganAutomaticStorageManagement（ASM）instancetomanagethedatabasefilesofyourproductiondatabase.AfteraddinganewdiskgrouptotheASMinstance，youexecutethefollowingcommand：ALTERDISKGROUPdg3REBALANCEPOWER0；Whatwouldbetheresultofthiscommand？（）
A.Therebalancingofthediskgroupwouldbestopped.
B.Therebalancingofthediskgroupwouldbecompletedasfastaspossible.
C.ThecommandwouldresultinanerrorbecausethevalueofPOWERcannotbe0.
D.TherebalancingofthediskgroupwouldbecompletedwithoutaffectingthediskgroupDG3.
E.Thecommandwouldresultinanerrorbecausethediskgroupscannotbemanuallyrebalanced.

A.AfteraddinganewdiskgrouptotheASMinstance，youexecutethefollowingcommand：ALTERDISKGROUPdg3REBALANCEPOWER0；Whatwouldbetheresultofthiscommand？（）
A.Therebalancingofthediskgroupwouldbestopped.
B.Therebalancingofthediskgroupwouldbecompletedasfastaspossible.
C.ThecommandwouldresultinanerrorbecausethevalueofPOWERcannotbe0.
D.TherebalancingofthediskgroupwouldbecompletedwithoutaffectingthediskgroupDG3.
E.Thecommandwouldresultinanerrorbecausethediskgroupscannotbemanuallyrebalanced.

单项选择题

YoufindthatthedatabaseperformancedegradeswhileyoubackupthePRODdatabaseusingRecoveryManager（RMAN）.ThePRODdatabaseisrunninginsharedservermode.Thedatabaseinstanceiscurrentlyusing60%oftotaloperatingsystemmemory.Yoususpectthesharedpoolfragmentationtobethereason.Whichactionwouldyouconsidertoovercometheperformancedegradation？（）
A.ConfigureJavaPooltocachethejavaobjects.
B.ConfigureStreamsPooltoenableparallelprocessing.
C.IncreaseSharedPoolsizetocachemorePL/SQLobjects.
D.IncreaseDatabaseBufferCachesizetoincreasecachehits.
E.ConfigureLargePooltobeusedbyRMANandsharedserver.
F.IncreasethetotalSystemGlobalArea（SGA）sizetoincreasememoryhits.

A.ThePRODdatabaseisrunninginsharedservermode.Thedatabaseinstanceiscurrentlyusing60%oftotaloperatingsystemmemory.Yoususpectthesharedpoolfragmentationtobethereason.Whichactionwouldyouconsidertoovercometheperformancedegradation？（）
A.ConfigureJavaPooltocachethejavaobjects.
B.ConfigureStreamsPooltoenableparallelprocessing.
C.IncreaseSharedPoolsizetocachemorePL/SQLobjects.
D.IncreaseDatabaseBufferCachesizetoincreasecachehits.
E.ConfigureLargePooltobeusedbyRMANandsharedserver.
F.IncreasethetotalSystemGlobalArea（SGA）sizetoincreasememoryhits.