单项选择题
A. You must configure OMF in your database.
B. You must enable block change tracking feature in your database.
C. You must enable ROW MOVEMENT feature on the ORDERS table.
D. You must use the Flashback Version Query before using the Flashback Table feature.
单项选择题 You are working as a DBA at NetFx Corporation. A user， Scott， is maintaining the records of all the employees in the EMPLOYEEtable. Initially， the salary of the employee， ’E0025’， was $1800. On 1 May 2004， the salary of the employee， ’E0025’， was increased by $200. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’： SQL>UPDATE EMPLOYEE SET SALARY = 2000 WHERE EMPNO = ’E0025’； SQL>COMMIT； On December 1， 2004， the salary of the employee， ’E0025’， was increased by $400. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’： SQL>UPDATE EMPLOYEE SET SALARY = 2400 WHERE EMPNO = ’E0025’； SQL>COMMIT； On July 1， 2005， the salary of the employee， ’E0025’， was increased by $500. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’ SQL>UPDATE EMPLOYEE SET SALARY = 2900 WHERE EMPNO = ’E0025’； SQL>COMMIT； On July 5， 2005， the HR manager asked you to generate the increment report of the employee， ’E0025’， for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report？（）
单项选择题 Attheendofthefinancialyear，anaccountsaccumulationbatchisrun.Thisbatchupdatesthecompany’saccountingrecords.Duringthebatchrunprocess，someincorrectentrieswereinsertedintotheACCOUNTtable.Youidentifiedthebugandimmediatelystoppedthebatchrunprocess，but3000incorrectrecordswereinsertedintotheACCOUNTtablebeforethebatchprocesswasstopped.Youwanttorecoverthetabletothestateitwasat11：50P.M.Whichflashbackfeaturewillyouuse？（）
多项选择题 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？（）