多选题You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）AAll the objects of scott are moved to the Recycle Bin.BAny objects in the Recycle Bin belonging to scott are pur

第1题：

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；

第2题：

You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable：  SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；  Which two statements are true about the effect of the command（）

• A、No flashback is possible to bring back the ITEM table.
• B、The ORDER table is dropped along with the ITEM table.
• C、The dependent referential integrity constraints in the ORDER table are disabled.
• D、The dependent referential integrity constraints in the ORDER table are removed.
• E、The table definition of the ITEM table and associated indexes are placed in the recycle bin.

第3题：

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.

第4题：

Which of the following statements are true regarding the Recycle Bin？（）

• A、 The Recycle Bin is a physical storage area for dropped objects.
• B、 The Recycle Bin is a logical container for dropped objects.
• C、 The Recycle Bin stores the results of a Flashback Drop operation.
• D、 The objects in the Recycle Bin are stored in the tablespace in which they were created.

第5题：

What will be the result of using the SQL> DROP USER SCOTT CASCADE； command？（）

• A、 The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and the objects that are  already in the Recycle Bin are dropped.
• B、 The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and all the objects in the Recycle Bin， belonging to the user Scott， are not dropped.
• C、 The user， Scott， is dropped， all the objects in the Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin， belonging to the user， Scott， are not dropped.
• D、 The user， Scott， is dropped， all the objects in Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin are dropped.

第6题：

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.

第7题：

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

Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

• A、The SKD user cannot log in to the database instance.
• B、The objects owned by the SKD user are not accessible to any user.
• C、The other users can access the objects owned by the SKD user， on which they have access.
• D、The password for the SKD user expires and the user is forced to change the password at the next log in.

第15题：

Which two statements are correct regarding the Oracle Flashback Drop feature？ （）

• A、 Recycle bin exists for the tables only in non-SYSTEM， locally managed tablespaces.
• B、 You can flash back a dropped table provided row movement has been enabled on the table.
• C、 If you drop an index before dropping its associated table， then the recovery of the index is not supported when you flash back the dropped table.
• D、 When you execute the DROP TABLESPACE？ INCLUDING CONTENTS command， the objects in the tablespace are places in the recycle bin.
• E、 When a dropped table is moved to the recycle bin， only the table is renamed to a system-generated name； its associated objects and constraints are not renamed.
• F、 If you drop a table that is protected by the recycle bin， then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.

第16题：

In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；

• A、 when the schema of the user， SCOTT， was deleted by mistake 15 minutes ago
• B、 when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago
• C、 when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes ago
• D、 when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes
• E、 never， because FLASHBACK TABLE is not a valid command in Oracle 10g.

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

第20题：

第21题：

第22题：

第23题：

第24题：