单选题

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?()  

    单选题查看答案