053 第561题

561.If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode,
what will be the result when you issue the command alter database archivelog?
A. The alter database archivelog command will fail.
B. The alter database archivelog inconsistent command must be used to put the database in
ARCHIVELOG mode.
C. The alter database archivelog command will succeed.
D. The alter database archivelog command will ask if you want to make the database consistent first.
E. There is no alter database archivelog command. The correct command is alter database alterlogging.
Answer: A

实验验证如下：

SQL> shutdown abort;
ORACLE 例程已经关闭。
SQL> startup mount;
ORACLE 例程已经启动。


Total System Global Area 1071333376 bytes
Fixed Size                  1375792 bytes
Variable Size             738197968 bytes
Database Buffers          327155712 bytes
Redo Buffers                4603904 bytes
数据库装载完毕。
SQL> alter database archievelog;
alter database archievelog
                         *
第 1 行出现错误:
ORA-02231: ALTER DATABASE 选项缺失或无效




SQL> alter database archivelog;
alter database archivelog
*
第 1 行出现错误:
ORA-00265: 要求实例恢复, 无法设置 ARCHIVELOG 模式