Can we use more than one null value for unique key?

Answer Posted / raman

Primary Key is a combination of Unique and NOT NULL
Constraints so it can’t have duplicate values or any NUll

Whereas for Oracle UNIQUE Key can have any number of NULL
but for SQL Server It can have only one NULL

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we join 3 tables in sql?

748


What are different types of queries in sql?

801


Are null values same as that of zero or a blank space?

776


hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1796


Define overloaded procedure?

847


Which join is default?

737


Is left join inner or outer?

794


What is the difference between left join and right join?

711


What are the types of sql commands?

797


What are the different types of a subquery?

758


How is debugging done?

759


What are packages in pl sql and also explain its advantages?

740


What programs use sql?

777


Does varchar need length?

743


what are the advantages of mysql in comparison to oracle? : Sql dba

768