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?
What is an application role and explain a scenario when you would use one?
What are the three types of database design?
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?
I have a few records all are same structures data, I want to store data in multiple targets how
Explain what a database is?
Write short notes on manual refreshes.
Explain about post-relational databases?
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?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
How to generate OIDS
Where is dbms used?
How to read and create .LDC data files which are used by linguatic dictionary.
How would you design a database for an online site, which would average a million hits a day?
Which data type cannot be used as a parameter in a udf?