Cascading update in DBMS
What do you understand by the term cascading update in DBMS?
Expert
Referential integrity constraints need that foreign key values in one table correspond to primary key values in any other. When the value of the primary key is altered – i.e., updated -- the value of the foreign key must instantly be changed to match it. Cascading updates will setup this alter to be done automatically by the DBMS when essential.
Why is modeling time-dependent data important with a time stamp?
Explain the Data Transformation Manager (DTM)?
Write about the term Data stage architecture?
Briefly describe the reason of synchronization function offered in Analysis Services 2005 ?
Briefly explain SQL Server 2005 Business Intelligence components?
Explain how teradata ensures that there are no duplicate rows being inserted when it’s a SET table?
What do you understand by the term snapshot replication in DBMS?
Describe briefly the difference between pessimistic locking and optimistic locking?
What is meant by the Drill Through?
Explain the term queue in data structure? Answer: In data structure a queue is a sequential organization of data. It is a first in first out i.e. FIFO type of data s
18,76,764
1948869 Asked
3,689
Active Tutors
1412305
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!