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  

---

What is the system function to get the current user's user id?

4 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  

---

In which database can extended stored procedures be added?

0 Answers  

---

What is denormalization and when would you go for it?

9 Answers   NBP,

---

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

0 Answers  

---

What is dbms explain in brief?

0 Answers  

---

Explain about relational database management systems?

0 Answers  

---

How you can make a parameterized view?

0 Answers  

---

Explain the process of the user request and data generating?

0 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  

---

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

0 Answers   IBM,

---