• OCP-1Z0-053-200题-65题-642


    QUESTION 65

    In your production database, users report that theyare unable to generate reports on an important table

    because it does not contain any data. While investigating the reason, you realize that another user executed

    the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the

    lost data of the table without affecting objects inother schemas.

    Which method must you use to recover the lost data?

    A. Complete Recovery with online redo log

    B. Complete Recovery with archived redo log

    C. Tablespace Point-in-Time Recovery (TSPITR)

    D. Incomplete Recovery with system change number (SCN)

    Answer: C

    同642题:http://blog.csdn.net/rlhua/article/details/13761239


    Explanation/Reference:

    Section: Backup, Recovery & Recovery Manager (RMAN)

    RMAN TSPITR is most useful for the following situations:

    - You want to recover data lost after DDL operations that change the structure of tables.

    You cannot use Flashback Table to rewind atable to before the point of a structural change

    such as a truncate table operation.

  • 相关阅读:
    输出国际象棋&&输出余弦曲线
    打鱼晒网问题
    ATM模拟程序
    getline()函数
    AC小笔记
    ural 1208 Legendary Teams Contest
    汇编贪吃蛇
    供给与需求的市场力量
    垄断竞争
    相互依存性和贸易的好处
  • 原文地址:https://www.cnblogs.com/hzcya1995/p/13316009.html
Copyright © 2020-2023  润新知