网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives： Consumer group SALES with CPU_P1 as 60 and DEGREE_OF_PARALLELISM as 4. Consumer group MARKET with CPU_P1 as 20. Consumer group DEV with CPU_P1 as 20. Consumer group OTHERS with CPU_P1 as 0 and CPU_P2 as 100. Which two statements are correct in this scenario？ （）
A
The maximum degree of parallelism for the members of the consumer groups is 4.
B
The CPU allocation will always be equal for the consumer groups MARKET and DEV.
C
The OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.
D
The SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.
E
The maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.
参考答案
参考解析
解析：
暂无解析
更多 “多选题You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives： Consumer group SALES with CPU_P1 as 60 and DEGREE_OF_PARALLELISM as 4. Consumer group MARKET with CPU_P1 as 20. Consumer group DEV with CPU_P1 as 20. Consumer group OTHERS with CPU_P1 as 0 and CPU_P2 as 100. Which two statements are correct in this scenario？ （）AThe maximum degree of parallelism for the members of the consumer groups is 4.BThe CPU allocation will always be equal for the consumer groups MARKET and DEV.CThe OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.DThe SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.EThe maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.” 相关考题
考题
单选题You decided to change the location of the flash recovery area. You executed the following command： 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.
考题
单选题Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）A
functionsB
packageC
procedureD
database triggerE
anonymous PL/SQL block
考题
多选题Identify four uses of the Oracle Scheduler.（）Aenables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentBenables Oracle database to do patches according to a DBA-defined scheduleCenables you to schedule the execution of jobs based on timeDenables you to execute jobs in a clustered environmentEenables you to periodically execute operating systemscript files located on the same server as the databaseFenables you to create a job that makes use of saved programs and schedulesGenables you to automate the management of the jobs that are created using the DBMS_JOB package
考题
单选题You are specifying French case-insensitive sorts by using the NSL_SORT parameter for the user session of the user， Scott. Which value will you set for the NLS_SORT parameter？（）A
FRENCH_AIB
FRENCH_CIC
AI_FRENCHD
CI_FRENCH
考题
单选题You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）A
enable index monitoring and query the DBA_OBJECTS viewB
enable index monitoring and query the DBA_INDEXES viewC
enable index monitoring and query the V$OBJECT_USAGE viewD
enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
热门标签
最新试卷