Explain constraints in sql?

0 Answers  

---

What is a temp table?

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 inner and outer joins examples of both?

0 Answers  

---

There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

2 Answers   Maruti Suzuki,

---

What are triggers in sql?

0 Answers  

---

What is an inconsistent dependency?

0 Answers  

---

How to sort the rows in sql.

0 Answers  

---

diff b/w sub query and co-relater query?

3 Answers   iFlex,

---

What is the usage of sql functions?

0 Answers  

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  

---

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

---