What are the various levels of constraints?

0 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

---

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

---

how to escape special characters in sql statements? : Sql dba

0 Answers  

---

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

---

---

Can we write dml inside a function in sql server?

0 Answers  

---

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

---

How to change sql*plus system settings?

0 Answers  

---

how to return query output in html format? : Sql dba

0 Answers  

---

overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

---

What is the clause we need to add in function body to return variable?

0 Answers  

---

What are different types of keys?

0 Answers  

---