Oracle Core DBA Interview Questions Answers Pdf - 2

Question: 6

Does Oracle support asynchronous notification?

Oracle supports asynchronous notification using the dbms_alert package.

Question: 7

How can you get actual data change values from previous transactions in Oracle?

Oracle provides a feature called log minner, which can be used to view data changes from previous transactions.

Question: 8

Explain the major functions provided by the dbms_stats procedure.

The dbms_stats procedure performs the following general functions:

Set or get statistics using the set_xxx and get_xxx subprograms.

Transfer statistics using the export_xxx and import_xxx subprograms.

Gather optimizer statistics using the gather_xxx subprograms.

Question: 9

What is the use of recording information about current session?

The information is useful for tracing. You can get client information, module, or action information from different module of the application.

At runtime, you can query different performance views to find out the action performed by application at that specific time.

Question: 10

How does Oracle facilitate communication between different sessions?

You can use the dbms_pipe package to communicate between different sessions.

The information send through pipe is stored in SGA and is lost when instance is shut down.