多选题When should you create a role? （）ATo simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement.BTo grant a group of related privileges to a user.CWhen the number of people using the database is very high.DTo simpl

第1题：

When should you create a role?（）

• A、To simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement.
• B、To grant a group of relate privileges to a user.
• C、When the number of people using the database is very high.
• D、To simplify the process of granting and revoking privileges.
• E、To simplify profile maintenance for a user who is constantly traveling.

第2题：

You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface：  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）；  This command errorsout displaying the following message：  ERROR at line 1：  ORA-01031： insufficient privileges  ORA-06512： at "SYS.DBMS_RMIN"， line 115  ORA-06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA-06512： at line 1  What action would you take to overcome this error？（）

• A、 grant SYSDBA to the user
• B、 grant SYSOPER to the user
• C、 grant the RESOURCE role to the user
• D、 use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the use
• E、 grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package

第3题：

In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure: CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2,v_SALARY NUMBER, v_dept_id NUMBER) BEGIN INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END; / GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king; How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?（）

• A、Create the CREATE_TEST procedure with definer’s rights.
• B、Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.
• C、Create the CREATE_TEST procedure with invoker’s rights.
• D、Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.

第4题：

You have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for granting the required privileges？（）

• A、grant CONNECT role to all of the three users
• B、grant RESOURCE role to all of the three users
• C、grant both CONNECT and RESOURCE role to all of the three users
• D、execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users
• E、create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users

第5题：

You are creating a Windows Forms Application by using the .NET Framework 3.5.You plan to design a new control that will be used on multiple forms in the app.You need to ensure that the control meets the following requirement  （1）It retrieves data from a MSSQL Server 2008 database instance. （2）It uses WPF classes to display data.  （3）It uses user-customizable actions when the control is first painted on the form.   What should you do？（）

• A、Create a new custom class for the control that is derived from the Control class.
• B、Create a new custom class for the control that is derived from the UserControl class.
• C、Create a new custom class for the control that is derived from the ContentControl class.
• D、Create a new custom class for the control that is derived from the ContentPresenter class.

第6题：

You manage Hyper-V host servers and virtual machines （VMs） by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2. Developers are members of an AD security group named  Development. You need to ensure that on a specific host server， members of the Development group can perform only the Create，Modify，and Remove VM management tasks. What should you do？（）

• A、Create a Self-Service user role and add the Development group to this role.
• B、Create a Delegated Administrator user role and add the Development group to this role.
• C、In Authorization Manager， create a role on the client computer of each member of the Development group， and add the Development group to this role.
• D、Install Hyper-V Manager on the client computer of each member of the Development group，and grant the Development group administrative privileges on the specific server.

第7题：

You have a single Active Directory directory service domain. You create organizational units （OUs）  named Corporate and Support. You move the corporate user and computer accounts into the Corporate  OU. You move the accounts of computers in the support department into the Support OU. You need to ensure that users have one screensaver while using computers that are in the Corporate OU， and aseparate screensaver while using computers that are in the Support OU.  What should you do？（）

• A、 Create a new parent OU for the Corporate and Support OUs and name the parent OU Users. Move all user objects to the Users OU， and then create and link a Group Policy object （GPO） with the screensaver setting to the Users OU.
• B、 Create and link a Group Policy object （GPO） with the screensaver setting to the Support OU and select the Block Inheritance option.
• C、 Create and link a Group Policy object （GPO） with the screensaver setting to the Corporate OU， create and link a GPO with the screensaver setting to the Support OU， and then enable loopback processing in Replace mode on the Support OUs GPO.
• D、 Create and link a Group Policy object （GPO） with the screensaver setting to the Support OU and select the Enforced option.

第8题：

You manage Hyper-V host servers and virtual machines （VMs） by using Microsoft System Center  Virtual Machine Manager （VMM） 2008 R2. Testers are members of an AD security group named Test. You need to ensure that members of the Test group can create VMs on a specific host server by using the VMM Self-Service Portal. What should you do？（）

• A、In VMM， specify a template for new VMs created by members of the Test group.
• B、In VMM， create a Delegated Administrator user role and add the Test group to this role.
• C、In VMM， assign the Test group the Local Administrator permission for the specific host server.
• D、Install Hyper-V Manager on the client computer of each member of the Test group， and grant the Test group administrative privileges on the specific host server.

第9题：

