Senior DBA Interview Questions and Answers - 1

Question: 1

Which procedures can you use to encrypt and decrypt data in different formats?

Following procedures can be used to encrypt or decrypt data in different formats:

DESEncrypt – Generates the encrypted form of the input data

DESDecrypt – Generates the decrypted form of the input data

DES3Encrypt – Generates the encrypted form of the input data by passing it through the triple DES encryption algorithm.

DES3Decrypt – Generates the decrypted form of the input data.

Question: 2

How can you initialize log miner?

You can use the DBMS_LOGMNR.START_LOGMNR procedure to initialize the log miner.

Question: 3

How would you determine who has added a row to a table?

This can be determined by using the fine grained auditing feature for the table.

Question: 4

How can you process messages in order asynchronously?

Oracle provides a package called dbms_aq package to queue the messages, which can be consumed by another session or application in order.

Question: 5

When does an alert gets signaled?

Alerts are transaction based. Whenever, a transaction causing event of interest commits, the alert is signaled.