Which three are the valid statements in relation to SQL plan baselines?(Choose three.)
A. The plans generated for every SQL statement are stored in the SQL plan baseline by default.
B. The plans can be manually loaded to the SQL plan baseline.
C. The plan baselines are stored temporarily in the memory as long as the database instance is running.
D. The plans in the SQL plan baseline are verified and accepted plans.
E. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
Answer: B D E
哪三个有效陈述与SQL计划基线有关？
A、SQL语句生成的计划默认存储在SQL计划基线；
B、计划可以手动加载到SQL计划基线；
C、在数据库实例运行时，计划基线暂时储存在内存中；
D、SQL计划基线中的计划是已经验证和接受的计划；
E、对于优化器访问SQL计划基线，SYSAUX表空间必须在线；来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2125073/ ，如需转载，请注明出处，否则将追究法律责任。
