Core Oracle DBA Interview Questions and Answers - 2

Question: 6

Name some of the procedures available in the dbms_application_info package.

The procedures available in the dbms_application_info package are set_module, sect_action, read_module, set_client_info, read_client_info and set set_session_longtops.

Question: 7

How can you schedule a job in database?

You can use the dbms_scheduler package to create and schedule a database job.

Question: 8

How can you manage optimizer statistics?

You can manage optimizer statistics through the dbms_stats package.

This package offers multiple functions or procedures to gather, modify and remove statistics.

Statistics stored in the dictionary have an impact on the cost based optimizer. You can also use the dbms_stats procedure to gather statistics in parallel.

Question: 9

How can you implement fine grained auditing?

Oracle has provided a package called dbms_fga to implement fine grained auditing. It contains the following procedures.

Add_policy

Drop_policy

Enable_policy

Disable_policy

Question: 10

List the log miner procedures.

Log miner procedures are given as follows:

ADD_LOGFILE – Adds a file to the existing or newly created list of archive files to process.

START_LOGMNR – Initializes the LogMiner utility

END_LOGMNR – Finishes a LogMiner session

The following two functions can also be used with log miners:

MINE_VALUE (function) – Returns undo or redo value for the column specified as parameter based on the data present in the v$logmnr_contents view

COLUMN_PRESENT ( function) – Verifies whether undo or redo values is present in the v$logmnr _contents view for the column specified as parameter.