053 第561題，053561題

053 第561題，053561題
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 模式

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。