单选题Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this

题目

单选题

Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）

The user must have been granted the DBA role.

The user must have been granted the switch privilege as a part of a role.

The user must have been granted the Resource Manager administrator privilege.

The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives： Consumer group SALESwith CPU_P1as 60 and DEGREE_OF_PARALLELISMas 4. Consumer group MARKETwith CPU_P1as 20. Consumer group DEVwith CPU_P1as 20. Consumer groupOTHERSwith CPU_P1as 0 and CPU_P2as 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.

正确答案:C,E

第2题：

A companys computer policy dictates that all users workstations must use the companys corporate web page as their default home page. Which of the following methods should an administrator use to BEST comply with this policy？（）

A、 Configure a logon script to set the homepage at logon.
B、 Set the default homepage to the corporate website in Group Policy.
C、 Manually configure the homepage on all workstations and setup trace logs to ensure compliance.
D、 Set the default homepage to the corporate website on the base computer image.

正确答案:B

第3题：

Your network contains a Windows Server Update Services (WSUS) server.You have an organizational unit (OU) named Sales. The Sales OU contains all of the computer objects for the sales department. You enable client-side targeting for the Sales OU and set the target group name to Sales-Computers.You restart a sales computer.You discover that the computer is not added to the Sales-Computer computer group in WSUS.You need to ensure that all sales computers are added to the Sales-Computers group.Which options should you configure?（）

A. Automatic Approvals

B. Computers

C. Personalization

D. Products and Classifications

参考答案：B

第4题：

From the V$SESSION_LONGOPS view， you find that some of the database users have long/x7frunning 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？（）

A、create a plan directive in the SYS_GROUP
B、create the pending area for the consumer group
C、activate the provided SYSTEM_PLAN in Resource Manager
D、set the TIMED_STATISTICS parameter to TRUE in the parameter file
E、set the execution time limit for all users， except SYS and SYSTEM， in their profiles

正确答案:C

第5题：

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h'; To which disks in the disk group will the new value be applicable?（）

A、all disks in the disk group
B、all disks that are currently in OFFLINE mode
C、all disks that are not currently in OFFLINE mode
D、all disks in the disk group only if all of them are ONLINE

正确答案:C

第6题：

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.

正确答案:C,E

第7题：

You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group？（）

A、 CPU_MTH
B、 NEW_CPU_MTH
C、 CPU_P1
D、 CPU_P2

正确答案:A

第8题：

You are the administrator of the homeoffice.local domain. You want to create a shared printer for the company's executives so that they do not have to wait for their documents to print when the default printer's queue contains a large number of documents.

You configure the new high-priority printer and want to set permissions for the groups shown in the exhibit. Note: The default settings have been cleared.

You select the check box to allow Print permission for the Executives group. You want only the Administrators, Print Operators, Server Operators, and Executives group to be able to print to the printer. What can you do? (Select all that apply).

A．Remove the Everyone group.

B．Select the check box to deny Print permission for the Everyone group.

C．Select the check box to deny Manage Documents permission for Everyone group.

D．Select all Deny check boxes for the Everyone group.

E．Clear all check boxes for Everyone group.

正确答案：AE
解析：Explanation: By default the Everyone group, to which all users are automatically added, has access to printer. Therefore, by removing the Everyone group, only the groups that have been explicitly been given permission to the printer would be able to use the printer. The same could be achieved by removing all permissions from the Everyone group.
Incorrect answers:
B: When a user has conflicting permissions to network resources as a result to his or her membership to one or more groups, the most restrictive permission is applied. However, a deny permission overrides all other permissions. All users are automatically added to the Everyone group therefore the deny print permission applied to the Everyone group will be inherited by all users and would override their other permissions to the printer. All users would then not be able to print.

C: When a user has conflicting permissions to network resources as a result to his or her membership to one or more groups, the most restrictive permission is applied. However, a deny permission overrides all other permissions. All users are automatically added to the Everyone group therefore the deny manage documents permission applied to the Everyone group will be inherited by all users and would override their other manage documents permissions to the printer. This will however not prevent all users from be able to use the printer.

D: When a user has conflicting permissions to network resources as a result to his or her membership to one or more groups, the most restrictive permission is applied. However, a deny permission overrides all other permissions. All users are automatically added to the Everyone group therefore the deny permissions are applied to the Everyone group will be inherited by all users and would override their other permissions to the printer. All users would then not have access to the printer.

第9题：

You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours： ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H； Which statement is true in this scenario？（）

A、 It starts the ASM fast mirror resync.
B、 All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
C、 It drops all disk paths from the dga disk group.
D、 All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.

正确答案:D

第10题：

You issue the following code： EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP （’SCOTT’ ’GRP1’， TRUE）； What will be the result of executing the above code？（）

A、 The switch privilege will be granted to the user， Scott， for changing the consumer group to GRP1.
B、 The switch privilege will be granted to the user， Scott， for changing the consumer group from GRP1 to any other group.
C、 The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.
D、The code will execute successfully but no privilege will be granted to the user， Scott.

正确答案:A

Manually， you set the consumer group of all of the newly cre

题目

相似问题和答案

更多相关问题

相关内容