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?
1569What is normalization? Explain different levels of normalization?
CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,
8 56471How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
1 8087Post New DB Development Questions
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
What are the three basic rules which are to be followed for the relational model of the database?
What are the types of database model?
Explain what a database is?
Explain the role of indexing in databases?
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?
What is an application role and explain a scenario when you would use one?
Explain about query and reporting.
How to read and create .LDC data files which are used by linguatic dictionary.
What is dbms explain in brief?
What are data modelling techniques?
Write the fastest query to find out how many rows exist in a table?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
How to use online Backups?
State the acid rules?