Interested to Buy Any Domain ? << Click Here >> for more details...
How many null values can be inserted in a coulmn whihc is unique constraint
- 8 Answers
- 13138 Views
- Flextronics, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sumit
Any number of Null values can be inserted in such a column.
| Is This Answer Correct ? | 33 Yes | 7 No |
Answer / amit
Any no. of times you can insert null values in a coulmn
whihc is unique constraint because a Null value is
undefined,unassigned,and unapplicable value so thats why we
cannot compaire with any other null value or other value.
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / john bershan
any number of null value can be inserted into table for a
column which is declared as unique.coz null vale s either
not equal to any value or not equal to another null;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / manish kumar
Single null Value
B'cse Unique Constraint contain unique value and single
null is also a unique value.
| Is This Answer Correct ? | 7 Yes | 29 No |
What do you think about pl/sql?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What is a mutating table
What mean sql?
Do foreign keys improve performance?
What is range partitioning?
What is t sql in sql server?
What is auto increment in sql?
Types of joins?
What are indexes, and what are the different types?
What is cost in sql execution plan?
What is TABLE SPACE?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
