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

Which join condition can be specified using on clause?

519


What is pl sql block structure?

549


what are wild cards used in database for pattern matching ? : Sql dba

557


how can we optimize or increase the speed of a mysql select query? : Sql dba

515


What are the constraints available in sql?

588






What is use of term?

626


What is auto increment?

584


Can a view be mutating? If yes, then how?

584


Inline the values in PL/SQL, what does it mean.?

637


What is composite data type in pl sql?

566


What are the two characteristics of a primary key?

497


What is pl sql package?

602


What is trigger in flip flop?

522


What is mutating sql table?

615


Is pl sql useful?

545