多项选择题
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), 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，Oraclestronglyrecommendsthatyouconfigureyourdatabasetousewhichofthefollowingmemory-managementfeatures？（）
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 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
