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的环境，做了同样的实验，结果相同，证明答案是错误的。