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题:
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?()
第2题:
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?()
第3题:
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? ()
第4题:
You issued the following block of code: SQL>BEGIN DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP( ’PROG_ROLE’, ’DEVELOPERS’ ,FALSE); END; SQL>/ Which option is NOT a result of executing the above code?()
第5题:
You are the administrator of a Windows 2000 Professional computer. A user named Maria assists you in performing some administrative tasks. Maria is a member of local Administrators group. Users report that Maria has been viewing and changing their files. You want Maria to be able to install programs, perform backups and manage printers, but not to view, change or read other users’ files for which permission has not been granted. You want to set up Maria’s account to have minimal rights and permission. You want to accomplish this with least amount of administrative effort. What should you do? ()
第6题:
You create a Microsoft ASP.NET Web application by using the Microsoft .NET Framework version 3.5. You use Windows Authentication for the application. You set up NTFS file system permissions for the Sales group to access a particular file. You discover that all the users are able to access the file. You need to ensure that only the Sales group users can access the file. What additional step should you perform?()
第7题:
assign users to consumer groups
set the resource plan for the instance
configure a simple resource plan and specify plan directives
configure a complex resource plan and specify plan directives
第8题:
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.
第9题:
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.
第10题:
NLSLANG
NLSLENGTHSEMANTICS
NLSTERRITORY
NLSLANGUAGE
NLSCHARACTERSET
NLSDATELANGUAGE
NLSNCHARCHARACTERSET
第11题:
Set the CPU time per call in the users profile.
Set the CPU time per session in the users profile.
Set the CPU levels for the user’s group using Resource Manager.
Set the TIMED_STATISTICS parameter to TRUE in the parameter file.
第12题:
set the CPU time per call in the users profile
set the CPU time per session in the users profiles
set the TIMED_STATISTICS parameter to TRUE in the parameter file
set the CPU levels for the users’ group using Resource Manager
第13题:
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?()
第14题:
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?()
第15题:
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?()
第16题:
You are the network administrator for your company. Your network consists of a single Active Directory domain. The functional level of the domain is Windows Server 2003. You add eight servers for a new application. You create an organizational unit (OU) named Application to hold the servers and other resources for the application. Users and groups in the domain will need varied permissions on the application servers. The members of a global group named Server Access Team need to be able to grant access to the servers. The Server Access Team group does not need to be able to perform any other tasks on the servers. You need to allow the Server Access Team group to grant permissions for the application servers without granting the Server Access Team group unnecessary permissions. What should you do?()
第17题:
You are the network administrator for All network servers run Windows Server 2003. All client computers run Windows XP Professional. You create a folder on thet network and share it as TestKingDocs. You want users to be able to read, create, and modify documents that are stored in the shared folder. You also want users to be able to delete the folders and the files that they create. A user reports that another used deleted a folder that she created. You discover that the Everyone group ias assigned the Allow - Full Control NTFS permission for the folder. You remove all assigned permissions for the Everyone group. You need to configure permission for the TestKingDocs shared folder to meet your requirements. You also need to ensure that users cannot delete the folders and files that other users create. Which two actions should you perform ()(Each correct answer presents part of the solution. Choose two.)
第18题:
Ensure that each site on your network is connected to at least one other site by a replication link that uses the SMTP protocol.
Create two new global groups, Travelling1 and Travelling2. Place one half of the members of Travelling in each new group. Then place both new groups in Travelling.
Remove all domain users from the Users group, and then add all domain users to the group again.
Remove all users from Travelling. Change Travelling to a universal group. Add the same users to the new Travelling group.
第19题:
assign users to consumer groups
set the resource plan for the instance
configure a simple resource plan and specify plan directives
configure a complex resource plan and specify plan directives
第20题:
Remove the rights from the ASP.NET user to the file.
Remove the rights from the application pool identity to the file.
Add the <identity impersonate=true/> section to the Web.config file.
Add the <authentication mode=[None]> section to the Web.config file.
第21题:
Leave Maria in the local Administrators group. Limit her rights by using Local Policies.
Leave Maria in the local Administrators group. Change the NTFS provision on other users’ files to deny Maria’s request.
Remove Maria from the local Administrators group. Add her to both the Power Users group and Backup Operators group.
Remove Maria from local Administrators group. Add her to Power User group. Then grant her NTFS Read permission on the files to be backed up.
第22题:
set the CPU time per call in the users profile
set the CPU time per session in the users profiles
set the CPU levels for the users’ group using Resource Manager
set the TIMED_STATISTICS parameter to TRUE in the parameter file
第23题:
Create a Group Policy object (GPO) for restricted groups. Configure the GPO to make the Server Access Team group a member of the Power Users group on each application server. Link the GPO to the Application OU.
Grant the Server Access Team group permissions to modify computer objects in the Application OU.
Move the Server Access Team group object into the Application OU.
Create domain local groups that grant access to the application servers. Grant the Server Access Team group permissions to modify the membership of the domain local groups.
第24题:
You must assign users to consumer groups.
You must grant the switch privilege to the users.
You must create a resource plan directive.
You must specify the complex resource plan.