YouexecutethefollowingRecoveryManager(RMAN)commandsinhefollowingorder:BACKUPVALIDATEDATABAERECOVERCORRUPTIONLIST;Whichtwotasksareperformedbythesecommands?()
A. Repairthecorruptedblocks.Ifany.Inthebackupcreated
B. PopulateVSCOPV_CORRUPTIONwithnamesoffilesthathavecorruptedblocks
C. Backupthedatabaseaftercheckingwhetherarrayofthefileshavecorruptedblocks
DiscoveranycorruptblocksthatareviewablewiththeVSDATABASE_BI-OCK_CORBUPTIONview
E. RepairallcorruptedblocksthathavebeenloggedintheVSDATABASE_BLOCK_CORRUPTION
查看答案
YouhaveincludedthefollowingparametersettingsinyourSPFILE:SGA_MAX_SIZE=8GSGA_TARGET=6GDB_CACHE_SIZE=2GSHARED_POOL_SIZE=1GLOG_BUFFER=64MDB_KEEP_CACHE_SIZE=960MWhichstatementistrueifyoumodifytheSGA_TARGETinitializationparameter?()
A. TheSGA_TARGETinitializationparametercannotbesettoavaluegreaterthan8G
B. TheDB_CACHE_SIZEinitializationparametercannotbesettoavaluelessthan2G
C. TheDB_CACHE_SIZEinitializationparametercannotbesettoavaluegreaterthan2G
D. TheDB_KEEP_CACHE_SIZEinitializationparametercannotbesettoavaluegreaterthan960M
E. TheDB_KEEP_CACHE_SIZEinitializationparametercannotbesettoavaluelessthan960M
How many different calendars does Oracle 11g support?()
A. 22
B. 7
C. 6
D. 15
E. 2
YouworkasadatabaseadministratorforSupportcenter.cn.InyourOracledatabase10ginstallationyouhavesetORACLE_BASEto/u01/app/oracle.Whichobjectivewillbeachievedbythissetting?()
A. TheOraclekernelwillbeplacedinthislocation.
B. TheOraclesoftwarewillbeplacedinthislocation.
C. Theserverparameterfile(SPFILE)willbeplacedinthislocation.
D. Thedatabasefileswillbeplacedinthislocation,ifnotspecifiedexplicitly.
E. ThelocationwillbeconsideredforthebaseofOracleManagedFiles(OMF).
F. ThelocationwillbeconsideredforthebaseofOptimalFlexibleArchitecture(OFA).
YouworkasadatabaseadministratorforSupportcenter.cn.Inyourproductiondatabase,thesizeofDatabaseBufferCacheneedstobeincreasedimmediatelyforthecurrentaswellasfutureinstancesofthedatabase.TheOracleinstancehasbeenconfiguredtoaccommodateanychangesinthesizeofthememorystructures.Atthisisproductiondatabase,youwanttoaccomplishthistaskwithnoimpactontheuser’sconnections.Whichactivitymustyouhavecompletedbeforeaccomplishingthistask?()
A. Youmusthavestartedthedatabaseinstanceinrestrictedmode.
B. YoumusthavestartedthedatabaseinstanceinNORMALmode.
C. Youmusthavestartedthedatabaseinstancewithserverparameterfile.
D. Youmusthavestartedthedatabaseinstancebutmustnothavemounted.
E. Youmusthavestartedthedatabaseinstancebutmustnothaveopened.