ExamVeda
Login
Home
This question belongs to SQL Sql Miscellaneous
Sql Miscellaneous
?

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

Examveda
Question posted by Examveda
Community

Join the Discussion

1 Comment
Oladepo Korede
Oladepo Korede 9 years ago
A. SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70;

B. 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;