Which of the following sql commands adds a new VARCHAR2 column of length 20 named new_column to table test?
A)ALTER TABLE test
ADD (new_column VARCHAR2(20))
B)ADD column new_column VARCHAR2(20)to TABLE test
C)ADD to TABLE test (new_column VARCHAR2(20))
D)ALTER TABLE test (new_column VARCHAR2(20))

Question

Quizplus · Accepted Answer

The correct syntax for adding a new column to an existing table in Oracle SQL is ALTER TABLE table_name ADD (new_column datatype(length)). In this case, the datatype is VARCHAR2 and the length is 20, and the new column is named new_column. Option A provides the correct syntax for adding the new column to the test table. Option B is not a valid Oracle SQL syntax, option C is not correct syntax, and option D has incorrect syntax for the ALTER TABLE command.

Which of the Following Sql Commands Adds a New VARCHAR2