多項(xiàng)選擇題

In Oracle 11g， which recommendations does the SQL Access Advisor generate？（）

A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations

你可能感興趣的試題

多項(xiàng)選擇題

Which three tasks can be performed using a duplicate database? （）(Choose three.)

A. Testing the backup and recovery procedures
B. Testing the upgrade of an Oracle database to a new release
C. Testing the effect of an application changes on database performance
D. Continuously updating archive log files from the target database to support failover

單項(xiàng)選擇題

Examine the CREATE DISKGROUP command used to create a disk group:
SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY
DISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2;
In which situation would you use this method of disk group creation?（）

A. When two-way disk mirroring is required for the allocation units
B. When three-way disk mirroring is required for the allocation units
C. When using hardware mirroring or RAID
D. When disk mirroring is required for the Automatic Storage Management (ASM) disks

In Oracle 11g， which recommendations does the SQL Access Advisor generate？（）

你可能感興趣的試題

Which three tasks can be performed using a duplicate database? （）(Choose three.)

Examine the CREATE DISKGROUP command used to create a disk group: SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2; In which situation would you use this method of disk group creation?（）

In Oracle 11g， which recommendations does the SQL Access Advisor generate？（）

Examine the CREATE DISKGROUP command used to create a disk group:
SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY
DISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2;
In which situation would you use this method of disk group creation?（）