0 votes
in Oracle by

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

1 Answer

0 votes
by

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”.

Related questions

0 votes
asked Nov 25, 2021 in Oracle by DavidAnderson
0 votes
asked Nov 25, 2021 in Oracle by DavidAnderson
...