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

Oracle认证考试

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

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema. You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table: SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP; What would be the outcome of the precedent statement?()

  • A、It retrieves the latest version of the table from the recycle bin
  • B、It retrieves the oldest version of the table from the recycle bin
  • C、It retrieves the version of the table for which undo information is available
  • D、It returns an error because the table name is not specified as per the names in the OBJECT_NAME column
正确答案:A
答案解析:
进入题库查看解析

微信扫一扫手机做题