【2019年OCP新题】OCP题库更新出现大量新题-11

11.Your database is in archivelog mode.

You want to disable archiving for the database. Examine these steps:

1. Execute the alter database noarchivelog command.

2. Execute shutdown immediate.

3. Execute startup mount.

4. Set the db_recovery_file_dest parameter to $ORACLE_HOME/dbs/.

5. Execute startup nohount.

6. Open the database.

7. Execute shutdown transactional

Identify the required steps in the correct sequence.

A) 2, 5, 1, 6

B) 1, 2, 3, 4, 6

C) 4, 2, 5, 1, 6

D) 2, 3, 1, 6

Answer:D

(解析:把数据库改变为非归档模式,只要正常关闭数据库,然后在 mount 状态下执行 noarchivelog,最后打开数据库。)

原文地址:https://www.cnblogs.com/cnblogs5359/p/10768372.html