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?
1469What is normalization? Explain different levels of normalization?
Wipro, Choice Solutions, IBM, College School Exams Tests, CG-VAK,
8 55891How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
1 7962Post New DB Development Questions
Explain the rollup operator?
Explain about the relational database?
What are the key features of dbms?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Which four data types cannot be used as a return type from a user-defined function?
What is the maximum length of an extended property?
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?
Explain about the database management systems.
Explain about a primary key?
How can I detect whether a given connection is blocked?
Explain about xml databases?
How would you design a database for an online site, which would average a million hits a day?
What is an application role and explain a scenario when you would use one?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What is dbms and its application?
