单选题Which statement is true regarding the creation of nested plans using Resource Manager？（）A Only one nested subplan is allowed.B The plans can be nested up to four levels.C Resource Manager does not support nested plans.D Nested plans control only the degree of parallelism but not the CPU.E Each nested plan gets a proportion of the CPU resources assigned to its parent group.
单选题
Which statement is true regarding the creation of nested plans using Resource Manager？（）
A
Only one nested subplan is allowed.
B
The plans can be nested up to four levels.
C
Resource Manager does not support nested plans.
D
Nested plans control only the degree of parallelism but not the CPU.
E
Each nested plan gets a proportion of the CPU resources assigned to its parent group.
参考解析
解析：
暂无解析
相关考题：
单选题You are performing a backup of your database across the network. While taking the backup， you want to save space on the storage media and reduce the network bandwidth. Which command will you issue to configure the required type of backup？（）A CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO BACKUPSET；B CONFIGURE DEVICE TYPE TO disk BACKUP TYPE TO COPY；C CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED BACKUPSET；D CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED COPY；
单选题A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A Flash back all the tables in the data file， one by one.B Restore the data file to a new location and perform a media recovery.C Flash back the database， there is no need to restore the data file.D Restore the data file from the most recent backup and flash the database.
多选题You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？（）AThe WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.BThe Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.CSetting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.DThe SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
单选题The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（）A The database will hang.B The database will be crashed.C The database will be shut down.D The LGWR process writes redo log entries to the other redo log member of the Group2 group
单选题From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users. Which method would you use to achieve this objective？（）Acreate a plan directive in the SYS_GROUPBcreate the pending area for the consumer groupCactivate the provided SYSTEM_PLAN in Resource ManagerDset the TIMED_STATISTICS parameter to TRUE in the parameter fileEset the execution time limit for all users， except SYS and SYSTEM， in their profiles
单选题You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command： RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS； When a backup is performed， what would be the status of this backup after seven days？（）A The backup would be marked as invalid.B The backup would be marked as obsolete.C The backup would be removed from the media.D The backup would be removed from the RMAN repository.
单选题The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN REPORT OBSOLETE; What would you see in the output？（）Aa list of all the expired backups and copiesBa list of all those files that have been deleted in the last two daysCa list of all those files that have been recovered within the last two daysDa list of backups and copies that are outside the range covered by the current retention policy
单选题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 parameterB modify the PGA_AGGREGATE_TARGET initialization parameterC modify the WORK_AREASIZE_POLICY initialization parameterD increase the value of the SGA_TARGET initialization parameterE increase the value of the SGA_MAX_SIZE initialization parameterF increase the value of the SORT_AREA_SIZE initialization parameter
多选题You have created a job class， CUST_JOB_1， with two jobs， CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true？ （）AThe member jobs would get dropped when the job class is dropped.BBoth the jobs would be executed concurrently.CThe member jobs would get disabled when the job class is dropped.DThe attributes defined at the class level would be applied to both the jobs.EJobs in the job class must have been assigned the same priority.