nerdexam
Oracle

1Z0-043 · Question #182

You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP ('11:45','hh12:mi'); Which two statements are correct? (Choose two.)

The correct answer is C. The changes made to the EMP table since the specified time will be undone. E. The FLASHBACK TABLE statement will be executed within a single transaction. See the full explanation below for the reasoning.

Question

You executed the following FLASHBACK TABLE command:

FLASHBACK TABLE emp TO TIMESTAMP ('11:45','hh12:mi'); Which two statements are correct? (Choose two.)

Options

  • AThe FLASHBACK TABLE statement will not be written to the alert log file.
  • BThe EMP table that was dropped by mistake from the database will be restored.
  • CThe changes made to the EMP table since the specified time will be undone.
  • DThe FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.
  • EThe FLASHBACK TABLE statement will be executed within a single transaction.
  • FThe list of transactions that have modified the EMP table since the specified time will be displayed.

How the community answered

(21 responses)
  • B
    14% (3)
  • C
    71% (15)
  • D
    10% (2)
  • F
    5% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice