多项选择题

To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）

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

相关考题

Using the LIST command in Recovery Manager (RMAN), whic...

多项选择题Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?（） (Choose two.)

A. stored scripts in the recovery catalog.
B. backups that can be deleted from disk.
C. backup sets and image copies are obsolete.
D. backups that do not have the AVAILABLE status in the RMAN repository.

ForOracle11g，Oraclestronglyrecommendsthatyouconfigureyo...

单项选择题For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）

A. Automatic PGA Memory Management
B. Automatic SGA Memory Management
C. Automatic Shared Memory Management
D. Automatic Memory Management
E. Manual SGA Memory Management
F. None of the above

Observe the structure of the table employees: The tabl...

单项选择题

Observe the structure of the table employees:

The table contains 8475 records.
One of the employees wants to know the names of all employees of the company. For this, he fires the following query:
SELECT * FROM EMPLOYEES ORDER BY emp_fname;
Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.
Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?（）

A. Rollback segment
B. Temporary segment
C. Data segment
D. Index segment

1Z0-053

To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）