How many different types of indexes we have in oracle?

24 Answers   IBM, TCS,

---

write a query that displays every Friday in a year with date?

5 Answers   Flipkart, HCL, TCS,

---

which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help

5 Answers  

---

What is an Index ?

2 Answers  

---

What are virtual columns?

2 Answers   TCS,

---

---

What is a OUTER JOIN?

1 Answers  

---

Briefly explain what is literal? Give an example where it can be used?

0 Answers  

---

What are main difference between Stored Procedure and Functions.

6 Answers   CA, Metric Stream,

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

0 Answers   iFlex,

---

What is a parameter file in oracle?

0 Answers  

---

What are the parameters that we can pass through a stored procedure?

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  

---