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 the primary use of normalization?
Can we create table in function?
how do you count the duplicate records in a table
suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?
If we have n no of columns in a table, can we add new column in that table with not null constraint?
Difference between table function and pipelined function?
what is a constraint? : Sql dba
What is the current version of postgresql?
What is a dirty read sql?
What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What are reports usually 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)