Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 64096 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 are procedures used for?
Which is faster view or stored procedure?
Can we use ddl commands in pl sql?
Mention what is the plv (pl/vision) package offers?
explain advantages of innodb over myisam. : Sql dba
What is sqlite used for?
What is memory optimized table?
Mention what pl/sql package consists of?
What are the dml statements?
what is a composite key ? : Sql dba
How to display Row Number with Records in Oracle SQL Plus?
What are sql injection vulnerabilities?
What is scope and visibility in PL/SQL?
What is multiple partition?
Can we use joins in subquery?
