0 votes
11 views
ago in Computer Science by (8.5k points)
A) What constraint should be applied on a table column so that duplicate values are not allowed in that column, but NULL is allowed.

OR

B) What constraint should be applied on a table column so that NULL is not allowed in that column, but duplicate values are allowed.

1 Answer

0 votes
ago by (56.5k points)
 
Best answer

A) UNIQUE constraint should be applied on a table column so that duplicate values are not allowed in that column, but NULL is allowed.

OR 

B) NOT NULL constraint should be applied on a table column so that NULL is not allowed in that column, but duplicate values are allowed.

...