Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 65486 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
How do you declare a user-defined exception?
what is 'mysqlimport'? : Sql dba
what are the differences between char and nchar? : Sql dba
what is subquery? : Sql dba
Why do we use procedures?
What is a data definition language?
What is the difference between having and a where in sql?
What are packages in pl sql and also explain its advantages?
Can we insert data into materialized view?
Is sqlexception checked or unchecked?
What are triggers and its types?
What is a table partition?
Explain how exception handling is done in advance pl/sql?
Who developed sql?
How long it takes to learn pl sql?
