How many null values can be inserted in a coulmn whihc is unique constraint
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 is an index? : Sql dba
What are basic techniques of indexing?
Explain the usage of WHERE CURRENT OF clause in cursors ?
How many postgresql users are there, worldwide?
explain advantages of myisam over innodb? : Sql dba
what is the difference between nested subquery and correlated subquery?
What is the syntax and use of the coalesce function?
what is the difference between cluster and non cluster index? : Sql dba
Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.
What is the need of merge statement?
what is explain plan?
What is consistency?
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)