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?

2420

What is an application role and explain a scenario when you would use one?

1011

What are the three types of database design?

1024

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?

962

I have a few records all are same structures data, I want to store data in multiple targets how

2651

Explain what a database is?

1044

Write short notes on manual refreshes.

2733

Explain about post-relational databases?

1019

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?

2428

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

1013

How to generate OIDS

2253

Where is dbms used?

1078

How to read and create .LDC data files which are used by linguatic dictionary.

2530

How would you design a database for an online site, which would average a million hits a day?

1010

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

974