Structure of the BOOKS table

-Which of the following is not a valid statement concerning identity columns.
A) A DEFAULT clause may be assigned
B) A unique constraint is automatically applied
C) Only one may be created in a table
D) Must have a numeric data type

Question

Structure of the BOOKS table
  ​
-​Which of the following is not a valid statement concerning identity columns.
A) ​A DEFAULT clause may be assigned 
B) ​A unique constraint is automatically applied 
C) ​Only one may be created in a table 
D) ​Must have a numeric data type

Quizplus · Accepted Answer

Identity columns are automatically assigned a unique value for each row and do not allow for a DEFAULT clause to be manually assigned.

Structure of the BOOKS Table