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

来源:互联网 发布:java判断上传文件大小 编辑:程序博客网 时间:2024/05/01 01:57

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

0 0