Can we use more than one null value for unique key?
Answer Posted / slimtech
The answer to this question depends on the database that we
are using
1. In SQL Server and DB2, we can insert only one null value
in the Unique Key column.
2. In Oracle, we can insert multiple null values
| Is This Answer Correct ? | 31 Yes | 0 No |
Post New Answer View All Answers
Can I create table without primary key?
What does subquery mean in sql?
Can we rollback truncate?
Can we delete column in sql?
Does truncate remove indexes?
What is scalar function in sql?
Is sql free?
What operating systems are supported by oracle sql developer?
What is difference between inner join and cross join?
What is the cause of mutating table error and how can we solve it?
what is the difference between a web-garden and a web-farm? : Sql dba
how to increment dates by 1 in mysql? : Sql dba
Explain commit, rollback and savepoint.
what is normalization? : Sql dba
What are different types of keys?