单项选择题

View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?（）

A. Accept the recommended SQL profile.
B.Collect statistics for the related objects.
C. Run the Access Advisor for the SQL statement.
D. Run the Segment Advisor for recommendations.

<上一题目录下一题>

热门试题

单项选择题

The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）

A. statistics recommendations
B. SQL Profile recommendations
C. Index-related recommendations
D. restructuring of SQL recommendations

单项选择题

During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?（）

A. The installation terminates with an error.
B. The installation proceeds with the default value without warnings and errors.
C. The installation proceeds with the default value but it would not be an OFA-compliant database.
D. The installation proceeds with the default value but a message would be generated in the alert log file.