單項選擇題

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

你可能感興趣的試題

單項選擇題

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.

單項選擇題

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.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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