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 data integrity? : Sql dba
What is the example of procedure?
What is rollback?
How to call a javascript function from pl sql?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is the sql query to display the current date?
What is equi join in sql?
What are the disadvantages of not performing database normalization?
what are the disadvantages of mysql? : Sql dba
How to pipe multiline string to isql?
What is a temporal data type?
Are sql database names case sensitive?
What is the difference between in and between in sql?
What is the difference between a query and a report?
Does sql view stored data?