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

Answer Posted / anjani kumar

Yes,Multiple Null values are allowed in Unique key
Constraint because each Null is different from another Null
so there is no case of duplication.

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I create a memory optimized filegroup?

702


How to run sql functions in pl/sql?

727


what are all the different types of indexes? : Sql dba

721


What do we need to check in database testing?

733


Can %notfound return null after a fetch?

760






Write a unique difference between a function and a stored procedure.

723


What is int identity in sql?

760


What is the difference between drop and truncate commands?

708


How many types of indexes are there in sql?

723


how to use regular expression in pattern match conditions? : Sql dba

732


Is sql a backend?

773


How show all rows in sql?

799


What is a null value?

854


Which tcp/ip port does sql server run?

717


What is coalesce sql?

702