Oracle Streams Interview Questions & Answers

4 avg. rating (80% score) - 5879 votes

Oracle Streams Interview Questions & Answers

An oracle stream is all about information sharing. The stream is used to propagate message within database or to other data base. Oracle steams can be easily set up in the homogeneous or heterogeneous database. The streams are used to perform different functions like replication, message queuing, loading data into warehouse, event notification and data protection. You need to gain huge data management skills to get placed in the job of oracle streams. Oracle stream interview questions and answers at portal gives you a detailed list of job interview questions and answers for you to go through. These questions listed at the portal will help you stand out of the competition and win the game. Referring Oracle streams interview questions and answers before interview will help to brush your knowledge.

Oracle Streams Interview Questions

Oracle Streams Interview Questions
    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. Question 3. List Some Important Streams Views?

      Answer :

      Following are some important Streams views:


    4. 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.

    5. 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.

    6. 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)

    7. 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.

    8. 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.

    9. 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.

    10. Question 10. What Is The Capture Process?

      Answer :

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

    11. Question 11. What Is Direct Apply?

      Answer :

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

    12. 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.

    13. 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.

    14. 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.

    15. 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.

    16. 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.

    17. 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.

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

      Answer :

      You could use Logminer or Streams

    19. 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

    20. 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.

Oracle 11g Tutorial

All Tutorials

All Practice Tests

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

Oracle 11g Tutorial