多项选择题

You issued the following command： SQL> DROP TABLE MYTAB……

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

A. RESETLOGS
B. TO TIMESTAMP
C. TO BEFORE DROP
D. RENAME TO
E. TO SCN

单项选择题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.

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

A. by using Oracle Enterprise Manager
B. by issuing the FLASHBACK TABLE statement at the RMAN prompt
C. by issuing the FLASHBACK TABLE statement at the SQL prompt
D. by issuing the FLASHBACK TABLE statement at the LSNRCTL prompt

单项选择题YouwanttousetheFlashbackTransactionQueryfeaturetoidentifyallthechangesmadetoyourdatabasewithinaspecifictimeperiod.WhatisaprerequisiteforusingtheFlashbackTransactionQueryfeature？（）

A. You must use automatic undo management in the database.
B. You must configure OMF in your database.
C. You must configure ASM for storing the datafiles.
D. You must multiplex the online redo log file.

单项选择题At 5：30 PM， a database administrator， William， is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4：30 P.M， the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion： SELECT operation， undo_sql， logon_user FROM FLASHBACK_TRANSACTION_QUERY WHERE xid= HEXTORAW（’0100043E23456’）； where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement， which task did William perform to identify the transaction ID of the transaction that deleted the row？（）

A. William used the Flashback Version Query feature.
B. William issued the CROSSCHECK command at the RMAN prompt.
C. William viewed the alert log file.
D. William used the Flashback Table feature.