首页计算机考试Oracle认证
(单选题)

You are working on an online transaction processing (OLTP) system. You notice that a PL/SQL procedure got executed twice at 2) 00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2) 00 p.m.?()

APerform point-in-time recovery to 2: 00 p.m.

BUse Flashback Table feature to revert the changes.

CRestore the entire database from the recent backup and open it.

DIssue the rollback statement with system change number (SCN).

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    You are configuring for Oracle Shared Server. Which service is required? ()

    答案解析

  • (多选题)

    You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()

    答案解析

  • (单选题)

    How are messages displayed when you use the SRW.MESSAGE packaged procedure? ()

    答案解析

  • (单选题)

    In which situation are you NOT required to perform an incomplete recovery?()

    答案解析

  • (单选题)

    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()

    答案解析

  • (单选题)

    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()  

    答案解析

  • (单选题)

    You are performing a database recovery because a user’s schema is dropped. While performing the recovery, you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing?()

    答案解析

  • (多选题)

    You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? ()

    答案解析

  • (单选题)

    Which command would you use to determine what database backups are currently available for restore?()

    答案解析

  • (单选题)

    Which command would you use to determine what database backups are currently available for restore?()  

    答案解析

快考试在线搜题