Can we use more than one null value for unique key?
- 31 Answers
- 59890 Views
- A1 Technology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / millerdq
The argument that no two nulls are equal does not prove
anything because it's also true that no two nulls are
different.
if null <> null ..... is false
So, one could also claim that a unique key requires that
all values are unique, given that two nulls are not unique,
it is therefore not allowed.
The fact is, ansi standard says multiple nulls are
permitted in a unique key. However, not all dbms's are
compliant. Oracle permits it; SQL Server does not.
So, best answer...it depends on the dbms
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is difference between stored procedure and trigger?
Can you have more than one key in a database?
How do you update a value in sql?
What is record variable?
explain access control lists. : Sql dba
what are the differences among rownum, rank and dense_rank? : Sql dba
tell me about various levels of constraint. : Sql dba
What are the 3 modes of parameter?
Differentiate between syntax and runtime errors.
How do I start sql from command line?
What are stored procedures used for?
What is minus?
What is denormalization in a database?
How do I run pl sql in sql developer?
what is column? : Sql dba
