• OCP-1Z0-053-200题-122题-230


    QUESTION 122

    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:

    SQL> SELECT object_name, original_name, droptime, FROM recyclebin;

    OBJECT_NAME ORIGINAL_NAME DROPTIME

    -------------------------------------- -------------------------------------------

    BIN$/m0DrBV9RFGOAA53dC+FPW==$0 SALES_EMP  2007-12-07:11:08:55

    BIN$2DeIssLeQTqgH/n80Rm2JQ==$0 SALES_EMP  2007-12-07:11:11:38

    BIN$UuqroNodQy6ouDtaA+XOVw==$0 SALES_EMP  2007-12-07:11:08:18

    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 notspecified as per the names in the OBJECT_NAME column

    Answer: A

    同230题:http://blog.csdn.net/rlhua/article/details/14453365


    Explanation/Reference:

    Section: Database Architecture & Resource Management, RAC, ASM

  • 相关阅读:
    基于MongoDB.Driver的扩展
    通用查询设计思想
    API接口通讯参数规范
    lambda简单记录
    list去重精简代码版
    spring boot file上传
    fastjson过滤器简单记录
    java读取properties文件
    list循环删除单个元素
    MapReduce运行流程分析
  • 原文地址:https://www.cnblogs.com/hzcya1995/p/13316066.html
Copyright © 2020-2023  润新知