Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 65423 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 are dml commands?
What is the left table in sql?
What is foreign key sql?
What is graph sql?
Why we use join in sql?
What is the least restrictive isolation level? : Transact sql
What are all the different normalization?
What are few of the schema objects that are created using PL/SQL?
What program will open a mdb file?
Is a foreign key always unique?
What is java sql connection?
Explain alias in sql?
Is record in pl sql?
what is data manipulation language? : Sql dba
Does sql between include endpoints?
