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.
Industrial Cluster in Tamil Nadu TNPSC Questions Pdf More
Food and Security TNPSC Questions Pdf More
Economics Food Security and Nutrition Class 10 Questions Pdf More
Class 10th Social Indian Constitution Pdf More
TNPSC Indian Constitution Questions and Answers Pdf More
1000+ Microprocessor Quiz Questions and Answers Pdf More
List of Diseases Caused by Bacteria and their Symptoms More
100+ One Word Substitution Questions for Competitive Exams More
Top 10,000+ Computer Awareness Quiz for Bank Exams 2020-21 More
1000+ Building Materials MCQ Questions and Answers Pdf More