?
In SQL, which command(s) is(are) used to change a table's storage characteristics?
Answer & Solution
Correct Answer:
Option
A
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..
Join the Discussion
Login to post a comment or share your explanation.
LoginB. SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70;
C. SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;
D. SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70;