单项选择题

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.

多项选择题

Which two statements are true regarding the functionality of the remap command in ASMCMD?（）

A. It repairs blocks that have read disk I/O errors.
B. It checks whether the alias metadata directory and the file directory are linked correctly.
C. It repairs blocks by always reading them from the mirror copy and writing them to the original location.
D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.

多项选择题

Examine the following RMAN command:

Which two statements are true regarding the backup taken by using the above RMAN command?（）

A. Only data files and the control file are backed up.
B. Archived redo logs are backed up only I f the database is open during the backup.
C. The backup is deleted after one day, regardless of the default retention policy settings.
D. The backup becomes obsolete after one day, regardless of the default retention policy settings.