单项选择题

In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）

A. Setting a nonzero value for SGA_TARGET
B. Configuring Automatic Shared Memory Management
C. Configuring Automatic Memory Management
D. Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
E. None of the above

点击查看答案

上一题目录下一题

相关考题

单项选择题

You are managing an ASM instance. You previously issued the following statements:
ALTER DISKGROUP dg1 DROP DISK disk2;
ALTER DISKGROUP dg1 DROP DISK disk3;
ALTER DISKGROUP dg1 DROP DISK disk5;
You want to cancel the disk drops that are pending for the DG1 disk group.
Which statement should you issue?（）

A. ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;
B. ALTER DISKGROUP dg1 UNDROP;
C. ALTER DISKGROUP dg1 UNDROP DISKS;
D. You cannot cancel the pending disk drops.

多项选择题

Using Oracle Enterprise Manager to set SGA pool values manually， for which of the following pools does Oracle EM offer advice to set the value appropriately？（）

A. DB_CACHE_SIZE
B. SHARED_POOL_SIZE
C. LARGE_POOL_SIZE
D. JAVA_POOL_SIZE
E. SGA_MAX_SIZE
F. SORT_AREA_SIZE

单项选择题

You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online.
Which statement about performing user-managed backups in a 24x7 environment is true?（）

A. You must have change tracking enabled in your database
B. Your database must be running in NOARCHIVELOG mode
C. To back up a tablespace, it must be in backup mode
D. To back up a tablespace, it must first be taken offline