What are the different tcl commands in sql?

0 Answers  

---

How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 Answers  

---

wa procedure to return the month and the no'f developers joined in each month.

4 Answers   Fidelity,

---

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

---

How do you optimize a stored procedure in sql?

0 Answers  

---

---

State few characteristics of pl/sql?

0 Answers  

---

When would you denormalize?

8 Answers   MBT, Microsoft, MMU,

---

How many types of cursors are available in pl/sql?

0 Answers  

---

which tcp/ip port does sql server run on? : Sql dba

0 Answers  

---

In pl/sql, what is bulk binding, and when/how would it help performance?

0 Answers  

---

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

---

What is execute immediate?

0 Answers  

---