Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

---

what is difference between foreign key and reference key

3 Answers   AZTEC, Infosys,

---

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

0 Answers   Atos Origin,

---

Explain the different normalization forms?

0 Answers  

---

How to start instance with a minimal initialization parameter file?

0 Answers  

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

0 Answers   Mastek,

---

How can we find out the duplicate values in an oracle table?

0 Answers  

---

What is mean by Program Global Area (PGA) ?

9 Answers   Bajaj,

---

What is meant by joins?

0 Answers  

---

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 Answers  

---

What WHERE CURRENT OF clause does in a cursor?

2 Answers  

---

Differentiate between pre-select and pre-query?

0 Answers  

---