单项选择题
Your database is running on the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）
A. modify the HASH_AREA_SIZE initialization parameter
B. modify the PGA_AGGREGATE_TARGET initialization parameter
C. modify the WORK_AREASIZE_POLICY initialization parameter
D. increase the value of the SGA_TARGET initialization parameter
E. increase the value of the SGA_MAX_SIZE initialization parameter
F. increase the value of the SORT_AREA_SIZE initialization parameter
相关考题
-
单项选择题
UsingOracleScheduleryouhavescheduledtwojobs，JOB_AandJOB_B，torunat9：00p.m.everyFriday.Youwantboththejobstouseasingleresourceplan，WEEKEND_PLAN.Whichtaskmusthavealreadybeenperformedtoenableyoutoachievethisobjective？（）
A. A window must have been created with the WEEKEND_PLAN resource plan.
B. A program must have been created with the WEEKEND_PLAN resource plan.
C. A job class must have been created with the WEEKEND_PLAN resource plan.
D. A window group must have been created with the WEEKEND_PLAN resource plan. -
单项选择题
You decided to change the location of the flash recovery area. You executed the following command： ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’； Which statement is true？（）
A. The location can be changed only if the flash recovery area is empty.
B. After executing the command， all new flash recovery area files will be created in the new location.
C. The command will generate an error because you cannot change the flash recovery area while the database is open.
D. All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location. -
单项选择题
Intheparameterfileofyourproductiondatabase，theCONTROL_FILE_RECORD_KEEP_TIMEparameterissetto31.WhatwouldbetheimpactofthissettingonthebackupthatisbeingperformedbyusingRecoveryManager（RMAN）？（）
A. The backup would be retained on the media for 31 days.
B. The backup would be maintained in the recovery catalog for 31 days.
C. The backup metadata would be retained in the control file for 31 days.
D. The backup metadata would be maintained in the recovery catalog for 31 days.
E. Automatic backups of the control file will be retained in the flash recovery area for 31 days.
