Interview Questions.

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 using specifying initialization parameter, STREAMS_POOL_SIZE.

If the scale of the Streams pool is greater than zero, then any SGA reminiscence utilized by Stream is allocate from the Streams pool.

If the scale of the Stream pool is identical to zero, then the reminiscence utilized by Streams is allocated from the shared pool that could deplete to 10% of the shared pool.

Question 2. What Is Database Change Notification?

Answer :

Database Change Notification is a carrier that is used to notify the registered clients each time a change is dedicated.

Data Warehouse ETL Toolkit Interview Questions
Question 3. List Some Important Streams Views?

Answer :

Following are some essential Streams views:

DBA_STREAMS_TABLE_RULES
DBA_APPLY_CONFLICT_COLUMNS
GV$STREAMS_CAPTURE
Question four. What Is Downstream Capture?

Answer :

Generally, capture system features at source database.

However, if you want to shop sources on the supply database, you could installation any other database for the capture technique most effective.

The characteristic which allows you to move capture system to every other database is referred to as downstream capture.

Data Warehouse ETL Toolkit Tutorial
Question five. What Is Logical Change Record (lcr)?

Answer :

LCR incorporates database modifications, streams require the modifications to be captured in particular layout. LCR keeps the modifications in that format.

Data Warehousing Interview Questions
Question 6. How Can You Set Dml Handler?

Answer :

DML handler can be set by means of the use of the subsequent declaration:

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

Question 7. Why Is Additional Supplemental Logging Needed?

Answer :

Default logging technique information the data about DML operations.

Supplemental logging is needed to become aware of the rows to be updated on every vacation spot.

Data Warehousing Tutorial Oracle DBA Interview Questions
Question eight. What Is Oracle Streams?

Answer :

The oracle streams product from Oracle Corporation encourages customers of Oracle databases to propagate data within and among databases.

It gives equipment to seize, procedure (degree), and control database occasions through Advanced Queuing Queues.

Question nine. How Can You Find The Setup Of Lob_assembly?

Answer :

You can locate the setup of lob_assembly via the usage of the DBA_APPLY_DML_HANDLER view.

Oracle 11g Interview Questions
Question 10. What Is The Capture Process?

Answer :

Capture method extracts database modifications from redo log files at supply. It is a background technique.

Oracle DBA Tutorial
Question eleven. What Is Direct Apply?

Answer :

When the apply procedure applies the LCR without delay at the goal, it's far referred to as direct follow.

Oracle Data Integrator (ODI) Interview Questions
Question 12. What Is The Apply Process?

Answer :

The practice process is a history process that runs on course database.

It dequeues messages (LCR) and applies those to the target database either immediately or through handler.

Data Warehouse ETL Toolkit Interview Questions
Question thirteen. What Is Sys.Anydata?

Answer :

SYS.AnyData is a queue that may capture messages of kind AnyData.

This is a wellknown used within the Streams replication for storing LCRs.

The reason for the usage of this queue is that messages are wrapped into type AnyData before queuing.

Oracle 11g Tutorial
Question 14. What Is Streams?

Answer :

An oracle move is a statistics replication and integration feature.

It allows the propagation of facts, transactions, and occasions in a facts movement both within a database or from one database to every other.

Question 15. What Is Stream Replication?

Answer :

Stream replication uses the statistics available in redo logs to synchronize information between  servers.

The seize system captures the adjustments at source, and the changes are transported to the target database, which generates the transactions and the apply method applies those transactions.

RMAN (Recovery Manager) Interview Questions
Question 16. What Is The Difference Between Oracle Streams And Cdc?

Answer :

Oracle streams are based totally on advance queues. The streams offer a mechanism to synchronize facts between  servers.

Streams make certain reliable facts synchronization between the servers primarily based on the defined rules.

Both Oracle CDC and Streams are typically used for records synchronization between Oracle database servers. With Oracle CDC, you may write your own statistics export routines, which create flat documents for the cause of synchronization among  database servers; while, with Streams you need to have a network hyperlink between the two servers.

Question 17. What Is Change Data Capture?

Answer :

CDC is a method to seize adjustments in database tables. These adjustments are saved in unique tables.

CDC operates in  modes: asynchronous, that's primarily based on Java, and synchronous, that's used on database triggers.

Performance overhead is higher in case of synchronous CDC.

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

Answer :

You ought to use Logminer or Streams

Data Warehousing Interview Questions
Question 19. What Are The Rules For Naming A Network Interface Card (nic) Device Driver?

Answer :

Naming of the NIC tool driver has the subsequent constraints:

The call can comprise alphanumeric and underscore (_) characters most effective

The first and closing characters of the call cannot be a number

The call period can not exceed 16 characters. The encouraged period is 3–8 characters

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

Answer :

IP is a STREAMS module within the Oracle Solaris operating surroundings. Any module or driving force interface with IP need to follow the STREAMS mechanism. There are no unique requirements for the interface between IP and network drivers.

Oracle Exadata Database Interview Questions