6 + Interview Questions in Oracle Streams Interview Questions in Oracle Streams Tutorial Page 1 InterviewSolution

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

1.

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.

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.

Discussion

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

2.

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

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

Discussion

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

3.

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.

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.

Discussion

4.	What Is Direct Apply?
Answer» When the APPLY process applies the LCR directly at the TARGET, it is CALLED DIRECT apply. When the apply process applies the LCR directly at the target, it is called direct apply.

4.

What Is Direct Apply?

Answer»

When the APPLY process applies the LCR directly at the TARGET, it is CALLED DIRECT apply.

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

Discussion

5.	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. Default logging process records the information about DML operations. Supplemental logging is required to identify the rows to be updated on each destination.

5.

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.

Default logging process records the information about DML operations.

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

Discussion

6.	List Some Important Streams Views?
Answer» FOLLOWING are some IMPORTANT STREAMS VIEWS: DBA_STREAMS_TABLE_RULES DBA_APPLY_CONFLICT_COLUMNS GV$STREAMS_CAPTURE Following are some important Streams views:

6.

List Some Important Streams Views?

Answer»

FOLLOWING are some IMPORTANT STREAMS VIEWS:

DBA_STREAMS_TABLE_RULES
DBA_APPLY_CONFLICT_COLUMNS
GV$STREAMS_CAPTURE

Following are some important Streams views:

Discussion

Explore topic-wise InterviewSolutions in .

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?

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

What Is Streams?

What Is Direct Apply?

Why Is Additional Supplemental Logging Needed?

List Some Important Streams Views?