单项选择题
A. The index is not used by the optimizer but is maintained during DML operations.
B. The index is not used by the optimizer and is not maintained during DML operations.
C. The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.
D. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.
单项选择题 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? ()
单项选择题 Which statement about using RMAN stored scripts is true?()
单项选择题 Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?()