多項選擇題

You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below：
SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB
SHARED_POOL_SIZE = 3GB
Which two statements are correct in this scenario？（）

A. A total of 14 GB memory will be allocated to the automatically tuned memory components
B. Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
C. The value for SGA_TARGET can be increased up to a maximum of 14 GB
D. A maximum of 3 GB can be allocated to shared pool
E. Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
F. Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE

你可能感興趣的試題

單項選擇題

Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）

A. use DBMS_IJOB package
B. use Oracle Scheduler
C. use DBMS_JOB package
D. use Oracle Data Pump Export and Import

單項選擇題

A media failure has occurred. This has resulted in all the members of the next log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）

A. The database allows only queries； no other statements are allowed.
B. The database re-creates the missing redo log files automatically.
C. The database continues to function normally with the existing files.
D. The database returns an error and the database instance shuts down.
E. The user sessions that generate redo logs are terminated automatically.

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below： SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario？ （）

你可能感興趣的試題

Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）

A media failure has occurred. This has resulted in all the members of the next log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below：
SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB
SHARED_POOL_SIZE = 3GB
Which two statements are correct in this scenario？（）

Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）