Which keyword is used to define a default value for a column in a DDL statement?

• A. DEFAULT
• B. VALUE
• C. SET DEFAULT
• D. WITH DEFAULT

Answer: (A)

The DEFAULT keyword is used to define a default value for a column in DDL. It tells the database to automatically supply that value when an INSERT does not provide one for the column. For example, creating a table with a column that has DEFAULT 'active' means that if you insert a row without specifying that column, the value will be 'active'. If you explicitly provide a value, that value is used instead of the default, and if NULL is inserted (when allowed), the default is not applied. Other options shown aren’t standard keywords for setting a column’s default.