Can we use more than one null value for unique key?

Answer Posted / ravin

Yes we can..
Hey guys.. don't be confused with the values and nulls.
Unique key conforms only the values to be unique. Since the
nulls are not any kind of value, they can occur as many
times as they can.. nulls are nothing..

Is This Answer Correct ?    13 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you tell the difference between an index and a view?

487


What is the difference between row level and statement level trigger?

510


Can we use distinct and group by together?

582


What are some emotional triggers?

566


What are types of exception?

530






What is a sql trace file?

542


Why do we use procedures in pl sql?

516


Why select is used in sql?

514


What is sql catalog?

555


What is int identity in sql?

569


what does the t-sql command ident_current does? : Transact sql

535


Explain locks? : Transact sql

564


What are the different set operators available in sql?

562


How do you update a value in sql?

545


Is primary key clustered or nonclustered?

554