nerdexam
Oracle

1Z0-043 · Question #79

You want to configure the Flashback Database feature and retain flashback logs for three days. The steps used in this process are: (A) Set the retention target: SQL> ALTER SYSTEM SET…

The correct answer is A. D, C, A, B, E. See the full explanation below for the reasoning.

Question

You want to configure the Flashback Database feature and retain flashback logs for three days. The steps used in this process are:

(A) Set the retention target:

SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320; (B) Enable Flashback Database:

SQL> ALTER DATABASE FLASHBACK ON; (C) Mount the database:

SQL> STARTUP MOUNT EXCLUSIVE; (D) Shut down the instance:

SQL> SHUTDOWN IMMEDIATE; (E) Open the database:

SQL> ALTER DATABASE OPEN; In what sequence would you need to perform these steps to enable the Flashback Database feature?

Options

  • AD, C, A, B, E
  • BD, A, C, B, E
  • CB, D, C, E, A
  • DD, B, E, C, A

How the community answered

(24 responses)
  • A
    75% (18)
  • B
    8% (2)
  • C
    13% (3)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice