首页计算机考试Oracle认证
(单选题)

You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE 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. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?()

ARestore the backup control file and open the database with RESETLOGS option.

BPerform point-in-time recovery because flashback cannot be performed again on this table

CExecute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571

DExecute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

正确答案

来源:www.examk.com

答案解析

快考试在线搜题