Oracle Streams 11g Interview Questions and Answers - 2

Question: 6

What is direct apply?

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

Question: 7

What is the apply process?

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.

Question: 8

What is SYS.AnyData?

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.

Question: 9

How can you set DML handler?

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)

Question: 10

Why is additional supplemental logging needed?

Default logging process records the information about DML operations.

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