Q5
In SQL, which command(s) is(are) used to change a table's storage characteristics?
A.
ALTER TABLE
AnswerB.
MODIFY TABLE
C.
CHANGE TABLE
D.
All of the above
Answer: Option A
Solution
Answer: Option A
Solution:
To change the structure of the table we use ALTER TABLE.
Sytax:
ALTER TABLE "table_name"
ADD "column_name" datatype
OR
ALTER TABLE "table_name"
DROP COLUMN "column_name"
etc..