IdentifytwosituationsinwhichyoucanuseDataRecoveryAdvisorforrecovery.(ChooseTheuserhasdroppedanimportanttablethatneedstobeThedatabasefilesarecorruptedwhenthedatabaseisYouarenotabletostartupthedatabaseinstancebecausetherequireddatabasefilesareThearchivedlogfilesaremissingforwhichbackupisnotAnswer:BCExaminethefollowingvaluesoftheinitializationparametersinthedatabasehavingtheSIDTheenvironmentvariableshavethefollowingWhatisthelocationoftheAutomaticDiagnosticRepository(ADR)Answer:如果ORACLE_BASE環(huán)境變量已設(shè)置，則DIAGNOSTIC_DEST被設(shè)置為$ORACLE_BASE theADRrootdirectoryisknownasADRbase.ItslocationissettheDIAGNOSTIC_DESTinitializationparameter.Ifthisparameterisomittedorleftnull,thedatabasesetsDIAGNOSTIC_DESTuponstartupasfollows:IfenvironmentvariableORACLE_BASEisset,DIAGNOSTIC_DESTissettothedirectorydesignatedbyORACLE_BASE.IfenvironmentvariableORACLE_BASEisnotset,DIAGNOSTIC_DESTissettoWithinADRbase,therecanbemultipleADRhomes,whereeachADRhomeistherootdirectoryforalldiagnosticdata—traces,dumps,thealertlog,andsoon—foraparticularinstanceofaparticularOracleproductorcomponent.Forexample,inanOracleRealApplicationClustersenvironmentwithOracleASM,eachdatabaseinstance,OracleASMinstance,andlistenerhasanADRhome.ObservethefollowingPL/SQLWhichstatementiscorrectregardingtheabovePL/SQLItautomaticallypurgestheSQLmanagementobjectswhenSMBoccupiesmorethan30%oftheSYSAUXtablespace.Itreserves30%ofthespaceintheSYSAUXtablespaceforSQLManagementBaseItreserves30%ofthespaceintheSYSTEMtablespaceforItgeneratesaweeklywarninginthealertlogfilewhenSMBoccupiesmorethan30%oftheSYSAUXtablespace.Answer:參考 WhenthespaceoccupiedbySQLmanagementbaseexceedsthedefinedspacebudgetlimit,aweeklydatabasealertisgenerated.Table136-6Names&ValuesforCONFIGUREProcedureumpercentofSYSAUXspacethatcanbeusedforSQLmanagementbase1,2,…,Numberofweekstoretainunusednsbeforetheyarepurged5,6,…,DBMS_SPMSQLSQL執(zhí)行計(jì)劃，SQL計(jì)劃管理功能SQLSQL語SQL計(jì)劃基線能夠隨后用于保證適當(dāng)?shù)男阅?，即使是在系統(tǒng)發(fā)生改變SQLSQL執(zhí)行計(jì)劃：SQL計(jì)劃基線能顯著地減少由于數(shù)據(jù)庫更新帶來的性能問題。有時部署新的系統(tǒng)模塊相當(dāng)于新的SQL語句到系統(tǒng)中，應(yīng)用程序需要有適當(dāng)?shù)腟QLSQL計(jì)劃基線能在隨DBMS_SPMSYSADMINISTERSQLMANAGEMENTOBJECT權(quán)限才可以執(zhí)行這個包CONFIGURESQLparameter/value的格式。這個函數(shù)CONFIGUREThisproceduresetsconfigurationoptionsforSQLmanagementbase,inparameter/valueformat.Thisfunctioncanbecallednumeroustimes,eachtimesettingadifferentconfigurationoption. INNUMBER);Table136-5CONFIGUREProcedureNameofparametertoset(seetableValueofparametertouse(seetableTable136-6Names&ValuesforCONFIGUREProcedureumpercentofSYSAUXspacethatcanbeusedforSQLmanagementbase1,2,…,Numberofweekstoretainunusednsbeforetheyarepurged5,6,…,UsageThedefaultspacebudgetforSQLmanagementbaseisnomorethantenpercentofthesizeofSYSAUXtablespace.Thespacebudgetcanbesettoaumof50%.Thedefaultunusednretentionperiodisoneyearandoneweek,whichmeansanwillbeautomaticallypurgedifithasnotbeenusedformorethanayear.Theretentionperiodcanbesettoaumof523weeks(i.e.alittleover10years).WhenthespaceoccupiedbySQLmanagementbaseexceedsthedefinedspacebudgetlimit,aweeklydatabasealertisgenerated.這個參數(shù)是設(shè)置最大的在SYSAUX空間上的百分比，并且如果超過空間閾值則每周會告警,D參考 15.6.1DiskSpaceDiskspaceusedbytheSMBisregularlycheckedagainstalimitbasedonthesizeoftheSYSAUXtablespace.Bydefault,thelimitfortheSMBisnomorethan10%ofthesizeofSYSAUX.Theallowablerangeforthislimitisbetween1%and50%.AweeklybackgroundprocessmeasuresthetotalspaceoccupiedbytheSMB.Whenthedefinedlimitisexceeded,theprocesswritesawarningtothealertlog.Thedatabasegeneratesalertsweeklyuntiloneofthefollowingconditionsismet:TheSMBspacelimitisThesizeoftheSYSAUXtablespaceisThediskspaceusedbytheSMBisdecreasedbypurgingSQLmanagementobjects(SQLnbaselinesorSQLprofiles)Tochangethepercentagelimit,usetheCONFIGUREprocedureoftheDBMS_SPMpackage.Thefollowingexamplechangesthespacelimitto30%:/OCP-1Z0-053-V13.02-477YouaremanaginganOracleDatabase11gASMinstancehavingthreedisksinadiskgroupwithASMcompatibilityattributesetto11.1.0andredundancysettohigh.Oneofthedisksinthediskgroup esunavailablebecauseofpowerfailure.Whichstatementswillbetrueinthisscenario?(Chooseallthatapply.)ThediskisimmediaydroppedfromthediskTheASMtrackstheextentsthataremodifiedduringtheTheASMmigratestheextentsfromtheunavailabledisktotheremainingThediskautomaticallygoesAnswer:BDACWhichstatementsaretrueregardingtablecompression?(ChooseallthatItsavesdiskspaceandreducesmemoryItsavesdiskspacebuthasnoeffectonmemoryItincursextraCPUoverheadduringDMLaswellasdirectloadingItincursextraCPUoverheadduringDMLbutnotdirectloadingIt pressoperationduringAnswer:參考 ConsiderUsingTableAsyourdatabasegrowsinsize,considerusingtablecompression.Compressionsavesdiskspace,reducesmemoryuseinthedatabasebuffercache,andcansignificantlyspeedqueryexecutionduringreads.CompressionhasacostinCPUoverheadfordataloadingandDML.However,thiscostmightbeoffsetbyreducedI/Orequirements.YouareworkingasaDBAonthedecisionsupportsystem.Thereisabusinessrequirementtotrackandstorealltransactionsforatleastthreeyearsforafewtablesinthedatabase.Automaticundomanagementisenabledinthedatabase.Whichconfigurationshouldyouuseto thistask?EnableFlashbackDataArchivefortheSpecifyundoretentionguaranteefortheEnablesupplementalloggingfortheQueryV$UNDOSTATtodeterminetheamountofundothatwillbegeneratedandcreateanundotablespaceforthatsize.CreateFlashbackDataArchiveonthetablespaceonwhichthetablesareAnswer:參考：閃回?cái)?shù)據(jù)歸檔概述：閃回?cái)?shù)據(jù)歸檔實(shí)驗(yàn)測試：WhichcomponentsareneededforsuccessfulandmostefficientThebackupRB3andthecurrentonlineredologthebackupRB2andthearchivedredologfilesafterthelogsequencenumberBackupR81andthearchivedredologhiesafterthelogsequencenumberThebackupRB3andthearchivedredologfilesafterthelogsequencenumberAnswer:redoYouaremanaginganOracleDatabase11ginstancewithASMstorage.YoulostanASMdiskgroupDATA.YouhaveRMANbackupofdataaswellasASMmetadatabackup.Youwanttore-createthemissingdiskgroupbyusingtheASMCMDmd_restorecommand.Whichofthesemethodswouldyouusetoachievethis?(Chooseallthatapply.)Restorethediskgroupwiththeexactconfigurationasthebacked-updiskgroup,usingthesamediskgroupname,samesetofdisks,failuregroupconfigurations,anddataonthediskgroup.Restorethediskgroupwiththeexactconfigurationasthebacked-updiskgroup,usingsamediskgroupname,samesetofdisks,andfailuregroupRestorethediskgroupwithchangeddiskgroupspecification,failuregroupspecification,diskgroupname,andotherdiskattributes.RestoremetadatainanexistingdiskgroupbypassingtheexistingdiskgroupnameasaninputAnswer:md_restoredataAWhichstatementdescribestheeffectoftableredefinitiononthetriggersattachedtotheAlltriggersonthetableareinvalidatedandareautomaticallyrevalidatedwiththenextDMLexecutiononthetable.Alltriggersonthetableareinvalidatedandmustbemanually piledbeforethenextDMLexecutiononthetable.AlltriggersonthetableremainOnlytriggersthatareaffectedbythechangestothestructureofthetableareinvalidatedandautomaticallyrevalidatedwiththenextDMLexecutiononthetable.Answer:題目解答：只有YountocollecttheAutomaticWorkloadRepository(AWR)dataeveryMondaymorningforamonth.YouwantOracleDatabasetoautomaticallycreateabaselineeveryMondayandremovetheoldbaseline.Whatisthecorrectactiontoachievethis?CreateandpopulateaSQLTuningSetfromtheAWRoneveryChangetheRETENTIONsettingfortheAWRsnapshotsto7daysonCreatearepeatingbaselinetemInsertafindingdirectiveforfutureADDMAnswer:參考 CreatingaRepeatingBaselineTemThissectiondescribeshowtocreatearepeatingbaselinetemte.Arepeatingbaselinetemtecanbeusedtoautomaticallycreatebaselinesthatrepeatduringaparticulartimeintervaloveraspecificperiodinthefuture.Forexample,youcancreatearepeatingbaselinetemtetogenerateabaselinethatrepeatseveryMondayfrom5:00p.m.to8:00p.m.fortheyear2009.Tocreatearepeatingbaselinetemte,usetheCREATE_BASELINE_TEMTEprocedure:/

