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

Answer Posted / debdut bhaumik

Yes , More than one field can be NULL in a unique Key
column. Because a Null values is not equal to another null
value. So, no duplicate value is there.

Is This Answer Correct ?    26 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

773


What is the maximum number of rows in sql table?

745


Why do we need sharding?

732


What is data modelling in sql?

712


Can you rollback after commit?

719






What is a procedure in pl sql?

783


What is cursor in pl sql with examples?

676


How much does sqlite cost?

728


Does truncate free space?

713


How to select 10 records from a table?

846


Why do we use joins?

779


What is difference between rank () row_number () and dense_rank () in sql?

811


How many functions are there in sql?

724


What is cursor explain with example?

735


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

721