What is cost in sql execution plan?

0 Answers  

---

When to use inner join and left join?

0 Answers  

---

Which is faster joins or subqueries?

0 Answers  

---

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

---

Which command is used to call a stored procedure?

0 Answers  

---

---

What is database white box testing and black box testing?

0 Answers  

---

Can we create a trigger on view?

0 Answers  

---

What are types of joins?

0 Answers  

---

What is bulk collections?

2 Answers  

---

How to display all Friday's in a year with date?

4 Answers   Flipkart,

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

4 Answers   CGI, IBM,

---

HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 Answers  

---