052-题库解析-2-20180518

052题库解析最新15道题题库新特点：更加灵活，题库的顺序与考试时的顺序每场都在变化更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案不断有新的考题出现，目前最新已经更新到130道题1、.WhichtwoaretrueabouttheArchive(ARCn)processes?❑A)Theyautomaticallydeleteobsoletearchivelogstomakespacefornewarchivelogs.❑B)TheyareusedduringInstancerecovery.❑C)Theyarchiveredodirectlyfromtheredologbuffer.❑D)TheyareenabledonlywhenthedatabaseIsInARCHTVELOCmode.❑E)Theycreatearchivelogsaftereverylogswitch.•Answer:DE2、WhichtwoaretrueaboutOptimizerStatistics?❑A)TheydonotpersistacrossInstancerestarts.❑B)TheyareautomaticallyupdatedwhenDDLstatementsexecute.❑C)TheyaregatheredbytheManageabilityMonitor(MMON)backgroundprocess.❑D)TheycanbegatheredbyexecutingthePL/SQLproceduresintheDBMS_STATSpackage.❑E)Theycanbeusedtodeterminetheeventsonwhichadatabaseinstancewaited.❑F)TheyprovideInformationtotheOptimizersothatitcandetermineoptimalexecutionplansforSQLstatements.•Answer:DF3、Whichstructurecanspanmultipledatafiles?❑A)apermanenttablespace❑B)abigfiletablespace❑C)atemporarytablespace❑D)asegment❑E)anextent•Answer:ACD4、Forwhichrequirementshouldyouconfiguresharedservers?❑A)accommodatinganincreasingnumberofuserswhorunshort-duration,infrequentqueriesinanOLTPenvironmentwithlimitedmemory❑B)accommodatinganincreasingnumberofuserswhorunanalyticalqueriesinaDSSenvironmentwithlimitedmemory❑C)submittingbackupjobsatregular,24-hourIntervalsinanOLTPenvironmentwithlimitedmemory❑D)performingbulk-loadoperationsinaDSSenvironmentwithlimitedmemory❑E)usingRecoveryManager(RMAN)torecoveradatabase•Answer:A5、Whichtwoaffectthetimetakenforinstancerecovery?❑A)sizeofredologs❑B)sizeofUNDOtablespace❑C)FAST_START_MTTR_TARGETvalue❑D)sizeofarchivelogs❑E)sizeofexistingRMANbackupsets❑F)UNDO_RETENTIONvalue•Answer:AC6、YouareinstallingOracleGridInfrastructurebyusingtheOracleUniversalInstaller(OUI).YouselecttheInstallandConfigureGridInfrastructureforaStandaloneServeroption.WhichtaskisperformedbyOUIaspartofthisinstallation?❑A)creationandconfigurationofEnterpriseManagerCloudControlontheserver❑B)creationofprivilegedoperatingsystemgroupsthatareusedforOSauthentication❑C)creationofageneralpurposedatabase❑D)creationofanASMdiskgroupandregistrationofASMcomponentswithOracleRestart•Answer:D7、Whichistrueaboutexternaltables?❑A)TheORACLE_DATAPUMPaccessdrivercanbeusedtowritedatatoexternaltables.❑B)Segmentsareallocatedforexternaltables.❑C)Theydonotsupportpartitioning.❑D)TheymayhaveIndexes.❑E)DMLoperationsmaybeperformedonexternaltables.•Answer:C8、WhichtwoaretrueabouttheFastRecoveryArea(FRA)?❑A)Itshouldbelargerthanthedatabase.❑B)SpacemanagementIntheFRAIsInfluencedbythedatabasebackupretentionpolicy.❑C)AdatabasemustbeinARCHIVELOGmodetousetheFRA.❑D)Itmustresideonthesamefilesystemasthedatabasedatafiles.❑E)OnlyconsistentbackupscanbestoredintheFRA.•Answer:AB9、WhichistrueabouttheAutomaticDiagnosticRepository(ADR)?❑A)Itincludesdiagnosticdataforcriticalerrorsforeachserverandbackgroundprocess.❑B)ItslocationisalwayssetbytheORACLE_BASEvariable.❑C)ItisusedonlyiftheDIAGNOSTIC_DESTparameterismanuallyconfigured.❑D)Itonlycontainsthealertlogandtracefilesforbackgroundprocesses.•Answer:A10、Whichtwoaretrueaboutconsistentdatabasebackups?❑A)TheycanonlybetakenwhenaRECOVERYCATALOGisused.❑B)TheycanonlybetakenifthedatabaseIsinARCHIVELOGmode.❑C)TheycanonlybetakenIfshutdownNORMAL,TRANSACTIONAL,orIMMEDIATEshutdownhasbeenperformedandthebackupistakenbeforethedatabaseisreopened.❑D)TheycanonlybetakenbyusingRMANcommands.❑E)TheycanonlybetakenbyusingRMANwhenthedatabaseisinMOUNTstate.•Answer:CE11、WhichthreearetrueaboutUNDOdata?•❑A)Itisusedtorollbackfailedtransactions.•❑B)ItisusedtorewindadatabasebyusingFLASHBACKDATABASE.•❑C)ItisusedtorecoverdroppedtablesbyusingFLASHBACKTABLE…TOBEFOREDROP.•❑D)ItisusedtoenableROLLBACKstatementstorollbackuncommittedupdates.•❑E)Itisusedtoprovidereadconsistency.•❑F)Itisusedduringonlinebackupstoguaranteetheirconsistency.•Answer:ADE12、WhichtwotypesofInformationcanbefoundinthealertlog?•❑A)instancerecoverydetails•❑B)arecordofallDDLstatementsperformedbynon-DBAusers•❑C)arecordofallactionsperformedbySYSandSYSTEM•❑D)criticalerrorsencounteredbybackgroundprocesses•❑E)valuesofallInitializationparameterswheneveranInstanceIsrestarted•Answer:AD13、WhichtwoaretrueaboutAWRsnapshots?•❑A)TheyarestoredIntheSYSAUXtablespace.•❑B)TheyarenotgeneratedifSTATISTICS_LEVELIssettoTYPICAL.•❑C)TheycanbemodifiedbyusingDMLs.•❑D)Theycanberetainedforever.•❑E)Theyarealwayscreatedautomatically.•Answer:AD14、Whichcommandisusedtodisplayfilesthatnolongerconformtothebackupretentionpolicy?•❑A)REPORTOBSOLETE•❑B)SHOWDATAFILEBACKUPCOPIES•❑C)CROSSCHECKBACKUP•❑D)LISTEXPIREDBACKUP•Answer:A•15、Whichtwoaretrueaboutspacemanagementintablespaces?•❑A)LocallymanagedtablespaceshaveeitherASSMormanualsegmentspacemanagement(MSSM),andallthesegmentsinthesetablespacesaremanagedonewayortheother.•❑B)Locallymanagedtablespacestrackadjacentfreespaceautomaticallybyusingbitmaps.•❑C)Extentallocationmustbespecifiedasautomaticforautomaticsegmentspacemanagement(ASSM)tablespaces.•❑D)ASSMtablespacespreventrowchaining.•❑E)Freelistsareusedformanagingfreespaceforsegmentsinlo