Can we have more than one NULL in a column having unique
constraint?
Answer Posted / krishnaraj p n
UNIQUE constraints can accept NULL just once. If the
constraint is defined in a combination of fields, then
every field can accept NULL and can have some values on
them, as long as the combination values is unique.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the exact numeric data type in sql?
What is 5nf in normalization form?
What is an indice?
What is temporary stored procedure?
do views contain data ?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What is b tree index?
what is nonclustered index
Is the log file is a part of file group?
What are the different types of sql server replication? : sql server replication
What is query optimizer in sql server?
Explain differentiate between a having clause and a where clause?
Is candidate a key?
How to create a simple stored procedure in ms sql server?