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
Can we commit inside a trigger?
what is a stored procedure? : Sql dba
What is memory optimized table?
what is the command used to fetch first 5 characters of the string? : Sql dba
How to get unique records from a table?
What are database links used for?
define sql insert statement ? : Sql dba
What is an inconsistent dependency?
Explain what is a column in a table?
what are the differences among rownum, rank and dense_rank? : Sql dba
Can we call stored procedure in function?
What is pl sql variable?
What is blind sql injection?
What is scalar function in sql?
What is the difference between python and sql?