Which three statements are true about adaptive SQL plan management?

Adaptive SQL plan management adds better plans as non-fixed accepted plans, not as fixed plans; fixed plans are set explicitly by a DBA to lock down a specific execution path.

When the optimizer finds a non-accepted plan that performs better than the current accepted baseline plan, adaptive SQL plan management automatically promotes it to accepted status, making it usable by the optimizer without a manual evolve operation.

In COMPREHENSIVE mode, the automated maintenance task runs the verification process on non-accepted plans, executing each candidate against real workload to compare its performance to the accepted plan before accepting it.

Non-accepted plans stored in a SQL plan baseline are automatically evolved in COMPREHENSIVE mode, meaning the system tests their performance against the accepted plan and promotes them if they are demonstrably faster.