单项选择题
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 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 -
单项选择题
BysettingthevalueofMEMORY_TARGETtozeroandsettingthevalueofSGA_TARGETtoanonzerovalue，youwillenablewhichofthefollowingmemory-managementoptions？（）
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 -
单项选择题
WhichofthefollowingOraclefeaturesisenabledbysettinganonzerovaluefortheMEMORY_TARGETinitializationparameter？（）
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
