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.
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.
相关考题：
Believe it or not, Linda’s ( ) son can play the piano now. A、three-years oldB、three-year-oldC、three-year old
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.
Youexecutethefollowingblockofcode：SQLBEGINDBMS_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.
Youupdatedtheresourceplandirectivefortheresourceconsumergroup，DSS_USERS.TheresourceplandirectiveisassignedtotheDSS_PLANbyusingthefollowingstatement：SQLEXECDBMS_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？（）
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.
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.
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，5B.2，1，4，3，5C.1，2，3，4，5D.1，2，4，5
Despitethewonderfulactingandwell-developedplotthe_________moviecouldnotholdourattention.A)three-hoursB)three-hourC)three-hours’D)three-hour’s
Which of these correctly identifies the six phases of the Cisco Lifecycle Services framework? () A. Prepare, Plan, Create, Implement, Operate, and ImproveB. Prepare, Plan, Design, Implement, Operate, and OptimizeC. Prepare, Plan, Design, Apply, Operate, and ManageD. Prepare, Plan, Design, Implement, Operate and Manage