单选题User A executes the following command to drop a large table in your database： SQL> DROP TABLE trans；  While the drop table operation is in progress， user B executes the following command on the same table： SQL> DELETE FROM trans WHERE tr_type=’SL’；  Wh

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

第4题：

User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）

• A、It fails to delete the records because the records are locked in SHARE mode.
• B、It deletes the rows successfully because the table is locked in SHARE mode
• C、It fails to delete the records because the table is locked in EXCLUSIVE mode.
• D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

第5题：

User A executes the following command to drop a large table in your database： SQL> DROP TABLE trans；  While the drop table operation is in progress， user B executes the following command on the same table： SQL> DELETE FROM trans WHERE tr_type=’SL’；  Which statement is true regarding the DELETE command（）

• A、It fails with a "Resource Busy" error.
• B、It deletes the rows successfully because the table is locked in SHARE mode.
• C、It fails to delete the records because the table is locked in EXCLUSIVE mode.
• D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You issued the following command：        SQL> DROP TABLE MYTABLE；        SQL> SHOW RECYCLEBIN  The following output is returned：        ORIGINAL NAME RECYCLEBIN NAME               OBJECT TYPE      DROP TIME        ------------- ------------------------------ --------------- --------------------        MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0     TABLE           2005-01-13：20：11：31  You want to drop the table， MYTABLE， from the Recycle Bin. Which two commands can you issue to accomplish the desired task？（）

• A、 DROP TABLE MYTABLE PURGE；
• B、 PURGE RECYCLEBIN；
• C、 PURGE TABLE MYTABLE；
• D、 PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0；

第14题：

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

第15题：

User A executes the following command to update the TRANS table）  SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’；  Before user A issues a COMMIT or ROLLBACK command， user B executes the following command on the TRANS table：   SQl> ALTER TABLE trans MODIFY （tr_type VARCHAR2 （3））；  What would happen in this scenario？（）

• A、The transaction for user A is rolled back.
• B、The ALTER TABLE command modifies the column successfully.
• C、The ALTER TABLE command fails due to the resource being busy.
• D、The ALTER TABLE command waits until user A ends the transaction.

第16题：

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.

第17题：

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;

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：