Home » MCQs » Oracle MCQs » Oracle Tables MCQs

What is the syntax to add column in the table?

16. What is the syntax to add column in the table?

1. ALTER TABLE table_name ADD column_name column-definition;
2. ALTER TABLE table_name ALTER column_name column-definition;
3. ALTER TABLE table_name UPDATE column_name column-definition;
4. ALTER TABLE table_name NEW column_name column-definition;

Answer: A) ALTER TABLE table_name ADD column_name column-definition;

Explanation:

Syntax to add column in the table is,

ALTER TABLE table_name ADD column_name column-definition;