Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 65319 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 the difference between delete and truncate commands? : Sql dba
what is the difference difference between procedure and packages
What is before and after trigger?
Can a primary key be a foreign key?
Where is all the data on the internet stored?
Is not equal in sql?
What is varchar sql?
What is the difference between microsoft access and sql?
How do you identify a primary key?
How to start the command-line sql*plus?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What are sql commands?
Is mariadb nosql?
Why should I use postgresql?
What are the properties of a transaction?
