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

单项选择题

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

点击查看答案

相关考题

  • 多项选择题
    Whichoftheserecommendationsshouldbefollowedbeforecapturingaworkload?()

    A. Make sure your replay database has the same structure as the capture database, except without data.
    B. Make sure the replay and capture databases are similar in data content.
    C. Perform a clean shutdown and restart of the capture database before beginning a workload capture.
    D. Start the capture database in UNRESTRICTED mode, then start the capture.
    E. Define inclusion and exclusion filters.

  • 单项选择题
    What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?()

    A. The number of DBWR processes increases
    B. The number of ASMB processes increases
    C. The number of DBWR_TO_SLAVES increases
    D. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O overhead

  • 单项选择题
    WhichofthefollowingrepresentsthecorrectsequenceofeventsforDatabaseReplay?()

    A. Capture,analyze,preprocess,replay
    B. Capture,preprocess,analyze,replay
    C. Capture,preprocess,replay,analyze
    D. Analyze,capture,preprocess,replay
    E. None of the above

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

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