Can we use more than one null value for unique key?
Answer Posted / guest
No, we cannot use more than one null value in unique key.
This is the major difference between primary key and unique
key.
Primary key cannot contain null values
Whereas unique key can contain only one null value
| Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
In a distributed database system, can we execute two queries simultaneously?
Why plvtab is considered as the easiest way to access the pl/sql table?
Can we connect to postgresql using sql developer?
What is Collation Sensitivity ? What are the various type ?
Is sqlite thread safe?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
How to look at the current sql*plus system settings?
What are all the different types of indexes?
What is autocommit sql?
what is msql? : Sql dba
How run sql*plus commands that are stored in a local file?
What is the difference between partitioning and sharding?
Which command is used to call a stored procedure?
How can get second highest salary in sql?