多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

You work as a database administrator for Supportcenter.cn. 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, SupportCenter, asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows?()

  • A、Use a flashback query to retrieve the rows that were deleted
  • B、Useconventialincremental export and then import the affected object
  • C、Shutdown the database inNORMALmode and restart the database instance
  • D、Use DBMS_META package to reconstruct the object using undo segments
  • E、UseTablespacePoint in Time Recovery (TSPITR) method to recover the table and the data
  • F、Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.
正确答案:B,E
答案解析:
进入题库查看解析

微信扫一扫手机做题