移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? ()

发布日期:2021-11-25

You perform the following activities during the da...
A

to minimize plan regression due to the use of a new optimizer version

B

to completely avoid the use of new plans generated by a new optimizer version

C

to prevent plan capturing when the SQL statement is executed after the database upgrade

D

to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!