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

2018年OCP052最新考试题库解析-20180601题库新特点：更加灵活，题库的顺序与考试时的顺序每场都在变化更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案整理：CUUG2018年OCP052最新考试题库解析-20180601•1、YourdatabaseIsconfiguredInarchivelogmode.•TheUSERS01tablespaceIscurrentlyonline.•Youarerequiredtotakethetablespaceoffline.•Whichclauseorclausesensurethatnomediarecoveryisrequired•whenthetablespaceIsbroughtbackonline?••❑A)eithertheNORMALortheTEMPORARYclause••❑B)onlytheNORMALclause••❑C)onlytheTEMPORARYclause••❑D)eithertheNORMALortheIMMEDIATEclause••❑E)onlytheIMMEDIATEclause••Answer:B•1offlinetemporary表空间时，如果表空间中没有offline的数据文件，则online该表空间时不需要介质恢复。•2offlinetemporary表空间时，不会对已经offline的数据文件执行检查点操作，仅仅对online的数据文件执•行检查点操作•3offlinetemporary表空间时，对于离线表空间之前已经offline的数据文件，则online该表空间时，offline数•据文件需要介质恢复。2018年OCP052最新考试题库解析-20180601••2、Whichtwostatementsaretrueabouttablespaces?••❑A)Adatabasecancontainmultipleundotablespaces.••❑B)Adatabasecancontainonlyasingletemporarytablespace.••❑C)AdatabaseinstancestoresundodataIntheSYSTEMtablespaceIfnoundotablespaceexists.••❑D)AdatabaseinstancehangsIftheSYSAUXtablespacebecomesunavailable.••❑E)AdatabasewithalocallymanagedSYSTEMtablespacecanhavedictionary-managedusertablepaces.••Answer:AE•2018年OCP052最新考试题库解析-20180601••3、YouwanttoInstallOracle11gdatabasesoftwareandcreateadatabaseonASMImmediatelyaftertheInstall.•YourplanistoinstallbothOracledatabaseandGridInfrastructure.•Whichtwoaretrueinthisscenario?••❑A)GridInfrastructuremustbeinstalledfirst.••❑B)BothproductsmustbeInstalledbythesameOSuser.••❑C)EachproductmustbeInstalledInadifferentORACLE_HOME.••❑D)BothproductscansharetheOSgroupassignedtotheirOSDBAandOSOPERprivilegedgroups••❑E)BothproductsmustbeinstalledbyusingthesameORACLE_BASE.••❑F)Bothproductsmustbeofthesameversion.••Answer:AC2018年OCP052最新考试题库解析-20180601•4、WhichistrueaboutinvalidPL/SQLobjects?••❑A)Theyareautomaticallyrecompiledagainstthenewdefinitionofareferencedobjectatthesametimeasthereferencedobjectismodified.••❑B)TheycanbemanuallyrecompiledonlybyusingSQLcommands.••❑C)Theyareautomaticallyrecompiledagainstthenewdefinitionofareferencedobjectwhentheyarecalled.••❑D)TheymustbemanuallyrecompiledbeforetheycanbeusedifaDDLisperformedonatablethatisreferencedinthePL/SQLobject.••Answer:D2018年OCP052最新考试题库解析-20180601•5、WhichistrueabouttheSYSTEMandSYSAUXtablespaces?••❑A)TheSYSAUXtablespacecanbemaderead-onlybuttheSYSTEMtablespacecannot.••❑B)Bothtablespacescanbeusedfortemporarystorageifnotemporarytablespaceisdefined.••❑C)OnlytheSYSTEMtablespacecontainsdatadictionarytables.••❑D)Bothtablespacesmustbeonlineforadatabasetobeaccessible.••Answer:A•2018年OCP052最新考试题库解析-20180601•6、Whichtwoaretrueaboutroles?••❑A)Arolecanbepassword-protected.••❑B)Arolecanbegrantedtoanotherrole.••❑C)Onlyonedefaultrolecanbegrantedtoauser.••❑D)Arolecanbegrantedonlymultiplesystemprivilegesnotmultipleobjectprivileges.••❑E)ArolecanbecreatedonlybyauserwiththeSYSDBAprivilege.••Answer:AB2018年OCP052最新考试题库解析-20180601•7、YouareplanningasoftwareinstallationforbothOracleDatabase11gRelease1andRelease2.•YouplantohaveatleaseonedatabaseforeachreleasemanagedbyGridInfrastructureforaStandaloneServer.•Whichthreearetrueinthisscenario?••A)Oracle11gRelease1databasesmustbemanagedbyGridInfrastructure11gRelease1.••B)BothdatabasescanbemanagedbyGridInfrastructure11gRelease2.••C)BothOracleversionsandGridInfrastructurecanbeownedbythesameO/Saccount.••D)GirdInfrastructuremustbeinstalledbeforebothOracleDatabaseversions.••E)EachversionofthedatabasemaybemanagedbyaseparateversionofGridInfrastructure.••F)BothOracleversionsandGridInfrastructurecanbeinstalledunderthesameORCALE_BASE.••Answer:ADE2018年OCP052最新考试题库解析-20180601•8、Whichtwoaretrueaboutdatadictionaryanddynamicperformanceviews(v$views)?••A)AlldatabaseusershaveaccesstoALL_*views.••B)Datadictionaryviewoutputissubjecttoreadconsistency.••C)ThedefiningqueriesforOraclesupplieddynamicperformanceviewsarestoredInthedatadictionary.••D)Allv$viewsdisplayoutputwhenqueries,iftheinstanceisinnomountstate••E)Alldatabaseusershaveaccesstoallv$views.••Answer:AB2018年OCP052最新考试题库解析-20180601•9、YOURDB_RECOVERY_FILE_DEST_SIZEIs8G.•Currently,5GofthespaceIsusedofwhich4Gconsistsofobsoletebackups.•Youexecutethiscommand:•SQLALTERSYSTEMSETdb_recovery_file_dest_size=2G;•Whatistheoutcome?••A)ItchangesDB_RECOVERY_FILE_DEST_SIZEto5G.••B)ItchangesDB_RECOVERY_FILE_DEST_SIZEto2Gwithoutdeletingvalidbackups.••C)ItfallsbecauseDB_RECOVERY_FILE_DEST_SIZEisastaticparameter.••D)ItchangesDB_RECOVERY_FILE_DEST_SIZEto2Ganddeletestheobsoletebackups.••E)Itfailsbecausethenewsizeislessthan5G.••Answer:D2018年OCP052最新考试题库解析-20180601•10、Whichistrueaboutlogicalandphysicaldatabasestructures?(Choosethebestanswer)••A.Anundotablespacehasatempfileinsteadofadatafile.••B.Asegmentcanconsistofextentsofdifferentsizes.••C.Apermanenttablespacecanonlycontaintablessegmentsandindexsegments.••D.Atablespacecanconsistofdatablocksofdifferentsizes.••E.Anextentalwaysconsistsofphysicallycontiguousdatablocksinstorage.••CorrectAnswer:B2018年OCP052最新考试题库解析-20180601••11、InwhichstatecanyoubackupadatabaseinARCHIVELOGMODEusingRMAN?••A.NOMOUNT,MOUNT,ANDOPEN••B.NOMOUNTANDMOU