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 are the network administrator for TestKing.com. The network consists of a single Active Directory domain named testking.com. The functional level of the domain is Windows 2000 native. A global group named Travelling contains 7,000 users. All of these users are assigned portable computers, which they will use to run new POSIX-compliant application. You create a global group named POSIX. For all 7,000 users in Travelling, you change the primary group to POSIX. Members of Travelling now report that they cannot access necessary domain resources. How should you solve this problem?()
第2题:
For the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database, who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time, but you still do not want to terminate them with an error message. Which method would you follow to achieve this?()
第3题:
You are the administrator of a Windows 2000 Server computer named Ezonexam1. A printer named PrinterColor is configured on Ezonexam1.
You want to allow only users in the Administrators group and users in the Managers group to print to PrinterColor. You also want to allow users in the Managers group to pause and resume their print jobs, and you want to ensure that users in the Administrators group have full control permission for PrinterColor.
What should you do?
To answer, click the Simulation button and then perform. the appropriate actions in the simulation of the Printers folder.
第4题:
You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this? ()
第5题:
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?()
第6题:
You have created a resource plan, DB_PLAN, using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan?()
第7题:
You execute the following block of code: SQL>BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN ( SIMPLE_PLAN => ’DEPARTMENTS’, CONSUMER_GROUP1 => ’PAYROLLL’, GROUP1_CPU => 50, CONSUMER_GROUP2 => ’SALES’, GROUP2_CPU => 25, CONSUMER_GROUP3 => ’MARKETING’, GROUP3_CPU => 25); END; SQL>/ What is a prerequisite for using the simple resource plan created by executing the above code?()
第8题:
You recently upgraded all Windows NT Workstation 4.0 computers to Windows 2000 Professional. You want to give a new employee named Maria the ability to back up files, share resources, and install programs on a client computer that she shares with other users. You do not want Maria to be able to read other users' files.
What should you do to accomplish these goals? (Choose all that apply)
A.Add Maria's user account to the System group.
B.Add Maria's user account to the Interactive group.
C.Add Maria's user account to the Power Users group.
D.Add Maria's user account to the Administrators group.
E.Add Maria's user account to the Backup Operators group.
第9题:
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?()
第10题:
From the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database, who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time, but you still do not want to terminate them with an error message. Which method would you follow to achieve this?()