欢迎来到在线考试题库网 在线考试题库官网
logo
全部科目 > 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)

点击查看答案

相关考题

  • 多项选择题
    WhichthreefunctionsareperformedbytheSQLTuningAdvisor?()

    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

  • 单项选择题
    YouwanttoenableautomaticPGAmemorymanagementinyourdatabase.Whichsettingisrequiredtoachievethis?()

    A. Set MEMORY_TARGET to zero
    B. Set the STATISTICS_LEVEL parameter to BASIC
    C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL
    D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value

  • 多项选择题
    Whichthreestatementsaretrueaboutpersistentconfiguration?()

    A. A user cannot set privileges on the persistent lightweight jobs
    B. Persistent lightweight jobs generate a large amount of metadata
    C. It is possible to create fully self-contained persistent lightweight jobs
    D. The use of a template is mandatory to create persistent lightweight jobs
    E. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time

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

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