Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 66478 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 pessimistic concurrency control? : Transact sql
How do I count rows in sql?
Is pl sql better than sql?
Can we call procedure in select statement?
How to return multiple rows from the stored procedure?
What is oracle sql developer?
What is the difference between sql and mysql?
Why stored procedures are faster than query?
Is left join faster than inner join?
how to analyze tables with 'mysqlcheck'? : Sql dba
What is anonymous block in sql?
How is use pl and sql?
Why is normalization important?
how to create a table index in mysql? : Sql dba
How to create an array in pl/sql?
