34、WhichtwocanbebackedupbyusingRMANwhenadatabaseIsopeninARCHIVELOGmode,sothatmediarecoverycanbeperformedIfrequired?A)controlfilesB)passwordfileC)pfileD)onlineredologsE)flashbacklogsF)datafilesAnswer:A
33、WhereIsbackupmetadatastoredforusebyRecoveryManager(RMAN)?A)InthecontrolfileB)IntheSYSAUXtablespaceC)intheSPFILED)intheSYSTEMtablespaceE)InthediagnosticdestinationfliesAnswer:A
32、Examinethesecommandsandtheiroutput:•SQL>SELECT*FROMemp;•ENOENAME•---------•100Adam•101Alan•SQL>INSERTINTOempVALUES(102,'Ben");•1rowcreated.•SQL>COMMIT;•Commitcompleted.•SQL>UPD
31、WhichtwoeventsalwaysrequesttheLGWRtowrite?A)whenLGWRisnotifiedbyaserverprocessthatperformsaCommitorROLLBACKB)WhenPMONrestartsaserverprocessC)whenDBWnwritesdirtybuffersD)whenalogswitchoccursE)whenac
30、Whichistruewhenadatabaseinstanceisshutdown?A.Onlytransactionalandnormalmodeswaitforalluncommittedtransactionstocommitorrollbackandthenclosethedatabase.B.Immediate,transactional,andnormalmodesallres
29、Inoneofyourdatabases:ThedatabasedefaulttablespaceisEXAMPLE.Deferred_segment_creationisfalse.Examinethesecommands:SQL>createuseruser1identifiedbyoracle_4upasswordexpire;Usercreated.SQL>alterus
28、Whichtwoaretrueaboutexternaltables?A.TheysupporttheORACLE_DATAPUMPaccessdriver.B.Theyhaveextents.C.TheysupportallDMLoperations.D.TheycanalwaysbeupdatedusingSQL.E.TheycanbestoredinanASMClusterFileSy
27、Examinethesefactsaboutadatabase:USERSisthedatabasedefaulttablespace.USER1,USER2,ANDUSER3havetheCREATESESSIONprivilege.TheyalsohaveUNLIMITEDQUOTAonthedefaulttablespaceUSERS.Theyhavenootherprivileges
26、InwhichstatecanyoubackupadatabaseinARCHIVELOGMODEusingRMAN?A.NOMOUNT,MOUNT,ANDOPENB.NOMOUNTANDMOUNTONLYC.OPENONLYD.MOUNTANDOPENONLYE.OPENRESTRICTEDONLYCorrectAnswer:D
25、Whichistrueaboutlogicalandphysicaldatabasestructures?(Choosethebestanswer)•A.Anundotablespacehasatempfileinsteadofadatafile.•B.Asegmentcanconsistofextentsofdifferentsizes.•C.Apermanenttablespacecan
24、YOURDB_RECOVERY_FILE_DEST_SIZEIs8G.Currently,5GofthespaceIsusedofwhich4Gconsistsofobsoletebackups.Youexecutethiscommand:SQL>ALTERSYSTEMSETdb_recovery_file_dest_size=2G;Whatistheoutcome?A)Itchang
23、Whichtwoaretrueaboutdatadictionaryanddynamicperformanceviews(v$views)?A)AlldatabaseusershaveaccesstoALL_*views.B)Datadictionaryviewoutputissubjecttoreadconsistency.C)ThedefiningqueriesforOraclesupp
22、YouareplanningasoftwareinstallationforbothOracleDatabase11gRelease1andRelease2.YouplantohaveatleaseonedatabaseforeachreleasemanagedbyGridInfrastructureforaStandaloneServer.Whichthreearetrueinthissc
OCP认证考试052新加的考试题和答案整理-第21题
20、 Which is true about the SYSTEM and SYSAUX tablespaces? A) The SYSAUX tablespace can be made read-only but the SYSTEM tablespace cannot. B) Both tablespaces can be used for temporary storage if no temporary tablespace is defined.
19、WhichistrueaboutinvalidPL/SQLobjects?A)Theyareautomaticallyrecompiledagainstthenewdefinitionofareferencedobjectatthesametimeasthereferencedobjectismodified.B)TheycanbemanuallyrecompiledonlybyusingS
18、YouwanttoInstallOracle11gdatabasesoftwareandcreateadatabaseonASMImmediatelyaftertheInstall.YourplanistoinstallbothOracledatabaseandGridInfrastructure.Whichtwoaretrueinthisscenario?A)GridInfrastruct
17、Whichtwostatementsaretrueabouttablespaces?A)Adatabasecancontainmultipleundotablespaces.B)Adatabasecancontainonlyasingletemporarytablespace.C)AdatabaseinstancestoresundodataIntheSYSTEMtablespaceIfno
【OCP|052】052最新考试题库及答案整理-1【OCP|052】052最新考试题库及答案整理-2【OCP|052】052最新考试题库及答案整理-3【OCP|052】052最新考试题库及答案整理-4【OCP|052】052最新考试题库及答案整理-5【OCP|052】052最新考试题库及答案整理-6【OCP|052】052最新考试题库及答案整理-7【OCP|052】052最新考试题库及答案整理-8
15、Whichtwoaretrueaboutspacemanagementintablespaces?A)LocallymanagedtablespaceshaveeitherASSMormanualsegmentspacemanagement(MSSM),andallthesegmentsinthesetablespacesaremanagedonewayortheother.B)Locall
14、Whichcommandisusedtodisplayfilesthatnolongerconformtothebackupretentionpolicy?A)REPORTOBSOLETEB)SHOWDATAFILEBACKUPCOPIESC)CROSSCHECKBACKUPD)LISTEXPIREDBACKUPAnswer:A
13、WhichtwoaretrueaboutAWRsnapshots?A)TheyarestoredIntheSYSAUXtablespace.B)TheyarenotgeneratedifSTATISTICS_LEVELIssettoTYPICAL.C)TheycanbemodifiedbyusingDMLs.D)Theycanberetainedforever.E)Theyarealways
12、WhichtwotypesofInformationcanbefoundinthealertlog?A)instancerecoverydetailsB)arecordofallDDLstatementsperformedbynon-DBAusersC)arecordofallactionsperformedbySYSandSYSTEMD)criticalerrorsencounteredb
11、WhichthreearetrueaboutUNDOdata?A)Itisusedtorollbackfailedtransactions.B)ItisusedtorewindadatabasebyusingFLASHBACKDATABASE.C)ItisusedtorecoverdroppedtablesbyusingFLASHBACKTABLE…TOBEFOREDROP.D)Itisus
10、Whichtwoaretrueaboutconsistentdatabasebackups?A)TheycanonlybetakenwhenaRECOVERYCATALOGisused.B)TheycanonlybetakenifthedatabaseIsinARCHIVELOGmode.C)TheycanonlybetakenIfshutdownNORMAL,TRANSACTIONAL,o
9、WhichistrueabouttheAutomaticDiagnosticRepository(ADR)?A)Itincludesdiagnosticdataforcriticalerrorsforeachserverandbackgroundprocess.B)ItslocationisalwayssetbytheORACLE_BASEvariable.C)Itisusedonlyifth
8、WhichtwoaretrueabouttheFastRecoveryArea(FRA)?A)Itshouldbelargerthanthedatabase.B)SpacemanagementIntheFRAIsInfluencedbythedatabasebackupretentionpolicy.C)AdatabasemustbeinARCHIVELOGmodetousetheFRA.D)
7、Whichistrueaboutexternaltables?A)TheORACLE_DATAPUMPaccessdrivercanbeusedtowritedatatoexternaltables.B)Segmentsareallocatedforexternaltables.C)Theydonotsupportpartitioning.D)TheymayhaveIndexes.E)DMLo
6、YouareinstallingOracleGridInfrastructurebyusingtheOracleUniversalInstaller(OUI).Youselectthe"InstallandConfigureGridInfrastructureforaStandaloneServer"option.WhichtaskisperformedbyOUIaspar
5、Whichtwoaffectthetimetakenforinstancerecovery?A)sizeofredologsB)sizeofUNDOtablespaceC)FAST_START_MTTR_TARGETvalueD)sizeofarchivelogsE)sizeofexistingRMANbackupsetsF)UNDO_RETENTIONvalueAnswer:AC
Copyright © 2005-2025 51CTO.COM 版权所有 京ICP证060544号
