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

What is the maximum rows in csv?

977


what are ddl statements in mysql? : Sql dba

1263


What is schema in sql?

998


Explain commit, rollback and savepoint.

1053


What is dcl in sql?

1024


How can you view the errors encountered in a trigger?

1022


What is the starting oracle error number? What is meant by forward declaration in functions?

1040


what are the 'mysql' command line options? : Sql dba

1129


What is an index in sql with example?

1018


what is the difference between rownum pseudo column and row_number() function? : Sql dba

1131


Does sqlite need a server?

1096


how to create a new table by selecting rows from another table in mysql? : Sql dba

1164


What is int identity in sql?

1202


What is the use of non clustered index?

1042


How are functions and procedures called in PL/SQL?

1306