Can we have more than one NULL in a column having unique
constraint?
Answer Posted / p.prabhu
No we cant have More than One Null in a column which is
having Unique Key Constraint. Because Unique Key Constraint
means having a value only once in the column.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is an execution plan? How would you view the execution plan?
How to assign new column names in a view?
What is Federation and Federation Member?
What are dml triggers and types of dml triggers?
What is data block and how to define data block size?
What are ddl (data definition language) statements for tables in ms sql server?
Write a SQL query to make a column as unique?
How do you test your database? : sql server database administration
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
How to change the name of a database user?
How to use copy and concatenate commands in SQL?
Tell me about the approaches which you used to counter the DI problems.
Define right outer join in sql server joins?
what are isolation levels? : Sql server database administration
How can you know if the row fetched from cursor is still valid in underlying table?