Oracle Streams Interview Question and Answers

5. What is the capture process?
  Capture process extracts database changes from redo log files at source. It is a background process.
 
Your Name Your Email-ID
Your Answer
6. What is direct apply?
  When the apply process applies the LCR directly at the target, it is called direct apply.
 
Your Name Your Email-ID
Your Answer
7. What is the apply process?
 
  • The apply process is a background process that runs on target database.
  • It dequeues messages (LCR) and applies those to the target database either directly or through handler.
 
Your Name Your Email-ID
Your Answer
8. What is SYS.AnyData?
 
  • SYS.AnyData is a queue that can capture messages of type AnyData.
  • This is a standard used in the Streams replication for storing LCRs.
  • The reason for using this queue is that messages are wrapped into type AnyData before queuing.
 
Your Name Your Email-ID
Your Answer
12345 Page 2 of 5