Question: Identify the correctly constructed ALTER TABLE statement that creates a new column called address with a data type of VARCHAR ( 1 0 0 )

Identify the correctly constructed ALTER TABLE statement that creates a new column called address with a data type of VARCHAR(100) in the customer table.
a.)
ALTER TABLE customer
ADD address;"
b.)
ALTER TABLE customer
ADD 'address' VARCHAR (100);
c.)
ALTER TABLE customer
DROP address VARCHAR (100);
d.)
ALTER TABLE customer
ADD address VARCHAR (100);

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!