007中一道答案錯誤的題目

Incorrect. Your answer was: A
The correct answer(s): B
Which of the following functions are performed by ALTER TABLE?
A.) All of the above
B.) It can be used to add fields
C.) It can be used to change name of the table
D.) It can be used to change name of the column

自己想了想，不對，答案應該是錯誤的。 後來在自己機器上做了一個實驗

SQL> alter table a rename to b;

Table altered.

SQL> desc b
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 ID                                        NOT NULL NUMBER(12)
 DPET_ID                                            NUMBER
 COMMISSION                                         NUMBER(4,2)

SQL> alter table b rename column commission to comm;

Table altered.

SQL> desc b
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 ID                                        NOT NULL NUMBER(12)
 DPET_ID                                            NUMBER
 COMM                                               NUMBER(4,2)
因為我的是10g的環境，所以又費勁找了一個9i的環境，做了同樣的實驗，結果相同，證明答案是錯誤的。