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 to return multiple rows from the stored procedure?

748


Why truncate is used in sql?

749


How much does sqlite cost?

752


How do I add a database to sql?

825


How do we accept inputs from user during runtime?

757


Why do we use set serveroutput on?

720


What are the disadvantages of file system?

873


Which operator is used in query for pattern matching?

863


What is the difference between python and sql?

746


How do I count duplicates in sql?

793


Can we perform dml on view?

757


What is a call statement? Explain with an example.

777


How to Execute a Package in PL/SQL.?

846


Write a sql query to get the third highest salary of an employee from employee_table?

869


What are the benefits of triggers?

936