0 votes
111 views
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
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.

...