OCP 1z0-050_11

FreeExamKing1Z0-050Actualtests.com-ThePowerofKnowingQUESTION1:IdentifytwosituationsinwhichyoucanuseDataRecoveryAdvisorforrecovery.(Choosetwo.)A.Theuserhasdroppedanimportanttablethatneedstoberecovered.B.Thedatabasefilesarecorruptedwhenthedatabaseisopen.C.Youarenotabletostartupthedatabaseinstancebecausetherequireddatabasefilesaremissing.D.Thearchivedlogfilesaremissingforwhichbackupisnotavailable.Answer:B,CQUESTION2:Inyourdatabase,theLDAP_DIRECTORY_SYSAUTHinitializationparameterhasbeensettoYESandtheuserswhoneedtoaccessthedatabaseasDBAshavebeengrantedSYSDBAenterpriseroleinOracleInternetDirectory(OID).SSLandthepasswordfilehavebeenconfigured.AuserSCOTTwiththeSYSDBAprivilegetriestoconnecttothedatabaseinstancefromaremotemachineusingthecommand:$SQLPLUSscott/[e-mail]dwouldbeusedfirst?A.authenticationbyusingthelocalOSofthedatabaseserverB.authenticationbyusingtheOracleInternetDirectoryC.authenticationbypasswordfileD.authenticationbyusingcertificatesoverSSLAnswer:CQUESTION3:ExaminethefollowingvaluesoftheinitializationparametersinthedatabasehavingtheSIDORCL:BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdumpUSER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udumpCORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdumpDIAGNOSTIC_DEST=Theenvironmentvariableshavethefollowingvalue:ORACLE_BASE=/u01/app/oracleORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1WhatisthelocationoftheAutomaticDiagnosticRepository(ADR)home?A./u01/app/oracle/product/11.1.0/db_1Page1FreeExamKing1Z0-050Actualtests.com-ThePowerofKnowingB./u01/app/oracleC.$ORACLE_HOME/bdumpD.$ORACLE_HOME/logAnswer:BQUESTION4:ObservethefollowingPL/SQLblock:BEGINdbms_spm.configure('SPACE_BUDGET_PERCENT',30);END;WhichstatementiscorrectregardingtheabovePL/SQLblock?A.ItautomaticallypurgestheSQLmanagementobjectswhenSMBoccupiesmorethan30%oftheSYSAUXtablespace.B.Itreserves30%ofthespaceintheSYSAUXtablespaceforSQLManagementBase(SMB).C.Itreserves30%ofthespaceintheSYSTEMtablespaceforSMB.D.ItgeneratesaweeklywarninginthealertlogfilewhenSMBoccupiesmorethan30%oftheSYSAUXtablespace.Answer:DQUESTION5:Exhibit:Page2FreeExamKing1Z0-050Actualtests.com-ThePowerofKnowingViewtheExhibittoexaminetheoutputproducedbythefollowingqueryatthreedifferenttimessincethedatabaseinstancestartedandhasundergoneworkloadsofdifferentcapacities:SQLSELECTsubstr(component,0,10)COMP,current_sizeCS,user_specified_sizeUSFROMv$memory_dynamic_componentsWHEREcurrent_size!=0;Whatdoyouinferfromthis?A.Allsessionsareconnectedtothedatabaseinstanceindedicatedmode,andnoRMANorparallelqueryoperationshavebeenperformed.B.Thedatabaseinstanceisrunningwithmanualsharedmemorymanagement.C.ThedatabaseinstanceisrunningwithmanualPGAmanagement.D.ThedatabaseinstancehastheMEMORY_TARGETvaluesettoanonzerovalue.Answer:DPage3FreeExamKing1Z0-050Actualtests.com-ThePowerofKnowingQUESTION6:YouaremanaginganOracleDatabase11gASMinstancehavingthreedisksinadiskgroupwithASMcompatibilityattributesetto11.1.0andredundancysettohigh.Oneofthedisksinthediskgroupbecomesunavailablebecauseofpowerfailure.Whichstatementswillbetrueinthisscenario?(Chooseallthatapply.)A.Thediskisimmediatelydroppedfromthediskgroup.B.TheASMtrackstheextentsthataremodifiedduringtheoutage.C.TheASMmigratestheextentsfromtheunavailabledisktotheremainingdisks.D.Thediskautomaticallygoesoffline.Answer:B,DQUESTION7:TheSQLTuningAdvisorhasbeenconfiguredwithdefaultconfigurationsinyourdatabaseinstance.WhichrecommendationisautomaticallyimplementedwithouttheDBA'sinterventionaftertheSQLTuningAdvisorisrunaspartoftheAUTOTASKframework?A.statisticsrecommendationsB.SQLprofilerecommendationsC.restructuringofSQLrecommendationsD.index-relatedrecommendationsAnswer:BQUESTION8:Exhibit:Page4FreeExamKing1Z0-050Actualtests.com-ThePowerofKnowingViewtheExhibittoexaminetheAutomaticDatabaseDiagnosticMonitor(ADDM)tasks.Youexecutedthefollowingcommands:SQLVARtnameVARCHAR2(60);SQLBEGIN:tname:='my_instance_analysis_mode_task';DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE(:tname,'Sg_directive','SCOTT');END;Whichstatementdescribestheconsequence?A.AllsubsequentADDMtasksincludingmy_instance_analysis_mode_taskarefilteredtosuppresstheSegmentAdvisorsuggestionsfortheSCOTTschema.B.TheADDMtaskisfilteredtoproducetheSegmentAdvisorsuggestionsfortheSCOTTschemaonly.C.TheADDMtaskisfilteredtosuppresstheSegmentAdvisorsuggestionsfortheSCOTTschema.D.ThePL/SQLblockproducesanerrorbecausethemy_instance_analysis_mode_tasktaskhasnotbeenresettoitsinitialstate.Answer:DQUESTION9:Page5FreeExamKing1Z0-050Actualtests.com-ThePowerofKnowingWhichstatementsaretrueregardingtablecompression?(Chooseallthatapply.)A.Itsavesdiskspaceandreducesmemoryusage.B.Itsavesdiskspacebuthasnoeffectonmemoryusage.C.ItincursextraCPUoverheadduringDMLaswellasdirectloadingoperations.D.ItincursextraCPUoverheadduringDMLbutnotdirectloadingoperations.E.ItrequiresuncompressoperationduringI/O.Answer:A,CQUESTION10:YouareworkingasaDBAonthedecisionsupportsystem.Thereisabusinessrequirementtotrackandstorealltransactionsforatleastthreeyea