You executed the following command to drop a user：   DROP US

第1题：

At the request of a user， you issue the following command to restore a dropped table： flashback table "BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop； Later， the user notifies you that the data in the table seems to be very old and out of date.  What might be the problem？（）  

• A、 Because a proper range of SCNs was not specified， the wrong data was restored.
• B、 A proper range of timestamps was not specified， so the wrong data was restored.
• C、 A previous Flashback Drop operation had been performed， resulting in multiple versions of the table being stored in the Recycle Bin.
• D、 Either option A or B could be correct. Not enough information was provided to determine which.
• E、 None of the above.

第2题：

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；

第3题：

第4题：

You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL> DROP PROFILE app_user；  Which statement describes the result（）

• A、The command produces an error.
• B、The profile is dropped and current user sessions use the DEFAULT profile immediately.
• C、The profile is dropped and only the subsequent user sessions use the DEFAULT profile.
• D、The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.

第5题：

In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective：  DROP DISKGROUP dgroup1 EXCLUDING CONTENTS；  What would be the result of this command？（）

• A、 This command would result in an error because the disk group is not empty.
• B、 The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.
• C、 The command would result in the contents being moved to the parent disk group and dropping of the disk group.
• D、 The command would result in the disk group being marked as INVALID because it cannot be dropped.
• E、 The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.

第6题：

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

第7题：

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

第8题：

授予删除任何表的系统权限（DROP ANY TABLE）给user1，并使其能继续授该权限给其他用户，以下正确的SQL语句是（）

• A、Grant drop any table to user1
• B、Grant drop any table to user1 with admin option
• C、Grant drop table to user1
• D、Grant drop any table to user1 with check potion

第9题：

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.

第10题：

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.