Oracle Streams 11g Interview Questions and Answers - 1
What is the difference between Oracle streams and CDC?
Oracle streams are based on advance queues. The streams provide a mechanism to synchronize data between two servers.
Streams ensure reliable data synchronization between the servers based on the defined rules.
Both Oracle CDC and Streams are generally used for data synchronization between Oracle database servers. With Oracle CDC, you could write your own data export routines, which create flat files for the purpose of synchronization between two database servers; whereas, with Streams you must have a network link between the two servers.
What is Streams?
An oracle stream is a data replication and integration feature.
It enables the propagation of data, transactions, and events in a data stream either within a database or from one database to another.
What is Stream replication?
Stream replication uses the information available in redo logs to synchronize data between two servers.
The capture process captures the changes at source, and the changes are transported to the target database, which generates the transactions and the apply process applies those transactions.
What is Change Data Capture?
CDC is a technique to capture changes in database tables. These changes are stored in special tables.
CDC operates in two modes: asynchronous, which is based on Java, and synchronous, which is used on database triggers.
Performance overhead is higher in case of synchronous CDC.
What is the capture process?
Capture process extracts database changes from redo log files at source. It is a background process.
1000+ Civil Engineering Question Bank Pdf More
1000+ Construction Materials Objective Questions & Answers More
1000+ Fluid Mechanics Quiz Questions and Answers Pdf More
1000+ Fluid Mechanics Question Bank with Answers Pdf More
1000+ Fluid Mechanics Multiple Choice Questions and Answers Pdf More
Top 100+ Simplification Problems with Solutions Pdf More
Operating System Multiple Choice Questions and Answers More
National Gk Questions and Answers 2020-2021 More
.Net Assemblies Interview Questions and Answers More
Sentence Correction Online Test for Bank Exams More