You need to design the database permissions for access from the terminals to the database server. Which action or actions should you perform?（）

• A、Create a database role named BankTerminals.
• B、Grant the BankTerminals role the Execute permission for the WoodgroveBanking database.
• C、Grant database access to the Windows Bank Terminals group， and add the group to the BankTerminals role.
• D、Grant the BankTerminals role the Execute permission for the Bank schema.
• E、Grant the Windows Bank Terminals group the Execute permission for the Bank schema.
• F、Grant the BankTerminals role the Execute permission for all stored procedures and user-defined functions in the Bank schema.

第10题：

第11题：

第12题：

第13题：

You work as a database administrator for Supportcenter.cn. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？（）

• A、Assign the DEFAULT profile to the users
• B、Set the RESOURCE_LIMIT parameter to TRUE in the parameter file
• C、Create a new profile with CPU restrictions and assign it to the users
• D、Specify the users as members of the DEFAULT_CONSUMER_GROUP
• E、Revoke the DBA role and grant CONNECT and RESOURCE role to the users

第14题：

You execute the following set of commands to create a database user and to grant the system privileges in your production environment.  SQL> CREATE USER user01  IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1  TEMPORARY TABLESPACE temp PROFILE default  /  SQL> GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails.  ERROR at line 1： ORA-01950： no privileges on tablespace  What could be the possible reason for this error message？（）

• A、The tablespace TBS1 is full.
• B、The user is not the owner of the SYSTEM tablespace.
• C、The user does not have quota on the TBS1 tablespace.
• D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.
• E、The user does not have sufficient privileges to create table on the default permanent tablespace.

第15题：

Which two statements accurately describe a role?（）

• A、A role can be given to a maximum of 1000 users.
• B、A user can have access to a maximum of 10 roles.
• C、A role can have a maximum of 100 privileges contained in it.
• D、Privileges are given to a role by using the CREATE ROLE statement.
• E、A role is a named group of related privileges that can be granted to the user.
• F、A user can have access to several roles, and several users can be assigned the same role.

第16题：

The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？ （）

• A、set the SESSIONS to 1 in the parameter file
• B、grant SINGLE SESSION privilege to all of the users
• C、set the SESSIONS_PER_USER to 1 in the users’ profile
• D、grant RESTRICTED SESSION privilege to all of the database users
• E、create a role with SINGLE SESSION privilege and assign the role to the users

第17题：

Your network contains an Exchange Server 2010 server.You need to prevent a user named User1 from downloading attachments larger than 50 KB when using Exchange ActiveSync.Your solution must not affect other users.  What should you do first？（）

• A、Modify User1 Mailbox properties
• B、Create a New ActiveSync Mailbox Policy
• C、Create a New Exchange ActiveSync Mailbox policy
• D、Modify properties of Default Exchange ActiveSync Mailbox policy

第18题：

You are designing a migration strategy to create user IDs for all company users in the new environment. What should you do?（）

• A、Create a script that uses Active Directory Services Interfaces (ADSI) to import all user account into the new environment.
• B、Create new accounts for all users. Create a trust relationship between the existing environment and the new environment to enable access to resources in the existing environment.
• C、Import all user accounts into the new environment by using the Active Directory Migration Tool (ADMT).
• D、Import all user accounts into the new environment. Instruct users to no change their passwords during the migration phase so that they can access resources in the existing environment.

第19题：

You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（） 

• A、Create the database by using a single data file and a single log file.
• B、Create the database by using a single data file and multiple log files.
• C、Create the database by using a single log file and multiple filegroups.
• D、Create the database by using a single log file and a filegroup that has multiple data files.

第20题：

Your company has an Active Directory Domain Services （AD DS） domain. You have a Windows Server 2008 R2 Hyper-V server. You manage the virtual environment by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2. You need to ensure that a user can create new virtual machines （VMs） on only a specific set of servers . The user must not be able to see or manage servers outside of that set within VMM . Which two actions should you perform？（）

• A、Create a host group. Add the host servers that the user will manage to the host group.
• B、Create a failover cluster. Join the host servers that the user will manage to the failover cluster.
• C、Using Authorization Manager， assign the user to a role with the necessary permission to manage the servers by using VMM.
• D、Using Authorization Manager， assign the user to a role with the necessary permission to manage the servers by using the VMM Self-Service Portal.

第21题：

第22题：

第23题：

第24题：