Unique key can have two null values?

Posted by Rajni.Shekhar on 4/17/2012 | Category: Sql Server Interview questions | Views: 3550 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

No, unique key can have only one null value because unique key enforces uniqueness of the column. So column can not have more than one NULL value.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What is check constraint?

Next > : What is the difference between primary key and uni ...

Comments or Responses

More Interview Questions by Rajni.Shekhar

What is the difference between primary key and unique key?
How can I encrypt sensitive data in the WCF configuration file?
What is Coalesce?
Syantax to create a stored procedure.
What is syntax to execute a stored procedure?
What is the syntax to create a table?
Can we write return statement in finally block?
What is fragment caching?

Latest Interview Questions

Where are Shared Assemblies stored?
Which is the most important component of the framework?
Is it possible to write more than 2 sql statements in a stored procedu ...
Which of the following is not a part of OOPs?
Which sign does jQuery use as a shortcut for jQuery?
I have a VIEWSTATE["Test"] in my Page, I am Refreshing Page ...
How Will You Get Textbox Value in Javascript?
Which OS does the .NET Framework run on?
More ...