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 sql does db2 use?
Is foreign key mandatory?
Can ddl statements be used in pl/sql?
What are the different type of joins in sql?
What is the use of cursor ? how cursor allocate context area for executing the sql statement?
How to call DDL statements from pl/sql?
What are Lexical Parameters.How They are used in Reports 6i
How many types of triggers exist in pl/sql?
What is update query?
What is Referential Integrity?
What is difference between % ROWTYPE and TYPE RECORD ?
What is sql used for?
Oracle (3253)
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)