To create a DEFAULT constraint on the "City" column of the table PERSON which is already created, use the following SQL:

To create a DEFAULT constraint on the "City" column of the table PERSON which is already created, use the following SQL:

To create a DEFAULT constraint on the "City" column of the table PERSON which is already created, use the following SQL: 




a. ALTER TABLE Person
ALTER COLUMN City SET DEFAULT 'SANDNES'
b. ALTER TABLE Person
EDIT COLUMN City SET DEFAULT 'SANDNES'
c. ALTER TABLE Person
UPDATE COLUMN City SET DEFAULT 'SANDNES'
d. ALTER TABLE Person
MODIFY COLUMN City SET DEFAULT 'SANDNES'




Answer: A


Learn More :