Answer Posted / arika

We can insert duplicate nul values in palce of using unique
key constrint.Because all nulls are not equal.


ex:-
select * from emp where comm=null;
explenation;
here equal operator not support null value because
all nulls are not equal
ex:-
select * from emp where comm is null;
explenation:
'is' operator suport null

what is the difference between cluster and non cluster index? : Sql dba

763

---

Define union, minus, union all, intersect ?

774

---

How is data stored on a disk?

769

---

how can you see all indexes defined for a table? : Sql dba

756

---

what is the difference between join and union? : Sql dba

770

---

What are the different ddl commands in sql?

807

---

Can we join more than 2 tables in sql?

714

---

Is stored procedure faster than query?

765

---

how to check myisam tables for errors? : Sql dba

951

---

How do I get sql certification?

744

---

How do you bind variables in pl sql?

815

---

What are aggregate functions in sql?

883

---

how is myisam table stored? : Sql dba

819

---

What are joins in sql?

762

---

How many triggers can be applied to a table?

821

---