Oracle Streams Interview Question and Answers

13. What is Database Change Notification?
  Database Change Notification is a service that is used to notify the registered clients whenever a change is committed.
 
Your Name Your Email-ID
Your Answer
14. List some important Streams views?
  Following are some important Streams views:
  • DBA_STREAMS_TABLE_RULES
  • DBA_APPLY_CONFLICT_COLUMNS
  • GV$STREAMS_CAPTURE
 
Your Name Your Email-ID
Your Answer
15. What is downstream capture?
 
  • Generally, capture process functions at source database.
  • However, if you want to save resources at the source database, you can set up another database for the capture process only.
  • The feature which allows you to move capture process to another database is called downstream capture.
 
Your Name Your Email-ID
Your Answer
16. What is Logical Change Record (LCR)?
  LCR contains database changes, streams require the changes to be captured in specific format. LCR keeps the changes in that format.
 
Your Name Your Email-ID
Your Answer
12345 Page 4 of 5