- 论坛徽章:
- 0
|
QUESTION:
You work as a database administrator for my.com. One of the database users accidentally deleted
all the rows of a critical table and committed the delete at 1:30 P.M. You senior database administrator
Tess King, asks you to retrieve the lost data.
Which row actions would you use to ensure that there is no impact on other connected users while
retrieving the deleted rows? Choose two.
A.Use a flashback query to retrieve the rows that were deleted
B.Use convential incremnetal export and then import the affected object
C.Shutdown the database in NORMAL mode and restart the database instance
D.Use DBMS_META package to reconstruct the object using undo segments
E.Use Tablespace Point in Time Recovery (TSPITR)method to recover the table and the data
F.Use Oracle Data Pumpt with flashback_time Option to entable flashback export and then import the affected object.
题目给的正确答案:B 、E
哪位大侠能解释一下为什么是选B、E ? 谢谢啦。 |
|