多选题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题：

You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.Which set of statements accomplishes this?（）

• A、CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
• B、CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
• C、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3
• D、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;
• E、CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;

第2题：

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.

第3题：

You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）

• A、Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.
• B、Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’
• C、Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）
• D、Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport

第4题：

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.

第5题：

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

第6题：

You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? （）

• A、CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
• B、CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
• C、GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***

第7题：

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

第8题：

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 related 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.

第9题：

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.

第10题：

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.