Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 64540 Views
- A1 Technology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / hassan khan
A unique key constraint does not imply the NOT NULL
constraint in practice. Because NULL is not an actual value
(it represents the lack of a value), when two rows are
compared, and both rows have NULL in a column, the column
values are not considered to be equal. Thus, in order for a
unique key to uniquely identify each row in a table, NULL
values must not be used. According to the SQL standard and
Relational Model theory, a unique key (unique constraint)
should accept NULL in several rows/tuples — however not all
RDBMS implement this feature correctly.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define commit, rollback and savepoint?
Is primary key a clustered index?
How many joins can you have in sql?
what are ddl statements in mysql? : Sql dba
When do we use triggers?
What is sql and also describe types of sql statements?
Can variables be used in sql statements?
Enlist some predefined exceptions?
What is the current version of sql?
What is the difference between count 1 and count (*) in a sql query?
What is Materialized View? In What Scenario we Use Materialized View?
What is trigger and how to use it in sql?
How do I run a script in sql developer?
Can triggers stop a dml statement from executing on a table?
What is not null in sql?
