You issued the following command： SQL> DROP TABL

多项选择题

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；

相关考题

多项选择题 YouareperformingflashbackoftheEMPLOYEEtableinSCOTT’sschemabecausesomeincorrectdatawasinsertedintothetableandcommittedbymistake.WhichtwoclauseswillyouuseintheFLASHBACKTABLEstatementforusingtheFlashbackTablefeature？（）

单项选择题 You are working as a Database Administrator. You erroneously dropped an important table named WAREHOUSE_DETAILS. The table resides in a non-SYSTEM tablespace. The following dependent objects have been defined on the dropped table： Due to limited space， some of the indexes and triggers have been removed from the Recycle Bin. You decide to recover the table by using Flashback Drop. You execute the following statement： SQL>FLASHBACK TABLE warehouse_details TO BEFORE DROP； What will be the implication of executing this statement？（）

多项选择题 OnJan11，2005at2：30P.M.，anerroneousupdateoperationmodifiedallthevaluesofcolumnLASTNAMEintheEMPLOYEEtableintheScottschematoanemptystring.Youarethesystemadministrator，andyouwanttoreturntheoriginalvaluesinthetable.Todoso，youdecidedtoflashbackthetable.Whichtwooptionscanyouusetoflashbackatable？（）

1z0-043