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

Answer Posted / slimtech

The answer to this question depends on the database that we
are using
1. In SQL Server and DB2, we can insert only one null value
in the Unique Key column.
2. In Oracle, we can insert multiple null values

Is This Answer Correct ?    31 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

595


how to increment dates by 1 in mysql? : Sql dba

539


What is a variable in sql?

511


What is difference between pls_integer and integer?

516


Describe sql comments?

559






What does partition by mean in sql?

513


what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

615


What is full join?

525


What is meaning of <> in sql?

583


What are three advantages to using sql?

549


How many types of indexes are there in sql?

535


List the different type of joins?

569


What is sql indexing?

552


What is case function?

596


What is auto increment?

580