OCP认证考试052最新考试题库解析-20180518

2018年OCP052最新考试题库解析-20180518题库新特点：更加灵活，题库的顺序与考试时的顺序每场都在变化更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案整理：CUUG2018年OCP052最新考试题库解析-20180518•1、.WhichtwoaretrueabouttheArchive(ARCn)processes?•❑A)Theyautomaticallydeleteobsoletearchivelogstomakespacefornewarchivelogs.•❑B)TheyareusedduringInstancerecovery.•❑C)Theyarchiveredodirectlyfromtheredologbuffer.•❑D)TheyareenabledonlywhenthedatabaseIsInARCHTVELOCmode.•❑E)Theycreatearchivelogsaftereverylogswitch.••Answer:DE•2018年OCP052最新考试题库解析-20180518•2、WhichtwoaretrueaboutOptimizerStatistics?•❑A)TheydonotpersistacrossInstancerestarts.•❑B)TheyareautomaticallyupdatedwhenDDLstatementsexecute.•❑C)TheyaregatheredbytheManageabilityMonitor(MMON)backgroundprocess.•❑D)TheycanbegatheredbyexecutingthePL/SQLproceduresintheDBMS_STATSpackage.•❑E)Theycanbeusedtodeterminetheeventsonwhichadatabaseinstancewaited.•❑F)TheyprovideInformationtotheOptimizersothatitcandetermineoptimalexecutionplansforSQLstatements.••Answer:DF2018年OCP052最新考试题库解析-20180518•3、Whichstructurecanspanmultipledatafiles?•❑A)apermanenttablespace•❑B)abigfiletablespace•❑C)atemporarytablespace•❑D)asegment•❑E)anextent••Answer:ACD•2018年OCP052最新考试题库解析-20180518•4、Forwhichrequirementshouldyouconfiguresharedservers?•❑A)accommodatinganincreasingnumberofuserswhorunshort-duration,infrequentqueriesinanOLTPenvironmentwithlimitedmemory•❑B)accommodatinganincreasingnumberofuserswhorunanalyticalqueriesinaDSSenvironmentwithlimitedmemory•❑C)submittingbackupjobsatregular,24-hourIntervalsinanOLTPenvironmentwithlimitedmemory•❑D)performingbulk-loadoperationsinaDSSenvironmentwithlimitedmemory•❑E)usingRecoveryManager(RMAN)torecoveradatabase••Answer:A2018年OCP052最新考试题库解析-20180518•5、Whichtwoaffectthetimetakenforinstancerecovery?•❑A)sizeofredologs•❑B)sizeofUNDOtablespace•❑C)FAST_START_MTTR_TARGETvalue•❑D)sizeofarchivelogs•❑E)sizeofexistingRMANbackupsets•❑F)UNDO_RETENTIONvalue••Answer:AC2018年OCP052最新考试题库解析-20180518•6、YouareinstallingOracleGridInfrastructurebyusingtheOracleUniversalInstaller(OUI).•YouselecttheInstallandConfigureGridInfrastructureforaStandaloneServeroption.•WhichtaskisperformedbyOUIaspartofthisinstallation?•❑A)creationandconfigurationofEnterpriseManagerCloudControlontheserver•❑B)creationofprivilegedoperatingsystemgroupsthatareusedforOSauthentication•❑C)creationofageneralpurposedatabase•❑D)creationofanASMdiskgroupandregistrationofASMcomponentswithOracleRestart••Answer:D2018年OCP052最新考试题库解析-20180518•7、Whichistrueaboutexternaltables?•❑A)TheORACLE_DATAPUMPaccessdrivercanbeusedtowritedatatoexternaltables.•❑B)Segmentsareallocatedforexternaltables.•❑C)Theydonotsupportpartitioning.•❑D)TheymayhaveIndexes.•❑E)DMLoperationsmaybeperformedonexternaltables.••Answer:C•2018年OCP052最新考试题库解析-20180518•8、WhichtwoaretrueabouttheFastRecoveryArea(FRA)?•❑A)Itshouldbelargerthanthedatabase.•❑B)SpacemanagementIntheFRAIsInfluencedbythedatabasebackupretentionpolicy.•❑C)AdatabasemustbeinARCHIVELOGmodetousetheFRA.•❑D)Itmustresideonthesamefilesystemasthedatabasedatafiles.•❑E)OnlyconsistentbackupscanbestoredintheFRA.••Answer:AB•2018年OCP052最新考试题库解析-20180518•9、WhichistrueabouttheAutomaticDiagnosticRepository(ADR)?•❑A)Itincludesdiagnosticdataforcriticalerrorsforeachserverandbackgroundprocess.•❑B)ItslocationisalwayssetbytheORACLE_BASEvariable.•❑C)ItisusedonlyiftheDIAGNOSTIC_DESTparameterismanuallyconfigured.•❑D)Itonlycontainsthealertlogandtracefilesforbackgroundprocesses.••Answer:A2018年OCP052最新考试题库解析-20180518•10、Whichtwoaretrueaboutconsistentdatabasebackups?•❑A)TheycanonlybetakenwhenaRECOVERYCATALOGisused.•❑B)TheycanonlybetakenifthedatabaseIsinARCHIVELOGmode.•❑C)TheycanonlybetakenIfshutdownNORMAL,TRANSACTIONAL,orIMMEDIATEshutdownhasbeenperformedandthebackupistakenbeforethedatabaseisreopened.•❑D)TheycanonlybetakenbyusingRMANcommands.•❑E)TheycanonlybetakenbyusingRMANwhenthedatabaseisinMOUNTstate.••Answer:CE2018年OCP052最新考试题库解析-2018051811、WhichthreearetrueaboutUNDOdata?❑A)Itisusedtorollbackfailedtransactions.❑B)ItisusedtorewindadatabasebyusingFLASHBACKDATABASE.❑C)ItisusedtorecoverdroppedtablesbyusingFLASHBACKTABLE…TOBEFOREDROP.❑D)ItisusedtoenableROLLBACKstatementstorollbackuncommittedupdates.❑E)Itisusedtoprovidereadconsistency.❑F)Itisusedduringonlinebackupstoguaranteetheirconsistency.Answer:ADE2018年OCP052最新考试题库解析-2018051812、WhichtwotypesofInformationcanbefoundinthealertlog?❑A)instancerecoverydetails❑B)arecordofallDDLstatementsperformedbynon-DBAusers❑C)arecordofallactionsperformedbySYSandSYSTEM❑D)criticalerrorsencounteredbybackgroundprocesses❑E)valuesofallInitializationparameterswheneveranInstanceIsrestartedAnswer:AD2018年OCP052最新考试题库解析-2018051813、WhichtwoaretrueaboutAWRsnapshots?❑A)TheyarestoredIntheSYSAUXtablespace.❑B)TheyarenotgeneratedifSTATISTICS_LEVELIssettoTYPICAL.❑C)TheycanbemodifiedbyusingDMLs.❑D)Theycanberetainedforever.❑E)Theyarealwayscreatedautomatically.Answer:AD2018年OCP052最新考试题库解析-2018051814、Whichcommandisusedtodisplayfilesthatnolongerconformtothebackupretentionpolicy?❑A)REPORTOBSOLETE❑B)SHOWDATAFILEBACKUPCOPIES❑C)CROSSCHECKBACKUP❑D)LISTEXPIREDBACKUPAnswer:A2018年OCP052最新考试题库解析-201805