what are the methods using performance tunning in sql and pl/sql

2 Answers  

---

What are the different types of dbms?

0 Answers  

---

What is the advantage of index in sql?

0 Answers  

---

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,

---

what are string data types? : Sql dba

0 Answers  

---

can i write pl/sql code in a package

2 Answers  

---

Explain ttitle and btitle.

0 Answers  

---

What is the mutating table and constraining table?

0 Answers  

---

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

---

Mention what does plv msg allows you to do?

0 Answers  

---

What is the syntax to add a record to a table?

0 Answers  

---

Give the structure of the procedure ?

1 Answers  

---