OCP-1Z0-053-200题-84题-660

QUESTION 84

You want to configure the Flashback Database featureand retain flashback logs for three days. Presentlythe

database is open and configured in ARCHIVELOG mode.

The following steps must be performed in the correct sequence to do this:

1. Set the retention target:

SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320;

2. Enable Flashback Database:

SQL> ALTER DATABASE FLASHBACK ON;

3. Mount the database:

SQL> STARTUP MOUNT EXCLUSIVE

4. Shutdown the instance:

SQL> SHUTDOWN IMMEDIATE

5. Open the database:

SQL> ALTER DATABASE OPEN;

Choose the correct sequence.

A. 4, 1, 3, 2, 5

B. 4, 3, 1, 2, 5

C. 2, 4, 3, 5, 1

D. 4, 2, 5, 3, 1

Answer: B

同660题:http://blog.csdn.net/rlhua/article/details/11889343


Explanation/Reference:

Section: Flashback Operations & Configuration

原文地址:https://www.cnblogs.com/hzcya1995/p/13316033.html