What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,

---

Explain lock escalation? : Transact sql

0 Answers  

---

What is a dynamic query?

0 Answers  

---

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

---

What is sql deadlock?

0 Answers  

---

---

How to avoid duplicate records in a query?

0 Answers  

---

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,

---

what are Dynamic SQL statements?

9 Answers  

---

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

4 Answers   Scope International,

---

What is a bitmap index?

4 Answers   Choice Solutions, Infosys,

---

how to include numeric values in sql statements? : Sql dba

0 Answers  

---

What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,

---