Contents of the PUBLISHER table

-If a column named SAL_PCT is to be defined to ensure a value of 100 is input if a NULL value is provided when a new row is inserted,which column definition should be used?
A) SAL_PCT NULL 100 DEFAULT.
B) SAL_PCT DEFAULT ON NULL 100.
C) SAL_PCT DEFAULT 100.
D) SAL_PCT ON NULL 100.

Question

Contents of the PUBLISHER table​
 
-If a column named SAL_PCT is to be defined to ensure a value of 100 is input if a NULL value is provided when a new row is inserted,which column definition should be used?​
A) ​SAL_PCT NULL 100 DEFAULT. 
B) ​SAL_PCT DEFAULT ON NULL 100. 
C) ​SAL_PCT DEFAULT 100. 
D) ​SAL_PCT ON NULL 100.

Quizplus · Accepted Answer

The correct syntax to ensure a default value of 100 is used when a NULL value is attempted to be inserted into the SAL_PCT column is "DEFAULT ON NULL 100". This explicitly instructs the database to use the default value of 100 when a NULL value is provided.

Contents of the PUBLISHER Table​

Contents of the PUBLISHER Table