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

相关问题推荐

• 在Windows Server 2003下若选择安全登录，则首先需要按(38)组合键。

  A．Shiff+Alt+Esc

  B．Ctrl+Alt+Tab

  C．Ctrl+Shiff

  D．Ctrl+Alt+Delete

  查看答案

• 用Linux ls-al命令列出下面的文件列表，(33)是块设备文件。

  A．drwx----1 hel users 1024 Sep 10 08:10 aaa

  B．-rw----2 hel-s users 56 Sep 09 11:05 bbb

  C．brw----2 hel-s users 56 Sep 09 11:05 ccc

  D．1rwx----1 hel users 2024 Sep 12 08:12 ddd

  查看答案

• You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.  What information is captured as part of this process？（）

  A

   the SQL text

  B

   the execution plan

  C

   the execution context

  D

   the execution frequency

  E

   the system change number （SCN）

  查看答案

• You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task？（）  

  A、 Data Pump Export and Import

  B、 conventional export and import

  C、 the CONVERT command of RMAN

  D、 the BACKUP AS COPY. command of RMAN

  查看答案

• The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)

  A

  All the related indexes and views are automatically dropped

  B

  The flashback drop feature can recover only the table structure

  C

  Only the related indexes are dropped whereas views are invalidated

  D

  The flashback drop feature can recover both the table structure and its data

  查看答案