合同义务转移的效力表现在()。

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.

A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set

B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set

C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set

D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup

A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set

B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set

C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set

D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup

A. set SHARED_POOL_SIZE to zero

B. set STATISTICS_LEVEL to BASIC

C. set SGA_TARGET to a non-zero value

D. set DB_CACHE_SIZE to a non-zero value

E. set STATISTICS_LEVEL to TYPICAL or ALL

thePGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true？（）

A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE

B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA

C. The database instance starts, but Automatic Memory Management is disabled

D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true？（）

A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE

B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA

C. The database instance starts, but Automatic Memory Management is disabled

D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

aded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance？（）

A. Enable Memory Access Mode, which reads performance data from SGA.

B. Use emergency monitoring to fetch data directly from SGA analysis.

C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring.

E. Run ADDM in diagnostic mode.

ER TABLE subscribe log STORAGE (BUFFER_POOL recycle);You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.What could be a reason for this recommendation？（）

A. The keep pool is not configured.

B. Automatic Workarea Management is not configured.

C. Automatic Shared Memory Management is not enabled.

D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.

E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view

A. Enable supplemental logging for the database.

B. Specify undo retention guarantee for the database

C. Create Flashback Data Archive in the tablespace where the tables are stored.

D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables