多选题You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）AAll data along with the table structure is deletedBThe pending transaction in the session is committedCAll indexes on the 

第1题：

The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)

• A、All the related indexes and views are automatically dropped
• B、The flashback drop feature can recover only the table structure
• C、Only the related indexes are dropped whereas views are invalidated
• D、The flashback drop feature can recover both the table structure and its data

第2题：

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

第3题：

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.

第4题：

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.

第5题：

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

第6题：

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

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

第7题：

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.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

• A、Immediately following statement execution 
• B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued 
• C、After the ALTER TABLE SET UNUSED COLUMN command is issued 
• D、After the ALTER TABLE MODIFY command is issued

第14题：

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；

第15题：

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement?（）

• A、You cannot roll back this statement.
• B、All pending transactions are committed.
• C、All views based on the DEPT table are deleted.
• D、All indexes based on the DEPT table are dropped.
• E、All data in the table is deleted, and the table structure is also deleted.
• F、All data in the table is deleted, but the structure of the table is retained.
• G、All synonyms based on the DEPT table are deleted.

第16题：

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.

第17题：

The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema.  Which two statements are true regarding the outcome of this action？（）

• A、 All the related indexes and views are automatically dropped
• B、 The flashback drop feature can recover only the table structure
• C、 Only the related indexes are dropped whereas views are invalidated
• D、 The flashback drop feature can recover both the table structure and its data

第18题：

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.

第19题：

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.

第20题：

第21题：

第22题：

第23题：

第24题：