單項(xiàng)選擇題

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

你可能感興趣的試題

單項(xiàng)選擇題

Using Oracle Scheduler you have scheduled two jobs， JOB_Aand JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）

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.

單項(xiàng)選擇題

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.

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？（）

你可能感興趣的試題

Using Oracle Scheduler you have scheduled two jobs， JOB_Aand JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）

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？（）

Using Oracle Scheduler you have scheduled two jobs， JOB_Aand JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）

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？（）