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?
1979What is normalization? Explain different levels of normalization?
CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,
8 59764How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
1 9152Post New DB Development Questions
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).
How to read and create .LDC data files which are used by linguatic dictionary.
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
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?
How to use timestamp datatypes
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?
State the acid rules?
How to generate OIDS
In which database can extended stored procedures be added?
Explain about relational operator join?
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?
Explain about the database management systems.
What is a database development?
Explain the process of the user request and data generating?