ocporacle1z0-053-答案整理

1、整理過程參考了一末夕陽的博客，復習過程的心得是，一百題看完復習前一部分，同時我還整理了一份打印版本的，上面只有題目，沒有答案，建議在電腦上先看答案整理那一份，沒有答案的那份打印出來，復習使用，可以有效加強記憶。1.WhiledeployinganewapplicationmodulethesoftwarevendshipstheapplicationsoftwarealongwithappropriateSQLplanbaselines

2、fthenewSQLsbeingintroduced.Whichtwostatementsdescribetheconsequences(Choosetwo.)A.Theplanbaselinescanbeevolvedovertimetoproducebetterperfmance.B.ThenewlygeneratedplansaredirectlyplacedintotheSQLplanbaselinewithoutbeingve

3、rified.C.ThenewSQLstatementsinitiallyrunwiththeplansthatareknowntoproducegoodperfmanceunderstardtestconfiguration.D.TheoptimizerdoesnotgeneratenewplansftheSQLstatementsfwhichtheSQLplanbaselinehasbeenimpted.當部署一個新的應用模塊時，軟

4、件供應商與用于被引入的新SQL的適當?shù)腟QL計劃基線一起運送應用軟件。哪兩個語句描述了后果？A計劃基線可以隨著時間的推移演變，產(chǎn)生更好的性能。C新的SQL語句最初與計劃一起運行，該計劃在標準測試配置下已知能產(chǎn)生良好的性能。新應用程序部署：部署新的應用程序模塊意味著在系統(tǒng)中引入新的SQL語句。軟件供應商可以將應用程序軟件與新引入的SQL語句的相應SQL計劃基線一起提供。由于存在計劃基線，新的SQL語句最初將與已知在標準測試配置下具有良好性

5、能的計劃一起運行。但是，如果客戶系統(tǒng)配置與測試配置有很大的差異，則計劃基線可隨時間演化以產(chǎn)生更好的性能。2.Youplantohavealargermovingwindowsizefthedefaultsystemdefinedmovingwindowbaselinebecauseyouwanttousetheadaptivethreshold.Whichstatementfactsinthisconsiderationwhileinc

6、reasingthesizeofthemovingwindow.A.ThecollectionlevelftheAWRshouldbesettoBASIC.B.ThemovingwindowsizemustbelessthanUndoRetention.C.ThemovingwindowsizeshouldbegreaterthantheAutomaticWkloadReposity(AWR)retentionperiod.D.Them

7、ovingwindowsizeshouldbeequaltolessthantheAutomaticWkloadReposity(AWR)retentionperiod.移動窗口基線B.aprogram程序C.aschedule調(diào)度5.ExaminethesectionoftheHealthCheckreptgivenbelow:DBMS_HM.GET_RUN_REPT(HM_RUN_1061)Thesafereasierwaytohe

8、lpyoupassanyITexams.3193RunName:HM_RUN_1061RunId:1061CheckName:DataBlockIntegrityCheckMode:REACTIVEStatus:COMPLETEDStartTime:2007051222:11:02.03229207:00EndTime:2007051222:11:20.83513507:00ErrEncountered:0SourceIncidentI

9、d:7418NumberofIncidentsCreated:0WhichtwostatementsaretrueregardingtheHealthCheckrept(Choosetwo.)A.HealthCheckwasperfmedmanually.B.HealthCheckwasperfmedtocheckthediskimageblockcruptions.C.HealthCheckwasperfmedtocheckinter

10、blockintersegmentcruption.D.HealthCheckwasperfmedtoverifytheintegrityofdatabasefilesreptfailures.E.HealthCheckwasperfmedbytheHealthMonitautomaticallyinresponsetoacriticalerr.6.YouarewkingonaCATDBdatabasethatcontainsanacl

11、eDatabaseversion11.1catalogschemaownedbytheuserRCO11.TheINST1databasecontainsanacleDatabaseversion10.1catalogschemaownedbytheuserRCAT10.YouwanttheRMANtoimptmetadatafdatabaseIDs14232411423242registeredinRCAT10intotherecov

12、erycatalogownedbyRCO11.Youalsowanttoderegisterthemfromthecatalogafterimpt.Youexecutedthefollowingcommstoachievethis:RMANCONNECTCATALOGrco11passwd@catdbRMANIMPTCATALOGrcat10acle@inst1DBID=14232411423242WhathappensiftheRCO

13、11cataloghasswiththesamenameasthatofthesinRCAT10catalogA.ThesintheRCO11catalogareoverwritten.B.RMANrenamesthelocalstedsintheRCO11catalog.C.TheRMANsessioninwhichthecommisexecutedabts.D.RMANrenamestheglobalsthatareimptedfr