ocporacle1z0-053-答案整理

1、整理過(guò)程參考了一末夕陽(yáng)的博客，復(fù)習(xí)過(guò)程的心得是，一百題看完復(fù)習(xí)前一部分，同時(shí)我還整理了一份打印版本的，上面只有題目，沒(méi)有答案，建議在電腦上先看答案整理那一份，沒(méi)有答案的那份打印出來(lái)，復(fù)習(xí)使用，可以有效加強(qiáng)記憶。1.WhiledeployinganewapplicationmodulethesoftwarevendshipstheapplicationsoftwarealongwithappropriateSQLplanbaselines

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

3、rified.C.ThenewSQLstatementsinitiallyrunwiththeplansthatareknowntoproducegoodperfmanceunderstardtestconfiguration.D.TheoptimizerdoesnotgeneratenewplansftheSQLstatementsfwhichtheSQLplanbaselinehasbeenimpted.當(dāng)部署一個(gè)新的應(yīng)用模塊時(shí)，軟

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

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

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

7、ovingwindowsizeshouldbeequaltolessthantheAutomaticWkloadReposity(AWR)retentionperiod.移動(dòng)窗口基線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