Which of the following statements would cause Oracle Database to include a new column named C5,which is a two-digit whole number,to a table named T2?
A)UPDATE TABLE T2 ADD COLUMN C5 NUMBER (2);
B)ALTER TABLE T2 ADD C5 NUMBER (2);
C)UPDATE TABLE T2 INSERT C5 NUMBER (2,0);
D)ALTER TABLE T2 INSERT COLUMN C5 NUMBER (2,0);

Question

Quizplus · Accepted Answer

To add a new column to a table, we use the ALTER TABLE command, and specify the table name, followed by the ADD COLUMN keywords, and the column name and data type. Therefore, the correct syntax to add a new column named C5, which is a two-digit whole number, to a table named T2 is:
ALTER TABLE T2 ADD C5 NUMBER(2);

Which of the Following Statements Would Cause Oracle Database to Include