Oracle Streams Interview Questions & Answers

  1. Question 1. What Is Streams Pool In Oracle 10g?

    Answer :

    Streams pool is a part of System Global Area (SGA) from which memory for Streams is allocated if it is configured. It can be configured by specifying initialization parameter, STREAMS_POOL_SIZE.

    If the size of the Streams pool is greater than zero, then any SGA memory used by Stream is allocate from the Streams pool.

    If the size of the Stream pool is equal to zero, then the memory used by Streams is allocated from the shared pool that may use up to 10% of the shared pool.

  2. Question 2. What Is Database Change Notification?

    Answer :

    Database Change Notification is a service that is used to notify the registered clients whenever a change is committed.

  3. Data Warehouse ETL Toolkit Interview Questions

  4. Question 3. List Some Important Streams Views?

    Answer :

    Following are some important Streams views:

    • DBA_STREAMS_TABLE_RULES
    • DBA_APPLY_CONFLICT_COLUMNS
    • GV$STREAMS_CAPTURE
  5. Question 4. What Is Downstream Capture?

    Answer :

    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.

  6. Data Warehouse ETL Toolkit Tutorial

  7. Question 5. What Is Logical Change Record (lcr)?

    Answer :

    LCR contains database changes, streams require the changes to be captured in specific format. LCR keeps the changes in that format.

  8. Data Warehousing Interview Questions

  9. Question 6. How Can You Set Dml Handler?

    Answer :

    DML handler can be set by using the following statement:

    Dbms_apply_adm.set_dml_handler (object_name, object_type, operation_name, error_handler, user_procedure, apply_db_link)

  10. Question 7. Why Is Additional Supplemental Logging Needed?

    Answer :

    Default logging process records the information about DML operations.

    Supplemental logging is required to identify the rows to be updated on each destination.

  11. Data Warehousing Tutorial
    Oracle DBA Interview Questions

  12. Question 8. What Is Oracle Streams?

    Answer :

    The oracle streams product from Oracle Corporation encourages users of Oracle databases to propagate information within and between databases.

    It provides tools to capture, process (stage), and manage database events through Advanced Queuing Queues.

  13. Question 9. How Can You Find The Setup Of Lob_assembly?

    Answer :

    You can find the setup of lob_assembly by using the DBA_APPLY_DML_HANDLER view.

  14. Oracle 11g Interview Questions

  15. Question 10. What Is The Capture Process?

    Answer :

    Capture process extracts database changes from redo log files at source. It is a background process.

  16. Oracle DBA Tutorial

  17. Question 11. What Is Direct Apply?

    Answer :

    When the apply process applies the LCR directly at the target, it is called direct apply.

  18. Oracle Data Integrator (ODI) Interview Questions

  19. Question 12. What Is The Apply Process?

    Answer :

    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.

  20. Data Warehouse ETL Toolkit Interview Questions

  21. Question 13. What Is Sys.anydata?

    Answer :

    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.

  22. Oracle 11g Tutorial

  23. Question 14. What Is Streams?

    Answer :

    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.

  24. Question 15. What Is Stream Replication?

    Answer :

    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.

  25. RMAN (Recovery Manager) Interview Questions

  26. Question 16. What Is The Difference Between Oracle Streams And Cdc?

    Answer :

    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.

  27. Question 17. What Is Change Data Capture?

    Answer :

    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.

  28. Database Administration Interview Questions

  29. Question 18. Give Two Methods You Could Use To Determine What Ddl Changes Have Been Made?

    Answer :

    You could use Logminer or Streams

  30. Data Warehousing Interview Questions

  31. Question 19. What Are The Rules For Naming A Network Interface Card (nic) Device Driver?

    Answer :

    Naming of the NIC device driver has the following constraints:

    The name can contain alphanumeric and underscore (_) characters only

    The first and last characters of the name cannot be a number

    The name length cannot exceed 16 characters. The recommended length is 3–8 characters

  32. Question 20. Is There Documentation That Describes The Interface Between Ip And Network Drivers, Namely, The Oracle-specific Requirements Not Outlined In The Dlpi Version 2 Specification?

    Answer :

    IP is a STREAMS module in the Oracle Solaris operating environment. Any module or driver interface with IP should follow the STREAMS mechanism. There are no specific requirements for the interface between IP and network drivers.

  33. Oracle Exadata Database Interview Questions