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


Please Help Members By Posting Answers For Below Questions

Can you join views in sql?

729


Can 2 queries be executed simultaneously in a distributed database system?

868


how many ways to get the current time? : Sql dba

720


How to get list of all tables from a database?

854


How do you update a value in sql?

726


Is sql between inclusive?

799


How do I start sql profiler?

752


Is primary key always clustered index?

739


what is the difference between sql and t-sql? : Transact sql

820


what is row? : Sql dba

941


What is the difference between subquery and correlated query?

735


Does mysql support pl sql?

821


What is anonymous block in sql?

841


What is function and procedure in pl sql?

715


Could you please provide oca (oracle 10g) dumps for my certification ?

4802