多项选择题
While deploying a new application module，the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced.
Which two statements describe the consequences？（）
A. The plan baselines can be evolved over time to produce better performance.
B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
相关考题
-
单项选择题
The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You 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_TASK function. 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 -
单项选择题
Given： What is the result？（）
A.TestA
B.TestB
C.Compilation fails.
D.An exception is thrown at runtime. -
问答题
“文学革命”在创作上主要有哪些成就与收获？
