99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

多項(xiàng)選擇題

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；

題目列表

你可能感興趣的試題

單項(xiàng)選擇題

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？（）

A. Only the WAREHOUSE_DETAILS table is recovered， and none of the dependent objects are recovered.
B. The WAREHOUSE_DETAILS table is recovered along with the NOT NULL constraints， primary key constraint， and the referential integrity constraints.
C. The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the indexes and triggers previously removed from the Recycle Bin.
D. The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the referential integrity constraints and the indexes and triggers previously removed from the Recycle Bin.
微信掃碼免費(fèi)搜題