1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

Define join and name different types of joins?

0 Answers  

---

what is a cursor

9 Answers   IBM, TCS, Wipro,

---

How can analyze query after generating explain plan ?

2 Answers   Thermotech,

---

What is coalesce sql?

0 Answers  

---

---

What is dml statement?

0 Answers  

---

How to run pl/sql statements in sql*plus?

0 Answers  

---

What is rank function in sql?

0 Answers  

---

what is the difference between implicit and explicit trigger

2 Answers   Tech Mahindra,

---

How bulk collect improves performance?

0 Answers  

---

What are commit, rollback, and savepoint?

0 Answers  

---

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,

---