Detailed explanation and options for the selected question.
The DEFAULT constraint assigns a value to a column if none is provided. It does not enforce uniqueness, referential integrity, or prevent NULLs.