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 COLUMN C5 NUMBER (2);
C)UPDATE TABLE T2 INSERT C5 NUMBER (2,0);
D)ALTER TABLE T2 INSERT COLUMN C5 NUMBER (2,0);
E)ALTER TABLE T2 ADD C5 NUMBER (2);

Question

Quizplus · Accepted Answer

The correct SQL syntax to add a new column to an existing table in Oracle Database is "ALTER TABLE [table_name] ADD [column_name] [data_type];".

Which of the Following Statements Would Cause Oracle Database to Include