单项选择题
A.to undo the changes made to the EMP table since the specified time
B.to restore the EMP table that was wrongly dropped from the database
C.to view the transactions that have modified the EMP table since the specified time
D.to view the changes made to the EMP table for one or more rows since the specified time
E.to recover the EMP table to a point in time in the past by restoring the most recent backup
多项选择题 YouexecutedthefollowingFLASHBACKTABLEcommand:FLASHBACKTABLEempTOTIMESTAMP(’11:45’,’hh12:mi’)Whichtwostatementsarecorrect?()
单项选择题 You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the System Change Number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state and the resultant changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK TABLE command while ensuring that: a) No other user data in the database is affected. b) The operation takes the minimum possible time. Which option would you choose?()
多项选择题 View the Exhibit and examine the Flashback SCNs. A user has inserted wrong department data in the DEPT3 table in the USERS tablespace. You use the Flashback Table functionality to rectify the erroneous inserts. While performing the recovery, you chose 2004343 as the Flashback SCN. Which two statements are correct in this scenario?()