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 

第1题：

You execute the following command to audit 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 every successful DROP TABLE command executed in the session of SCOTT.
• B、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.
• C、One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis 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 drop Tables owned by SCOTT

第2题：

Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp； Table dropped.  What happens in this scenario？ （）

• A、The table is moved to the SYSAUX tablespace.
• B、The table is moved to the SYSTEM tablespace.
• C、The table is removed from the database permanently.
• D、The table is renamed and remains in the TBSFD tablespace.

第3题：

You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

• A、All data along with the table structure is deleted 
• B、The pending transaction in the session is committed 
• C、All indexes on the table will remain but they are invalidated 
• D、All views and synonyms will remain but they are invalidated 
• E、All data in the table are deleted but the table structure will remain

第4题：

You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）

• A、One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
• B、One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
• C、One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
• D、One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
• E、One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.

第5题：

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；

第6题：

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

第7题：

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;

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table：  ERROR at line 1：  ORA-00060： deadlock detected while waiting for resource  On investigation， you find that a session opened by user JIM has a transaction that caused the deadlock.  two statements are true regarding the session of SCOTT in this scenario（）

• A、The session is terminated after receiving the error and JIM can continue with his transaction.
• B、SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
• C、The session is rolled back after receiving the error and JIM can continue with his transaction.
• D、SCOTT has to reexecute the last command in the transaction after he commits the transaction.

第14题：

You enabled an audit policy by issuing the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For which database users and for which executions is the audit policy now active? （）

• A、SYS, SYSTEM
• B、SCOTT
• C、Only for successful executions
• D、Only for failed executions
• E、Both successful and failed executions

第15题：

One of the users in the PROD database， Adams， complains that his update on the table， TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions， and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority. Which method would you use to overcome this problem？（）

• A、execute the command， ALTER SESSION KILL ..， to kill the blocking session
• B、execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session
• C、execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking session
• D、execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking session
• E、execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session

第16题：

You issued the following statement：   SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n；   What will be the result of issuing the above statement？（）

• A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
• B、 The command will not execute successfully because resumable space allocation is enabled at the session level.
• C、 The command will execute successfully and resumable space will be allocated at the session level.
• D、 The command will execute successfully and resumable space will be allocated at the instance level.

第17题：

You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）

• A、All the objects of scott are moved to the Recycle Bin.
• B、Any objects in the Recycle Bin belonging to scott are purged.
• C、All the objects owned by scott are permanently dropped from the database.
• D、All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
• E、Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

第18题：

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.

第19题：

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT; For which database users is the audit policy now active?（）

• A、All users except SYS
• B、All users except SCOTT
• C、All users except sys and SCOTT
• D、All users except sys, system, and SCOTT

第20题：

第21题：

第22题：

第23题：