day_of_week=>'monday',hour_in_day=>17,duration=>3,expiration=>30,start_time=>'2009-04-0217:00:00end_time=>'2009-12-3120:00:00baseline_name_prefix=>'baseline_2009_mondays_',temte_name=>'temte_2009_mondays',dbid Theday_of_weekparameterspecifiesthedayoftheweekonwhichthebaselinewillrepeat.Thehour_in_dayparameterspecifiesthehourinthedaywhenthebaselinewillstart.Thedurationparameterspecifiestheduration,innumberofhours,thatthebaselinewilllast.Theexpirationparameterspecifiesthenumberofdaystoretaineachcreatedbaseline.IfsettoNULL,thenthebaselinesneverexpires.Thestart_timeparameterspecifiesthestarttimeforthebaselinetobecreated.Theend_timeparameterspecifiestheendtimeforthebaselinetobecreated.Thebaseline_name_prefixparameterspecifiesthenameofthebaselineprefixthatwillbeappendedtothedatainformationwhenthebaselineiscreated.Thetemte_nameparameterspecifiesthenameofthebaselinetemte.Theoptionaldbidparameterspecifiesthedatabaseidentifier.Ifunspecified,thenthelocaldatabaseidentifierisusedasthedefaultvalue.Inthisexample,abaselinetemtenamedtemte_2009_mondaysiscreatedthatwillgenerateabaselineoneveryMondayfrom5:00p.m.to8:00p.m.beginningonApril2,2009at5:00p.m.andendingonDecember31,2009at8:00p.m.onthedatabasewithadatabaseID .Eachofthebaselineswillbecreatedwithabaselinenamewiththeprefixbaseline_2009_mondays_andwillexpireafter30days.DropaBaselineTemThissectiondescribeshowtodropanexistingbaselinetemte.Periodically,youmaywanttoremovebaselinestemtesthatarenolongerusedtoconservediskspace.TodropabaselinetemReviewtheexistingbaselinesintheDBA_HIST_BASELINE_TEMTEviewtodeterminethebaselinetemteyouwanttodrop.UsetheDROP_BASELINE_TEMTEproceduretodropthedesiredbaselinetemte:temte_name=>'temte_2009_mondays',dbid=> /Thetemte_nameparameterspecifiesthenameofthebaselinetemtethatwillbedropped.Intheexample,thenameofbaselinetemtethatwillbedroppedistemte_2009_mondays.Theoptionaldbidparameterspecifiesthedatabaseidentifier,whichinthisexample .Ifyoudonotspecifyavaluefordbid,thenthelocaldatabaseidentifierisusedasthedefaultvalue.Whichthreestatementsaretrueregardingpersistentlightweightjobs?(ChoosePersistentlightweightjobsmodifyseveraltablesinthedatadictionarytogeneratealotofTheusercannotsetprivilegesonpersistentlightweightPersistentlightweightjobsareusefulwhenusersneedtocreatealargenumberofjobsinashorttime.Persistentlightweightjobsareusefulwhenusersneedtocreateasmallnumberofjobsthatruninfrequently.TheuseofatemteismandatorytocreatepersistentlightweightAnswer:638題：向磁盤寫入狀態(tài)信息，所以在執(zhí)行時應(yīng)該量改進(jìn)。持久輕量作業(yè)有多種限制：用戶無法設(shè)置對這些作業(yè)的權(quán)限，它們將從父作業(yè)模板中繼承其權(quán)限。--B必須使用模板，無法創(chuàng)建完全自包含的持久輕量作業(yè)。E（10100個作業(yè)（作業(yè)模板）可供使用，則最適合使用輕量作業(yè)。--C對Yourdatabaseinitializationparameterfilehasthefollowingentry:WhichstatementistrueregardingthisItdropstheconnectionafterthespecifiednumberofloginattemptsfailforanyItisendonlyifthepasswordprofileisenabledfortheItlockstheuseraccountafterthespecifiednumberofItdropstheconnectionafterthespecifiednumberofloginattemptsfailonlyforuserswhohavetheSYSDBAprivilege.Answer:A考 SEC_MAX_FAILED_LOGIN_ATTEMPTSspecifiesthenumberofauthenticationattemptsthatcanbemadebyaonaconnectiontotheserverprocess.Afterthespecifiednumberoffailureattempts,theconnectionwillbeautomaticallydroppedbytheserverprocess.WhichstatementistrueregardingvirtualprivateAvirtualprivatecatalogownercancreatealocalstoredscript,andhaveread/writeaccesstoaglobalstoredscript.ThevirtualprivatecatalogownercannotcreateandmodifythestoredThesetofviewsandsynonymsthatmakeupthevirtualprivatecatalogisstoredintheschemaoftheRMANrecoverycatalogowner.ToperformmostoftheRMANoperations,thevirtualcatalogownermusthavetheSYSDBAorSYSOPERprivilegeonthetargetdatabase.Answer:參考：作為虛 所有者，你只能查看授予了你權(quán)限的數(shù)據(jù)庫 RMAN 的所有者必須對目標(biāo)數(shù)據(jù)庫具有SYSDBASYSOPERWhichtaskscanbe plishedusingtheEnterpriseManagerSupportWorkbenchinOracleDatabase11g?(Chooseallthatapply.)GeneratereportsondatafailuresuchasdatafileYoucantracktheServiceRequest(SR)andimplementYoucanpackageanduploaddiagnosticdatatoOracleYoucanmanuallyrunhealthcheckstogatherdiagnosticdataforaAnswer:參考：C.Oracle支持。WhataretheadvantagesofvariableextentsizesupportforlargeASMfiles?(ChooseItimprovesresyncoperationswhenthediskcomesonlineafterbeingtakenofflineformaintenancepurposes.Itimprovesperformanceintheextendedclusterconfigurationbyreadingfromalocalcopyofanextent.Fewerextentpointersareneededtodescribethefileandlessmemoryisrequiredtomanagetheextentmapsinthesharedpool.Thisfeatureenablesfasterfileopensbecauseofthereductionintheamountofmemorythatisrequiredtostorefileextents.Answer:參考 D.此功能可以更快地打開文件，因?yàn)樾枰募^(qū)的內(nèi)存量減少。ThecontentsofOracleASMfilesarestoredinadiskgroupasaset,orcollection,ofextentsthatarestoredonindividualdiskswithindiskgroups.Eachextentresidesonanindividualdisk.Extentsconsistofoneormoreallocationunits(AU).To modateincreasinglylargerfiles,OracleASMusesvariablesizeextents.VariablesizeextentsenablesupportforlargerOracleASMdatafiles,reduceSGAmemoryrequirementsforverylargedatabases,andimproveperformanceforfilecreateandopenoperations.Theinitialextentsizeequalsthediskgroupallocationunitsizeanditincreasesbyafactorof4or16atpredefinedthresholds.Thisfeatureisautomaticfornewlycreatedandresizeddatafileswhenspecificdiskgroupcompatibilityattributesaresetto11.1orhigher.TheextentsizeofafilevariesasExtentsizealwaysequalsthediskgroupAUsizeforthefirst20000extentsets(0-19999).Extentsizeequals4*AUsizeforthenext20000extentsets(20000-39999).Extentsizeequals16*AUsizeforthenext20000andhigherextentsetsWhichtwoaretheusesoftheASMmetadatabackupandrestore(AMBR)feature?(ChooseItcanbeusedtobackupalldataonASMItcanbeusedtorecoverthedamagedASMdiskgroupalongwiththeItcanbeusedtogatherinformationaboutapreexistingASMdiskgroupwithdiskpaths,diskname,failuregroups,attributes,temtes,andaliasdirectorystructure.Itcanbeusedtore-createtheASMdiskgroupwithitsAnswer:題目解答:ABdata是不能的,WhichtwochangesandtheireffectonthesystemcanbetestedbyusingtheDatabaseReyfeature?(Choosetwo.)multiplexingofthecontroladdingtheredologmembertothedatabaseandoperatingsystemchangingthedatabasestoragetoASM-managedAnswer:題目解答:ABWhichisthesourceusedbyAutomaticSQLTuningthatrunsaspartoftheAUTOTASKSQLstatementsthatarepartoftheAWRbaselineSQLstatementsbasedontheAWRtopSQLSQLstatementsthatarepartoftheavailableSQLTuningSet(STS)SQLstatementsthatareavailableinthecursorcacheandexecutedbyauserotherthanAnswer:題目解答AConly錯,DWhileperformingthebackupoftheflashrecoveryarea,younoticethatoneofthearchivedredologfilesismissing.Youhavemultipledestinationsforarchivedredologfiles.Whatimplicationsdoesithaveonthebackupoftheflashrecoveryarea?ThebackupfailsbecauseoneofthearchivedredologfilesisThebackupsucceedsbutitwouldbewithoutthemissingarchivedDuringbackup,youarepromptedforthealternativedestinationforthemissingarchivedredologfile.ThebackupsucceedsbecauseitfailsovertooneofthealternativearchivedredologAnswer:YouaremanaginganOracleDatabase11ginstanceandanOracleDatabase10ginstanceonthesamemachine.BothinstancesusetheASMinstanceasstorage.WhichstatementregardingtheASMdiskgroupcompatibilityattributesaretrueinthisscenario?(Chooseallthatapply.) patibilityversionsettingsforeachinstancemustbegreaterthanorequaltotheRDBMScompatibilityofallASMdiskgroupsusedbythatdatabaseinstances.RDBMScompatibilityandthedatabaseversiondetermineswhetheradatabaseinstancecanmounttheASMdiskgroup.TheRDBMScompatibilitysettingsforadiskgroupcontroltheformatofdatastructuresforASMmetadataonthedisk.ASMcompatibilitycontrolswhichfeaturesfortheASMwillbeAnswer:ABDASM磁盤組的兼容性有三種：涉及描述磁盤組的持久性數(shù)據(jù)結(jié)構(gòu)，客戶機(jī)（磁盤組的使用者“ASM兼容性”“RDBMS兼容性”和“ADVM兼容性”。每個磁盤組的兼容性都可以獨(dú)立控制。這是支持包含OracleDatabase10gOracleDatabase11g磁盤組的異構(gòu)環(huán)境所必需的。ASM?RDBMSRDBMSASM實(shí)例與數(shù)據(jù)庫(RDBMS)實(shí)例間交換消息的格式。ASM實(shí)例可以支持RDBMSASM實(shí)例通常在不同的OracleASM實(shí)例不同的軟件版本。數(shù)據(jù)庫ASM實(shí)例時，系統(tǒng)會協(xié)定這兩個實(shí)例都支持的最高版本。?ASMASM元數(shù)據(jù)的數(shù)據(jù)結(jié)構(gòu)格式的持久性兼容性設(shè)置。ASMRDBMSASMASM元數(shù)據(jù)的格式相關(guān)。文件內(nèi)容的格式取決于數(shù)據(jù)庫實(shí)例。例如，可以ASM11.0RDBMS10.1。這11.0ASM10.1ADVMOracleASM11.2或更高。設(shè)COMPATIBLE.ASM11.2ADVM卷但是，提高磁盤組兼容性是一個不可逆的操作?？梢允褂肅REATEDISKGROUP命令或ALTERDISKGROUP命令來設(shè)置磁盤組兼容性。據(jù)庫或ASM實(shí)例，具體取決于instance_type參數(shù)。例如，將該參數(shù)設(shè)置為10.1將使OracleDatabase11g中引入的任何新功能（磁盤聯(lián)機(jī)/脫機(jī)、可變區(qū)等。WhichthreestatementsaretrueregardingthefunctioningoftheAutotaskBackgroundProcess(ABP)?(Choosethree.)ItcreatesjobswithoutconsideringtheprioritiesassociatedwithIttranslatestasksintojobsforexecutionbytheItdeterminesthelistofjobsthatmustbecreatedforeachmaintenanceItisspawnedbytheMMONbackgroundprocessatthestartofthemaintenanceItmaintainsarepositoryintheSYSTEMtablespacetostorethehistoryoftheexecutionofallAnswer:AEWhichstatementsaretrueregardingtheconceptofproblemsandsinthefaultdiagnosabilityinfrastructureforOracleDatabase11g?(Chooseallthatapply.)OnlythemetadataanddumpsarestoredintheAutomaticDiagnosticRepositoryTheproblemkeyisthesameastheThedatabasesendsanalerttotheOracleEnterpriseManagerDatabaseHomeEveryproblemhasaproblemkey,whichisatextstringthatdescribestheThedatabasemakesanentryintothealertlogfilewhenproblemsandsAnswer:Whattwostatementsaretrueregardingthe mendationsreceivedfromtheSQLAccessAdvisor?(Choosetwo.)Itcannot mendationsthatsupportmultipleworkloadItcan mendpartitioningontablesprovidedthattheworkloadshavesomepredicatesandjoinsonthecolumnsoftheNUMBERorDATEtype.It mendpartitioningonlyontablesthathaveatleast10,000It mendonlyB-treeindexesandnotbitmaporfunction-basedAnswer:題目解答A能,D中索引都可以BCYouaremanagingOracleDatabase11gwithanASMstoragewithhighredundancy.Thefollowingcommandwasissuedtodropthedisksfromthedgadiskgroupafterfivehours:ALTERDISKGROUPdgaOFFLINEDISKSINFAILGROUPf2DROPAFTERWhichstatementistrueinthisItstartstheASMfastmirrorAllthedisksinthedgadiskgroupwouldbeOFFLINEandtheDISK_REPAIR_TIMEdiskattributewouldbesetto5hours.ItdropsalldiskpathsfromthedgadiskAllthedisksinthedgadiskgroupinfailuregroupf2wouldbeOFFLINEandtheDISK_REPAIR_TIMEdiskattributewouldbesetto5hours.Answer:參考 Usethedisk_offline_clausetotakeoneormoredisksoffline.Thisclausefailsiftheredundancylevelofthediskgroupwouldbeviolatedbytakingthespecifieddisksoffline.Specifydisk_nameasshownintheNAMEcolumnoftheV$ASM_DISKdynamicperformanceTheQUORUMandREGULAR havethesamesemanticshereastheyhavewhenaddingadisktoadiskgroup.Bydefault,OracleASMdropsadiskshortlyafteritistakenoffline.Youcandelaythisoperationbyspecifyingthetimeout_clause,whichgivesyoutheopportunitytorepairthediskandbringitbackonline.Youcanspecifythetimeoutvalueinunitsofminuteorhour.Ifyouomittheunit,thenthedefaultishour.Youcanchangethetimeoutperiodbyspecifyingthisclausemultipletimes.Eachtimeyouspecifyit,OracleASMmeasuresthetimefromthemostrecentpreviousdisk_offline_clausewhilethediskgroupismounted.TolearnhowmuchtimeremainsbeforeOracleASMwilldropanofflinedisk,querytherepair_timercolumnofV$ASM_DISK.Thisclauseoverridesanyprevioussettingofthedisk_repair_timeWhichstatementdescribesthesignificanceoftheCHANGEFAILUREcommandinRMAN?(Chooseallthatapply.)ItisusedtochangefailurepriorityonlyforHIGHorLOWItisusedtoexecutetheadvisedrepairItisusedtochangefailurepriorityonlyfortheCRITICALItisusedtoexplicitlyclosetheopenItisusedtoinformthedatabaseabouttherepairaftertherepairscriptAnswer:參考 Ifappropriate,youcanuseCHANGEFAILUREcommandatanytimeintheDataRecoveryAdvisorworkflowtochangethepriorityofafailurefromLOWtoHIGHorHIGHtoLOW,orcloseafailurethathasbeenfixedmanually.ChangingFailureStatusandInsomesituations,youmaywanttousetheCHANGEFAILUREcommandtoalterthestatusorpriorityofafailure.Forexample,ifablockcorruptionhasHIGHpriority,youmaywanttochangeittoLOWtemporarilyiftheblockisinalittle-usedtablespace.IfyourepairafailurebyameansotherthantheREPAIRFAILUREcommand,thenDataRecoveryAdvisorclosesitimplicitlythenexttimeyouexecuteLISTFAILURE.Forthisreason,youdonotnormallyneedtoexecutetheCHANGEFAILURE...CLOSEDcommand.Youshouldneedtousethiscommandonlyiftheautomaticfailurerevalidationfails,butyoubelievethefailurenolongerexists.IfyouuseCHANGEFAILUREtocloseafailurethatstillexists,thenDataRecoveryAdvisorre-createsitwithadifferentfailureIDwhentheappropriatedataintegritycheckisexecuted.Typically,youspecifythefailuresbyfailurenumber.YoucanalsochangefailuresinbulkbyspecifyingALL,CRITICAL,HIGH,orLOW.YoucanchangeafailuretoCLOSEDortoPRIORITYHIGHorPRIORITYLOW.TochangethestatusorpriorityofaListfailuresasdescribedin"ListingAllThefollowingexamplelistsonefailureinvolvingcorruptdatablocks.RMAN>LISTFAILURE;ListofDatabaseFailureIDPriority TimeDetected Oneormorenon-systemare containsoneormorecorruptblocksExecuteCHANGEFAILUREwiththedesiredThefollowingexamplechangesthepriorityofablockcorruptionfailurefromHIGHtoLOW.RMAN>CHANGEFAILURE101PRIORITYLOW;ListofDatabaseFailureIDPriority TimeDetected Datafile25:'/disk1/oradata/prod/example01.dbf'containsoneormorecorruptblocksDoyoureallywanttochangetheabovefailures(enterYESorNO)?YESchanged1failurestoLOWpriorityOptionally,executeLISTFAILUREALLtoviewtheIfyouexecuteLISTFAILUREwithoutALL,thenthecommandlistsfailureswithLOWpriorityonlyifnoCRITICALorHIGHpriorityfailuresexist.RMAN>LISTFAILUREListofDatabaseFailureIDPriority TimeDetected Oneormorenon-systemare containsoneormorecorruptblocks126.Which126.Whichstatementsaretrueregardingthecreationof packagefilebyusingtheEMWorkbenchSupport?(ChooseallthatYoucanaddorremovethetracefilestotheYoucancreatetheincrementalpackageZIPfilefornewormodifieddiagnosticinformationforthepackagealreadycreated.YoucanaddSQLtestcasestotheYoucannotcreateanincrementalpackagewhenthephysicalfilesarepurgedromtheAnswer:參考 AboutQuickPackagingandCustomTheEnterpriseManagerSupportWorkbenchprovidestwomethodsforcreatinganduploadinganpackage:thequickpackagingmethodandthecustompackagingmethod.QuickPackaging—Thisisthemoreautomatedmethodwithaminimumofsteps,organizedinaguidedworkflow(awizard).Youselectasingleproblem,provideapackagenameandandthenscheduleuploadofthepackagecontents,eitherimmediayorataspecifieddateandtime.TheSupportWorkbenchautomaticallycesdiagnosticdatarelatedtotheproblemintothepackage,finalizesthepackage,createsthezipfile,andthenuploadsthefile.Withthismethod,youdonothavetheopportunitytoadd,edit,orremovepackagefilesoraddotherdiagnosticdatasuchasSQLtestcases.However,itisthesimplestandquickestwaytogetfirst-failurediagnosticdatatoOracleSupport.Quickpackagingisthemethodusedintheworkflowdescribedin"Investigating,Reporting,andResolvingaProblem".Notethatwhenquickpackagingiscomplete,thepackagethatwascreatedbythewizardremains.YoucanthenmodifythepackagewithcustompackagingoperationsatalatertimeandmanuallyCustomPackaging—Thisisthemoremanualmethod,withmoresteps.ItisintendedforexpertSupportWorkbenchuserswhowantmorecontroloverthepackagingprocess.Withcustompackaging,youcancreateanewpackagewithoneormoreproblems,oryoucanaddoneormoreproblemstoanexistingpackage.Youcanthenperformavarietyofoperationsontheneworupdatedpackage,including:AddingorremovingproblemsorAdding,editing,orremovingtracefilesinthepackageAddingorremovingexternalfilesofanytypeAddingotherdiagnosticdatasuchasSQLtestManuallyfinalizingthepackageandthenviewingpackagecontentstodetermineifyoumusteditorremovesensitivedataorremovefilestoreducepackagesize.Youmightconducttheseoperationsoverseveraldays,beforedecidingthatyouhaveenoughdiagnosticinformationtosendtoOracleSupport.Withcustompackaging,youcreatethezipfileandrequestuploadtoOracleSupportastwoseparatesteps.Eachofthesestepscanbeperformedimmediayorscheduledforafuturedateandtime.10.SelecttheFullorIncrementaloptiontogenerateafullpackagezipfileoranincrementalpackagezipfile.Forafullpackagezipfile,allthecontentsofthepackage(originalcontentsandallcorrelateddata)arealwaysaddedtothezipfile.Foranincrementalpackagezipfile,onlythediagnosticinformationthatisnewormodifiedsincethelasttimethatyoucreatedazipfileforthesamepackageisaddedtothezipfile.Forexample,iftraceinformationwasappendedtoatracefilesincethatfilewaslastincludedinthegeneratedphysicalfileforapackage,thetracefileisaddedtotheincrementalpackagezipfile.Conversely,ifnochangesweremadetoatracefilesinceitwaslastuploadedforapackage,thattracefileisnotincludedintheincrementalpackagezipfile.Note:TheIncrementaloptionisdimmed(unavailable)ifanuploadfilewasnevercreatedfortheTheapplicationtablesownedbytheuserTESTinatestdatabaseneedtobeexportedtotheAPPSschemaintheproductiondatabasebyusingDataPump.WhichoptionofDataPumpImportwouldyouuseto plishthis?Answer:參考 Default:ThereisnodefaultLoadsallobjectsfromthesourceschemaintoatargetschema.SyntaxandDescriptionMultipleREMAP_SCHEMAlinescanbespecified,butthesourceschemamustbedifferentforeachone.However,differentsourceschemascanmaptothesametargetschema.Themapmaynotbe100percentcomplete,becausetherearecertainschemareferencesthatImportisnotcapableoffinding.Forexample,Importwillnotfindschemareferencesembeddedwithinthebodyofdefinitionsoftypes,views,procedures,andpackages.Iftheschemayouareremaptodoesnotalreadyexist,thentheimportoperationcreatesit,providedthatthedumpfilesetcontainsthenecessaryCREATEUSERmetadataforthesourceschema,andprovidedthatyouareimportingwithenoughprivileges.Forexample,thefollowingExportcommandscreatedumpfilesetswiththenecessarymetadatatocreateaschema,becauseth