Question: You are managing a university database system and you need to handle optional information in the instructor table. The phone _ number field should allow

You are managing a university database system and you need to handle optional information in the instructor table. The phone_number field should allow for the possibility that an instructor's phone number is not provided.
Which SQL statement correctly alters the instructor table to ensure that phone_number can handle NULL values, assuming the column does not already exist?
Group of answer choices
ALTER TABLE instructor ADD phone_number VARCHAR(15);
ALTER TABLE instructor ADD phone_number VARCHAR(15) NOT NULL;
ALTER TABLE instructor ADD phone_number VARCHAR(15) DEFAULT NULL;
ALTER TABLE instructor ADD phone_number VARCHAR(15) CHECK (phone_number IS NOT NULL);

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 Databases Questions!