欢迎来到建筑考试题库网 建筑考试题库官网
全部科目 > Oracle认证考试 > 1Z0-053

单项选择题

In your production database, users report that they are 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 in other 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)

点击查看答案

相关考题

  • 多项选择题
    WhichtwostatementsabouttheSQLManagementBase(SMB)aretrue?()

    A. It contains only SQL profiles generated by SQL Tuning Advisor.
    B. It stores plans generated by the optimizer using a stored outline.
    C. It is part of the data dictionary and stored in the SYSAUX tablespace.
    D. It is part of the data dictionary and stored in the SYSTEM tablespace.
    E. It contains the statement log,the plan history,plan baselines,and SQL profiles.

  • 多项选择题
    Which three functions are performed by the SQL Tuning Advisor?() (Choose three.)

    A. Building the SQL profile
    B. Recommending optimization of materialized views
    C. Checking query objects for missing and stale statistics
    D. Recommending bitmap, function-based, and B-tree indexes
    E. Recommending restructuring SQL queries that are using bad plans


  • 多项选择题
    WhichthreestatementscorrectlydescribethefeaturesoftheI/Ocalibrationprocess?()

    A. Only one I/O calibration process can run at a time
    B. It automates the resource allocation for the Automated Maintenance Tasks
    C. It improves the performance of the performance-critical sessions while running
    D. It can be used to estimate the maximum number of I/Os and maximum latency time for the system
    E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题