Question

In SQL, which command(s) is(are) used to change a table’s storage characteristics?

(a) ALTER TABLE

(b) MODIFY TABLE

(c) CHANGE TABLE

(d) All of the Mentioned

The question was asked in an internship interview.

I need to ask this question from DDL Command in section SQL Basics of Oracle

Answer 1

Right answer is (a) ALTER TABLE

The explanation: To change the structure of the table we use ALTER TABLE Syntax:

ALTER TABLE “table_name” ADD “column_name” datatype

OR

ALTER TABLE “table_name” DROP COLUMN “column_name”.