Which Of The Following Combination Of Statements Can Be Used To #356
Which of the following combination of statements can be used to add the NOT NULL constraint to an existing column?
This multiple choice question (MCQ) is related to the book/course
gs gs115 Structured Query Language.
It can also be found in
gs gs115 SQL Constraints - SQL Not Null - Quiz No.1.
Which of the following combination of statements can be used to add the NOT NULL constraint to an existing column?
UPDATE table_name SET column_name = <value> WHERE column_name IS NULL; & ALTER TABLE table_name ALTER COLUMN column_name data_type NOT NULL;UPDATE table_name SET column_name = <value> WHERE column_name IS NOT NULL; & ALTER TABLE table_name ALTER COLUMN column_name data_type IS NULL;UPDATE table_name SET column_name = <value>; & ALTER TABLE table_name ALTER COLUMN column_name data_type NOT NULL;UPDATE table_name SET column_name = <value> WHERE column_name IS NULL; & ALTER TABLE table_name ALTER COLUMN column_name data_type;
