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,最后打开数据库。)