Interview Questions.

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

Naming of the NIC tool motive force has the subsequent constraints:

The name can include alphanumeric and underscore (_) characters simplest

The first and last characters of the name can't be a range of

The name period cannot exceed 16 characters. The advocated duration is three–eight characters

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

IP is a STREAMS module in the Oracle Solaris working surroundings. Any module or driving force interface with IP should comply with the STREAMS mechanism. There are no precise necessities for the interface among IP and network drivers.

Q3. What Is Change Data Capture?

CDC is a technique to capture modifications in database tables. These adjustments are saved in unique tables.

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

Performance overhead is higher in case of synchronous CDC.

Q4. List Some Important Streams Views?

Following are a few vital Streams perspectives:

DBA_STREAMS_TABLE_RULES

DBA_APPLY_CONFLICT_COLUMNS

GV$STREAMS_CAPTURE

Q5. Why Is Additional Supplemental Logging Needed?

Default logging procedure statistics the facts about DML operations.

Supplemental logging is required to pick out the rows to be updated on every vacation spot.

Q6. What Is The Apply Process?

The observe process is a historical past process that runs heading in the right direction database.

It dequeues messages (LCR) and applies those to the target database either at once or thru handler.

Q7. What Is Oracle Streams?

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

It gives equipment to capture, process (level), and manipulate database events through Advanced Queuing Queues.

Q8. What Is The Capture Process?

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

Q9. What Is Streams Pool In Oracle 10g?

Streams pool is part of System Global Area (SGA) from which reminiscence for Streams is allocated if it's miles configured. It may be configured by using 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 dimensions of the Stream pool is same to 0, then the reminiscence used by Streams is allocated from the shared pool that may dissipate to ten% of the shared pool.

Q10. What Is Direct Apply?

When the practice method applies the LCR directly at the goal, it's miles known as direct follow.

Q11. What Is Stream Replication?

Stream replication uses the records to be had in redo logs to synchronize facts among two servers.

The seize manner captures the changes at supply, and the changes are trported to the goal database, which generates the tractions and the practice method applies those tractions.

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

You ought to use Logminer or Streams

Q13. What Is The Difference Between Oracle Streams And Cdc?

Oracle streams are based totally on enhance queues. The streams offer a mechanism to synchronize information between two servers.

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

Both Oracle CDC and Streams are typically used for facts synchronization between Oracle database servers. With Oracle CDC, you could write your very own statistics export routines, which create flat files for the motive of synchronization among two database servers; whereas, with Streams you ought to have a community hyperlink among the 2 servers.

Q14. What Is Sys.Anydata?

SYS.AnyData is a queue which could seize messages of type AnyData.

This is a popular used inside the Streams replication for storing LCRs.

The purpose for using this queue is that messages are wrapped into kind AnyData earlier than queuing.

Q15. What Is Downstream Capture?

Generally, capture technique features at source database.

However, in case you want to keep assets on the supply database, you could installation some other database for the seize manner best.

The function which allows you to transport seize technique to every other database is called downstream capture.

Q16. How Can You Set Dml Handler?

DML handler may be set by means of the use of the following statement:

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

Q17. What Is Logical Change Record (lcr)?

LCR includes database adjustments, streams require the changes to be captured in unique layout. LCR keeps the modifications in that layout.

Q18. What Is Database Change Notification?

Database Change Notification is a provider this is used to inform the registered clients every time a exchange is committed.

Q19. What Is Streams?

An oracle stream is a data replication and integration feature.

It permits the propagation of statistics, tractions, and events in a records circulate either within a database or from one database to another.

Q20. How Can You Find The Setup Of Lob_assembly?

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