Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / talent pool

If we use more than one, it leads to
duplicate, which effects the fundamental property of unique
key.

But......
We can insert any number of null values in the column which
contains the unique key.
The reason is NULL is not equal to anothere NUll
so each null is different so there is no question of
duplication

Is This Answer Correct ?    57 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we commit inside a trigger?

956


what is a stored procedure? : Sql dba

1080


What is memory optimized table?

1002


what is the command used to fetch first 5 characters of the string? : Sql dba

1604


How to get unique records from a table?

915


What are database links used for?

1010


define sql insert statement ? : Sql dba

986


What is an inconsistent dependency?

1002


Explain what is a column in a table?

1059


what are the differences among rownum, rank and dense_rank? : Sql dba

1005


Can we call stored procedure in function?

918


What is pl sql variable?

951


What is blind sql injection?

1016


What is scalar function in sql?

994


What is the difference between python and sql?

951