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

Answer Posted / christina

Yes, We can use more then one null value in unique key ,
because "null" means undefined or unknown so we can add any
number of null values in unique key...
This is the major difference between primary nd unique key,
Primary key doesn't allow null values to be entered into
the columns marked as priamry key and Unique allow us to
enter null values...............

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does a trigger work?

770


what is a database lock ? : Sql dba

879


How bulk collect improves performance?

793


What is fmtonly in sql?

767


What is on delete set null?

877


Which is better cte or subquery?

783


what are integrity rules?

811


How can you fetch first 5 characters of the string?

759


What are the topics in pl sql?

768


what is denormalization. : Sql dba

836


What are the different type of joins in sql?

768


How do I delete a trigger?

769


Which join is default?

750


How can we make an if statement within a select statement?

800


how to select unique records from a table? : Sql dba

880