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

What is the basic structure of an sql?

789


What is the difference between function, procedure and package in pl/sql?

804


what does myisamchk do? : Sql dba

771


What are tuples in sql?

806


What is a sql instance vs database?

795


What are the different ddl commands in sql?

784


what happens if null values are involved in expressions? : Sql dba

763


Does view store data in sql?

728


How is indexing done in search engines?

740


what are all the different types of indexes? : Sql dba

742


What are the parts of a sql statement?

806


how do you control the max size of a heap table? : Sql dba

724


What are the benefits of stored procedures?

745


What is range partitioning?

718


What is primary key secondary key alternate key candidate key?

791