单项选择题

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...

单项选择题

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.

UsingOracleEnterpriseManagertosetSGApoolvaluesmanually，...

多项选择题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 ...

单项选择题

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

1Z0-053

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