Answer Posted / rahul kumar

A) In cursors each time you fetch a new row it does a round
trip with the database thereby increase network use and time.

B) There is also restriction on select statements that can be
used in cursors

C) It also uses more resources and temporary memory

Cursors can be avoided with the help of careful
implementation of while loop and other set based operations

Write the fastest query to find out how many rows exist in a table?

1052

---

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2153

---

How to generate OIDS

2166

---

What is a database development?

898

---

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?

943

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

947

---

Explain the process of the user request and data generating?

1028

---

fact table and dimension table containg one to many relationship or many to one relastionship

2440

---

What are data modelling techniques?

897

---

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).

2157

---

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

945

---

How to combine two function together?

2057

---

Explain the rollup operator?

990

---

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?

2359

---

Explain about the hierarchical model of the database?

1054

---