SQL *NET is ORACLE's mechanism for interfacing with the communication protocols
used by the networks that facilitate distributed processing and distributed databases. It is
used in Clint-Server and Server-Server communications.
2. Oracle Cross Products and Matrix
Reports Interview Questions and
Answers
1. How can a cross product be created?
By selecting the cross products tool and drawing a new group surrounding the base group
of the cross products.
2. How can a group in a cross products be visually distinguished from a group that does not
form a cross product?
A group that forms part of a cross product will have a thicker border.
3. Atleast how many set of data must a data model have before a data model can be base on
it?
Four.
4. Is it possible to have a link from a group that is inside a cross product to a group outside ?
(Y/N)
No.
5. Is it possible to link two groups inside a cross products after the cross products group has
been created?
No.
6. What is an user exit used for?
A way in which to pass control (and possibly arguments ) form Oracle report to another
Oracle products of 3 GL and then return control ( and ) back to Oracle reprots.
7. What are the three types of user exits available ?
Oracle Precompiler exits, Oracle call interface,NonOracle user exits.
8. How can values be passed bet. precompiler exits & Oracle call interface?
By using the statement EXECIAFGET & EXECIAFPUT.
9. How can I message to passed to the user from reports?
By using [Link] function.
3. Oracle Managing Distributed Databases Interview Questions and Answers
1. How can we reduce the network traffic?
- Replication of data in distributed environment.
- Using snapshots to replicate data.
- Using remote procedure calls.
2. What is snapshots?
Snapshot is an object used to dynamically replicate data between distribute database at
specified time intervals. In ver 7.0 they are read only.
3. What are the various type of snapshots?
Simple and Complex.
4. Differentiate simple and complex, snapshots?
- A simple snapshot is based on a query that does not contains GROUP BY clauses,
CONNECT BY clauses, Joins, sub-query or snapshot of operations.
- A complex snapshots contain at least any one of the above.
5. What dynamic data replication?