ExaminethefollowingPL/SQLblock：SETSERVEROUTPUTONSETLONG10000ECLAREreportclob；BEGINreport：=DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）；DBMS_OUTPUT.PUT_LINE（report）；END；WhichstatementdescribestheeffectoftheexecutionoftheabovePL/SQLblock？（）A.Theplanbaselinesareverif

题目

ExaminethefollowingPL/SQLblock：SETSERVEROUTPUTONSETLONG10000ECLAREreportclob；BEGINreport：=DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）；DBMS_OUTPUT.PUT_LINE（report）；END；WhichstatementdescribestheeffectoftheexecutionoftheabovePL/SQLblock？（）

A.TheplanbaselinesareverifiedwiththeSQLprofiles.

B.Allfixedplanbaselinesareconvertedintononfixedplanbaselines.

C.AllthenonacceptedSQLprofilesareacceptedintotheplanbaseline.

D.ThenonacceptedplansintheSQLManagementBaseareverifiedwiththeexistingplanbaselines.

相似考题

1.WhichtypeofPL／SQLconstructwouldyouusetoautomaticallycorrecttheerrorresultingfromastatementthatwassuspendedduetoaspacerelatedproblem?()A.functionB.packageC.procedureD.databasetriggerE.anonymousPL/SQLblock

2.ExaminethefollowingPL/SQLblock：DECLAREmy_planspls_integer；BEGINmy_plans：=DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE（sql_id=>？9twu5t2dn5xd？；END；WhichstatementistrueabouttheplanbeingloadedintotheSQLplanbaselinebytheabovecommand？（）A.ItisloadedwiththeFIXEDstatus.B.ItisloadedwiththeACCEPTEDstatus.C.ItisnotloadedwiththeENABLEDstatus.D.ItisnotloadedwiththeACCEPTEDstatus.

3.WhichtypeofPL／SQLconstructwouldyouusetoautomaticallycorrecttheerrorresultingfromastatementthatwassuspendedduetoaspace－relatedproblem?()A.functionsB.packageC.procedureD.databasetriggerE.anonymousPL/SQLblock

4.Which statement describes the effect of the execution of the above PL／SQL block?()A. The plan baselines are verified with the SQL profiles.B. All fixed plan baselines are converted into nonfixed plan baselines.C. All the nonaccepted SQL profiles are accepted into the plan baseline.D. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.

更多“ExaminethefollowingPL／SQLblock:SETSERVEROUTPUTONSETLONG10000ECLAREreportclob;BEGINreport:= ”相关问题

  • 第1题：

    YouobservethatinyourPRODdatabase，customerinformationisbeingmodifiedbysomeunauthorizedusers.YouwanttokeeptrackofallofthetransactionshappeningonthetableusingPL/SQL.WhichtypeofPL/SQLsubprogramorconstructwouldyouusetoaccomplishthistask？（）

    A.functions

    B.packages

    C.procedures

    D.databasetriggers

    E.anonymousPL/SQLblock


    参考答案：D

相关内容