The database contains a disk-based table named ContentTable that has 1 million rows and a column named
Fax. Fax allows null values.
You need to update Fax to meet the following requirements:
Prevent null values from being used.
Always use an empty string instead of a null value.
Which statement or statements should you execute? (Each correct answer presents part of the solution.
Choose all that apply.)
A.
Option A
B.
Option B
C.
Option C
D.
Option D
E.
Option E
Explanation:
E: First change the NULLs to ‘ ‘.
A: Then set the default to the column to ‘ ‘.
B: Finally add the NOT NULL constraint to the column.