单项选择题
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
相关考题
-
多项选择题
WhataretherecommendationsforOracleDatabase11ginstallationtomakeitOptimalFlexibleArchitecture（OFA）-compliant？（）
A. ORACLE_BASE should be set explicitly.
B. An Oracle base should have only one Oracle home created in it.
C. Flash recovery area and data file location should be on separate disks.
D. Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management （ASM） setup. -
单项选择题
Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?（）
A. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically
B. It will be successful only if the memory is available from the auto tuned components
C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET
D. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE -
单项选择题
You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands： RMAN> CONNECT TARGET sys/sys@APPPROD RMAN> CONNECT AUXILIARY sys/sys@DUPDB RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE PASSWORD FILE SPILE NOFILENAMECHECK； What are the implications of this command？（）
A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.
B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.
C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.
D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
