Which statement or statements should you execute?

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.)

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *