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  

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

0 Answers  

---

How to generate OIDS

0 Answers  

---

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

16 Answers   TCS,

---

In which database can extended stored procedures be added?

0 Answers  

---

---

How can I detect whether a given connection is blocked?

0 Answers  

---

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

0 Answers  

---

Which four data types cannot be used as a return type from a user-defined function?

0 Answers  

---

Which data type cannot be used as a parameter in a udf?

0 Answers  

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

0 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

1 Answers   Flextronics, Hexaware, SQL Star,

---

What are the disadvantages of cursors? How can you avoid cursors?

2 Answers  

---