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
What is the maximum rows in csv?
what are ddl statements in mysql? : Sql dba
What is schema in sql?
Explain commit, rollback and savepoint.
What is dcl in sql?
How can you view the errors encountered in a trigger?
What is the starting oracle error number? What is meant by forward declaration in functions?
what are the 'mysql' command line options? : Sql dba
What is an index in sql with example?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
Does sqlite need a server?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What is int identity in sql?
What is the use of non clustered index?
How are functions and procedures called in PL/SQL?