Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 65403 Views
- A1 Technology, Wipro, I also Faced
- E-Mail Answers
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 transaction? : Sql dba
what are the advantages of sql ? : Sql dba
What does where 1/2 mean in sql?
What is the difference between rename and alias?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
How to change the order of columns in Oracle SQL Plus ?
What is the difference between Union and Union all. Which is faster.
What are the limitations of sql express?
What is pessimistic concurrency control? : Transact sql
What is before trigger?
Can I learn sql in a week?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
Which data type is a composite type?
What is difference between db2 and sql?
What is the maximum size of sqlite database?
