Can we have more than one NULL in a column having unique
constraint?

Answer Posted / habibur rahaman

It depends upon the database on which you are working.....in SQL we can have only one value but in oracle we can have n no of values.......i did it practically.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between a check constraint and a rule?

620


Can truncate be rolled back?

534


Explain the microsoft sql server delete command? : SQL Server Architecture

575


What is view in sql?

557


How do I start sql server?

529






How can we remove orphan records from a table?

524


What will be query used to get the list of triggers in a database?

542


What number aggregate functions are accessible there in sql?

585


Is there any difference between the primary key and unique key?

567


What are the different types of Indexes available in SQL Server?

514


How to deploy the Report?

93


Where can you find the error log information? : sql server database administration

561


What is cursors?

636


What are the reporting services components?

92


What are the different types of sub-queries?

595