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?
1968What is normalization? Explain different levels of normalization?
CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,
8 59618How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
1 9118Post New DB Development Questions
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?
Who are naive users?
What is the physical representation for a many-to-many relationship?
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?
Who are end users in dbms?
Explain about the hierarchical model of the database?
Explain about the storage and physical database design?
How is data stored in dbms?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What are the three basic rules which are to be followed for the relational model of the database?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
How to read and create .LDC data files which are used by linguatic dictionary.
What are the 18 schemas?
Explain about normal forms?
How to customize error conditions.