OCP认证考试052最新考试题库解析-20180518PPT课件.pptx

2018年OCP052最新考试题库解析 20180518 题库新特点 更加灵活 题库的顺序与考试时的顺序每场都在变化 更加考验知识点的掌握 题库答案为二 考试时要求选择最佳一个答案整理 CUUG 1 2018年OCP052最新考试题库解析 20180518 1 WhichtwoaretrueabouttheArchive ARCn processes A Theyautomaticallydeleteobsoletearchivelogstomakespacefornewarchivelogs B TheyareusedduringInstancerecovery C Theyarchiveredodirectlyfromtheredologbuffer D TheyareenabledonlywhenthedatabaseIsInARCHTVELOCmode E Theycreatearchivelogsaftereverylogswitch Answer DE 2 2020 3 25 2018年OCP052最新考试题库解析 20180518 2 WhichtwoaretrueaboutOptimizerStatistics A TheydonotpersistacrossInstancerestarts B TheyareautomaticallyupdatedwhenDDLstatementsexecute C TheyaregatheredbytheManageabilityMonitor MMON backgroundprocess D TheycanbegatheredbyexecutingthePL SQLproceduresintheDBMS STATSpackage E Theycanbeusedtodeterminetheeventsonwhichadatabaseinstancewaited F TheyprovideInformationtotheOptimizersothatitcandetermineoptimalexecutionplansforSQLstatements Answer DF 3 2020 3 25 2018年OCP052最新考试题库解析 20180518 3 Whichstructurecanspanmultipledatafiles A apermanenttablespace B abigfiletablespace C atemporarytablespace D asegment E anextent Answer ACD 4 2020 3 25 2018年OCP052最新考试题库解析 20180518 4 Forwhichrequirementshouldyouconfiguresharedservers A accommodatinganincreasingnumberofuserswhorunshort duration infrequentqueriesinanOLTPenvironmentwithlimitedmemory B accommodatinganincreasingnumberofuserswhorunanalyticalqueriesinaDSSenvironmentwithlimitedmemory C submittingbackupjobsatregular 24 hourIntervalsinanOLTPenvironmentwithlimitedmemory D performingbulk loadoperationsinaDSSenvironmentwithlimitedmemory E usingRecoveryManager RMAN torecoveradatabase Answer A 5 2020 3 25 2018年OCP052最新考试题库解析 20180518 5 Whichtwoaffectthetimetakenforinstancerecovery A sizeofredologs B sizeofUNDOtablespace C FAST START MTTR TARGETvalue D sizeofarchivelogs E sizeofexistingRMANbackupsets F UNDO RETENTIONvalue Answer AC 6 2020 3 25 2018年OCP052最新考试题库解析 20180518 6 YouareinstallingOracleGridInfrastructurebyusingtheOracleUniversalInstaller OUI Youselectthe InstallandConfigureGridInfrastructureforaStandaloneServer option WhichtaskisperformedbyOUIaspartofthisinstallation A creationandconfigurationofEnterpriseManagerCloudControlontheserver B creationofprivilegedoperatingsystemgroupsthatareusedforOSauthentication C creationofageneralpurposedatabase D creationofanASMdiskgroupandregistrationofASMcomponentswithOracleRestart Answer D 7 2020 3 25 2018年OCP052最新考试题库解析 20180518 7 Whichistrueaboutexternaltables A TheORACLE DATAPUMPaccessdrivercanbeusedtowritedatatoexternaltables B Segmentsareallocatedforexternaltables C Theydonotsupportpartitioning D TheymayhaveIndexes E DMLoperationsmaybeperformedonexternaltables Answer C 8 2020 3 25 2018年OCP052最新考试题库解析 20180518 8 WhichtwoaretrueabouttheFastRecoveryArea FRA A Itshouldbelargerthanthedatabase B SpacemanagementIntheFRAIsInfluencedbythedatabasebackupretentionpolicy C AdatabasemustbeinARCHIVELOGmodetousetheFRA D Itmustresideonthesamefilesystemasthedatabasedatafiles E OnlyconsistentbackupscanbestoredintheFRA Answer AB 9 2020 3 25 2018年OCP052最新考试题库解析 20180518 9 WhichistrueabouttheAutomaticDiagnosticRepository ADR A Itincludesdiagnosticdataforcriticalerrorsforeachserverandbackgroundprocess B ItslocationisalwayssetbytheORACLE BASEvariable C ItisusedonlyiftheDIAGNOSTIC DESTparameterismanuallyconfigured D Itonlycontainsthealertlogandtracefilesforbackgroundprocesses Answer A 10 2020 3 25 2018年OCP052最新考试题库解析 20180518 10 Whichtwoaretrueaboutconsistentdatabasebackups A TheycanonlybetakenwhenaRECOVERYCATALOGisused B TheycanonlybetakenifthedatabaseIsinARCHIVELOGmode C TheycanonlybetakenIfshutdownNORMAL TRANSACTIONAL orIMMEDIATEshutdownhasbeenperformedandthebackupistakenbeforethedatabaseisreopened D TheycanonlybetakenbyusingRMANcommands E TheycanonlybetakenbyusingRMANwhenthedatabaseisinMOUNTstate Answer CE 11 2020 3 25 2018年OCP052最新考试题库解析 20180518 11 WhichthreearetrueaboutUNDOdata A Itisusedtorollbackfailedtransactions B ItisusedtorewindadatabasebyusingFLASHBACKDATABASE C ItisusedtorecoverdroppedtablesbyusingFLASHBACKTABLE TOBEFOREDROP D ItisusedtoenableROLLBACKstatementstorollbackuncommittedupdates E Itisusedtoprovidereadconsistency F Itisusedduringonlinebackupstoguaranteetheirconsistency Answer ADE 12 2020 3 25 2018年OCP052最新考试题库解析 20180518 12 WhichtwotypesofInformationcanbefoundinthealertlog A instancerecoverydetails B arecordofallDDLstatementsperformedbynon DBAusers C arecordofallactionsperformedbySYSandSYSTEM D criticalerrorsencounteredbybackgroundprocesses E valuesofallInitializationparameterswheneveranInstanceIsrestartedAnswer AD 13 2020 3 25 2018年OCP052最新考试题库解析 20180518 13 WhichtwoaretrueaboutAWRsnapshots A TheyarestoredIntheSYSAUXtablespace B TheyarenotgeneratedifSTATISTICS LEVELIssettoTYPICAL C TheycanbemodifiedbyusingDMLs D Theycanberetainedforever E Theyarealwayscreatedautomatically Answer AD 14 2020 3 25 2018年OCP052最新考试题库解析 20180518 14 Whichcommandisusedtodisplayfilesthatnolongerconformtothebackupretentionpolicy A REPORTOBSOLETE B SHOWDATAFILEBACKUPCOPIES C CROSSCHECKBACKUP D LISTEXPIREDBACKUPAnswer A 15 2020 3 25 2018年OCP052最新考试题库解析 20180518 15 Whichtwoaretrueaboutspacemanagementintablespaces A LocallymanagedtablespaceshaveeitherASSMormanualsegmentspacemanagement MSSM andallthesegmentsinthesetablespacesaremanagedonewayortheother B Locallymanagedtablespacestra