单项选择题

A. You cannot specify MEMORY_TARGET if you explicitly s……

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.

<上一题目录下一题>

热门试题

单项选择题You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?（）

A. RMAN reads the block change tracking file only when it performs the incremental level 0 backup.
B. RMAN reads the block change tracking file when it performs both incremental backups.
C. RMAN reads the block change tracking file only when it performs the incremental level 1 backup.
D. RMAN does not read the block change tracking file when it performs either incremental backup.

单项选择题You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent.Which type of backup should you perform?（）

A. standard backup set
B. image copy
C. compressed backup
D. user-managed backup

多项选择题WhichthreestatementsaboutperformanceanalysisbySQLPerformanceAnalyzeraretrue？（）

A. It detects changes in SQL execution plans.
B. It produces results that can be used to create the SQL plan baseline.
C. The importance of SQL statements is based on the size of the objects accessed.
D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
E. It shows only the overall impact on workload and not the net SQL impact on workload.

单项选择题You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）

A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING

单项选择题You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script： SQL>@utlu111i.sql Which statement about the execution of this script is true？（）

A. It must be executed from the Oracle Database 11g environment.
B. It must be executed only after the SYSAUX tablespace has been created.
C. It must be executed from the environment of the database that is being upgraded.
D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.