多项选择题
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
相关考题
-
单项选择题
Verysoonyouwillbeperformingmaintenanceoperations.Youwouldhaveseveraljobstorunassoonasthemaintenanceperiodstarts.Whichmethodwouldyouusetocreatejobswithoutspecifyingthetimeperiodwhenthejobshouldberun？（）
A. use DBMS_IJOB package
B. use Oracle Scheduler
C. use DBMS_JOB package
D. use Oracle Data Pump Export and Import -
单项选择题
Amediafailurehasoccurred.Thishasresultedinallthemembersofthenextloggroupbeingrenderedinaccessibletothelogwriterprocess（LGWR）atalogswitch.Howdoesthisfailureaffecttheoperationaldatabase？（）
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. -
单项选择题
TheEMPLOYEEStableisstoredintheUSERStablespace.YouneedtocheckiftheEMPLOYEEStableisaffectedbytheblockcorruptionfoundintheUSERStablespace.Whichoptionwouldyouuse？（）
A. the RMAN LIST command
B. the DBNEWID utility
C. the RMAN REPORT command
D. the RMAN BLOCKRECOVER command
E. the RMAN CROSSCHECK command
F. the ANALYZE command
