Which three statements are true about SQL plan directives?()A. They are tied to a specific statement or SQL id.B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.C. They are used

题目
Which three statements are true about SQL plan directives?()

A. They are tied to a specific statement or SQL id.

B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.

C. They are used to gather only missing statistics.

D. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.

E. They instruct the optimizer to create only column group statistics.

F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

相似考题

1.Believe it or not, Linda’s ( ) son can play the piano now.A、three-years oldB、three-year-oldC、three-year old

2.Youexecutethefollowingblockofcode：SQL>BEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN（SIMPLE_PLAN=>’DEPARTMENTS’，CONSUMER_GROUP1=>’PAYROLLL’，GROUP1_CPU=>50，CONSUMER_GROUP2=>’SALES’，GROUP2_CPU=>25，CONSUMER_GROUP3=>’MARKETING’，GROUP3_CPU=>25）；END；SQL>/Whatisaprerequisiteforusingthesimpleresourceplancreatedbyexecutingtheabovecode？（）A.Youmustassignuserstoconsumergroups.B.Youmustgranttheswitchprivilegetotheusers.C.Youmustcreatearesourceplandirective.D.Youmustspecifythecomplexresourceplan.

3.Youupdatedtheresourceplandirectivefortheresourceconsumergroup，DSS_USERS.TheresourceplandirectiveisassignedtotheDSS_PLANbyusingthefollowingstatement：SQL>EXECDBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE（PLAN=>’DSS_PLAN’，GROUP_OR_SUBPLAN=>’DSS_USERS’，NEW_CPU_P1=>80，NEW_SWITCH_GROUP=>’CANCEL_SQL’，NEW_SWITCH_ESTIMATE=>TRUE，NEW_SWITCH_TIME=>600）；Auserconnectstothedatabaseandstartsanoperation.WhatistheoutcomeifOracleestimatesthattheexecutiontimeforthisoperationwillexceed600seconds？（）

4.Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements.What would you do with these SQL statements?（）A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.B. Capture the plans from the previous version using STS and then load them into the stored outline.C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

更多“Which three statements are true about SQL plan directives?() ”相关问题

  • 第1题：

    TheDatabaseResourceManagerisnotcurrentlyactiveinyourdatabasethatisupandrunning.YoucreatedaresourceplannamedDAY_PLANthatcontainstwosub-plansnamedMANAGERS_PLANandCLERKS_PLAN.YoudecidedtoactivateDAY_PLANbyexecutingthefollowingstatement：SQL>ALTERSYSTEMSETRESOURCE_MANAGER_PLAN=’managers_plan’；Whatwillbetheoutcomeofthisstatement？（）

    A.ThestatementwilldeactivateDAY_PLAN.

    B.ThestatementwillactivateDAY_PLANasthetopplan.

    C.ThestatementwillactivateMANAGERS_PLANasthetopplan.

    D.ThestatementwillreturnanerrorbecauseMANAGERS_PLANisnotthetopplan.


    参考答案：C

  • 第2题：

    The following parameter are set for your Oracle 12c database instance:OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSEOPTIMIZER_USE_SQL_PLAN_BASELINES=TRUEYou want to manage the SQL plan evolution task manually. Examine the following steps:1. Set the evolve task parameters.2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASKfunction.4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.Identify the correct sequence of steps:（）

    A.2，4，5

    B.2，1，4，3，5

    C.1，2，3，4，5

    D.1，2，4，5


    参考答案：B

  • 第3题：

    戴明循环执行顺序，下面哪项正确?

    A、.PLAN-ACT-DO-CHECK

    B、CHECK-PLAN-ACT-DO

    C、PLAN-DO-CHECK-ACT

    D、ACT-PLAN-CHECK-DO


    答案：C

  • 第4题：

    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.


    参考答案：D

  • 第5题：

    Despite the wonderful acting and well-developed plot the _________ movie could not hold our attention.

    A) three-hours B) three-hour

    C) three-hours’ D) three-hour’s

     

     


    选B

     用破折号连接的作形容词不用复数.

  • 第6题：

    Which of these correctly identifies the six phases of the Cisco Lifecycle Services framework? ()

    A. Prepare, Plan, Create, Implement, Operate, and Improve

    B. Prepare, Plan, Design, Implement, Operate, and Optimize

    C. Prepare, Plan, Design, Apply, Operate, and Manage

    D. Prepare, Plan, Design, Implement, Operate and Manage


    参考答案：B

相关内容