Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 64390 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
Explain 3 basic parts of a trigger.
Explain how to use transactions efficiently : transact sql
Which table is left in join?
what are the limitations of identity column? : Transact sql
What are dml commands?
Enlist the characteristics of pl/sql?
What is cursor explain with example?
Is it mandatory for the primary key to be given a value when a new record is inserted?
What are sql constraints?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
What is trigger price?
Can you rollback after commit?
Is pl sql and postgresql same?
What is the difference among union, minus and intersect?
What are the different types of sql commands?
