Snapshot replication in DBMS
What do you understand by the term snapshot replication in DBMS?
Expert
Snapshot replication can be employed if an application does not necessitate that the data always be current. Such applications can be updated by periodic table snapshots or copying. As part of the snapshot effort, all of the data to be consisted in the snapshot is collected at a primary point. And then a read-only snapshot is taken and is sent to each and every site and hence the update can be made.
Briefly explains the three kinds of SQL commands?
Describe a surrogate key and also explain the ideal primary key and illustrate how surrogate keys meet up this ideal?
explain binary relationship set and terenary relationship set
Describe the relationship among entity, entity class, and entity instance.
Explain how in a relation a supertype or subtype is mapped?
Briefly describe the five elements of an Information Systems Architecture and their relationship to data.
Why recursive relationships are not good? How do you solve them?
What is the corresponding of Oracle/Db2 Coalesce Function within Sybase?
Explain the way to select tables for partition in Sybase?
What the difference between sequential file stage and hashed file stage is in relates to DataStage Server?
18,76,764
1928543 Asked
3,689
Active Tutors
1412164
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!