多选题The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable： ERROR at line 1： ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened byuser JIM has a transac

第1题：

You execute the following command to audit the database activities：   SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command？（）

• A、One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
• B、One audit record is created for every session when any user successfully drops a table owned by SCOTT.
• C、One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
• D、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
• E、One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

第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题：

A user complains that he gets the following error message repeatedly after executing some SQL statements.The error message forces the user to log off from and log onto the database to continue his work.  ORA-02392：exceeded session limit on CPU usage，you are being logged off Which action would you take to increase the session limit on CPU usage？（）

• A、Modify the profile assigned to the user.
• B、Modify the roles assigned to the users.
• C、Modify the object privileges assigned to the user.
• D、Modify the system privileges assigned to the users.
• E、Modify the value for the RESOURCE_LIMIT parameter in the parameter file.

第4题：

The user HR receives the following error while inserting data into the TTK table：ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）

• A、Add a data file to the SMD tablespace.
• B、Add a data file to the temporary tablespace associated with the user HR.
• C、Resize the data file associated with the SMD tablespace to make it larger.
• D、Alter the data file associated with the SMD tablespace to grow automatically.
• E、Change the segment space management for the SMD tablespace to automatic

第5题：

You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）

• A、 The batch operation started by the user， SCOTT， terminates with an error.
• B、 The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.
• C、 The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.
• D、 The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.
• E、 The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.

第6题：

You execute the following command toauditdatabase activities：  SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）

• A、Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.
• B、Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.
• C、One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.
• D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
• E、One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.

第7题：

You want to enable the user， Scott， to change to the GRP1 consumer group by issuing the following code：        SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP  （’SCOTT’，       ’GRP1’， FALSE）；   How will you grant the switch privilege to the user， Scott？（）  

• A、 by using the DBMS_SESSION package
• B、 by granting the DBA role
• C、 by using the DBMS_RESOURCE_MANAGER package
• D、 by using the DBMS_RESOURCE_MANAGER_PRIVS package

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers  MODIFY （cust_nameVARCHAR2 （40）） /  When you execute the command， it displays the following error message：  ERROR at line 1：  ORA-00054： resource busy and acquire with NOWAIT specified  What could be the reason for the error message？（）

• A、The database instance is not available.
• B、The ALTER TABLE command does not have WAIT option
• C、The table or a row in the table is currently locked by another user session.
• D、The database instance is busy processing other user sessions commands.
• E、The CUSTOMERS table has no long running query active at the time when this request is made.
• F、The server process executing the ALTER TABLE command is busy with another command execution

第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题：

User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， or any data definition language （DDL） command： SQL> SELECT ename FROM emp  2 WHERE job=’CLERK’ FOR UPDATE OF empno；  SCOTT has opened another session to work with the database instance.  Which three operations wouldwait when issued in SCOTT’s second session（）

• A、LOCK TABLE emp IN SHARE MODE；
• B、LOCK TABLE emp IN EXCLUSIVE MODE；
• C、UPDATE emp SET sal=sal*1.2 WHERE job=MANAGER；
• D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
• E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；

第16题：

User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance.  Which three operations would waitwhen issued in SCOTT’s second session（）

• A、LOCK TABLE emp IN SHARE MODE；
• B、LOCK TABLE emp IN EXCLUSIVE MODE；
• C、UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？
• D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
• E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno

第17题：

The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：  SQL> GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL> GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；  Now， the user HR decides to revoke privileges from JIM using this command： SQL> REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）

• A、The command fails because SCOTT still has privileges.
• B、The command succeeds and privileges are revoked from JIM.
• C、The command fails because HR cannot revoke the privileges from JIM.
• D、The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.

第18题：

User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command：  SQL> SELECT job FROM emp  2  WHERE job=’CLERK’ FOR UPDATE OF empno;  SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）

• A、LOCK TABLE emp IN SHARE MODE;
• B、LOCK TABLE emp IN EXCLUSIVE MODE;
• C、DELETE FROM emp WHERE job=’MANAGER’;
• D、INSERT INTO emp（empno，ename） VALUES （1289，’Dick’）;
• E、SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;

第19题：

In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated.How do you achieve this objective？（）

• A、 by setting the SQL_TRACE parameter to FALSE in the parameter file
• B、 by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
• C、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
• D、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session

第20题：

第21题：

第22题：

第23题：

第24题：