单项选择题
Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?()
A. Segment Advisor
B. SQL Access Advisor
C. Undo Advisor
D. SQL Tuning Advisor
相关考题
-
单项选择题
WhichcommandisusedtoconfigureRMANtoperformacompressedbackupforeverybackupexecuted?()
A. BACKUP AS COMPRESSED BACKUPSET DATABASE
B. BACKUP AS COMPRESSED COPY OF DATABASE
C. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
D. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS
E. BACKUP DATABASE COMPRESS
-
单项选择题
Which statement about Automatic Memory Management with Oracle 11g is true?()
A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.
B. Oracle can reallocate memory between the SGA and PGA automatically as needed.
C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size -
多项选择题
For which two situations would you use functionality provided by the Resource Manager? ()(Choose two.)
A. setting idle timeout limits on resource plans
B. saving storage space by using compressed backup sets
C. creating jobs that will run automatically at a scheduled time
D. assigning priorities to jobs to manage access to system resources
E. creating alerts to perform notification when tablespaces are low on available space resources
