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 phonenumber 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 phonenumber can handle NULL values, assuming the column does not already exist?
Group of answer choices
ALTER TABLE instructor ADD phonenumber VARCHAR;
ALTER TABLE instructor ADD phonenumber VARCHAR NOT NULL;
ALTER TABLE instructor ADD phonenumber VARCHAR DEFAULT NULL;
ALTER TABLE instructor ADD phonenumber VARCHAR CHECK phonenumber IS NOT NULL;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
