What are cursors? Explain different types of cursors?

6 Answers  

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

0 Answers  

---

What are the constraints on severity level in raiseerror?

0 Answers  

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

0 Answers  

---

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

0 Answers  

---

---

What is a self join? Explain it with an example?

16 Answers   TCS,

---

Explain about post-relational databases?

0 Answers  

---

How can you fix a poorly performing query?

0 Answers  

---

How to use timestamp datatypes

0 Answers  

---

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

0 Answers  

---

Explain the family trees and connection by clause.

1 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

0 Answers  

---