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.
Describe briefly the term SQL Server Analysis Services cubes?
Name the main data structures used in these areas: Hierarchical data model, RDBMS and Network data model?
Explain the Slice and Dice attribute in the Business Objects?
Give brief introduction of the term breakpoint in SSIS?
Briefly describe the ETL procedure in data warehousing?
Write a brief note on the difference between data and database administration?
Explain the Filter transformation?
What is the corresponding of Oracle/Db2 Coalesce Function within Sybase?
Explain the term Data mart?
Explain the following term: a) ROLAP b) MOLAP
18,76,764
1945909 Asked
3,689
Active Tutors
1444934
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!