Examveda
Examveda

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 above

Answer: Option A

Solution(By Examveda Team)

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

Comments ( 1 )

  1. Oladepo Korede
    Oladepo Korede :
    1 year 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;

Related Questions on Sql Miscellaneous

NULL is

A. the same as 0 for integer

B. the same as blank for character

C. the same as 0 for integer and blank for character

D. not a value