Senior DBA Interview Questions and Answers - 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.
How can you initialize log miner?
You can use the DBMS_LOGMNR.START_LOGMNR procedure to initialize the log miner.
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.
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.
When does an alert gets signaled?
Alerts are transaction based. Whenever, a transaction causing event of interest commits, the alert is signaled.
7000+ Computer Networking MCQ Questions and Answers Pdf More
7000+ Microsoft Office Practical Questions and Answers Pdf More
7000+ Microsoft Office MCQ Questions and Answers Pdf More
7000+ Microsoft Office Quiz Questions and Answers Pdf More
7000+ Cyber Security Quiz Questions and Answers Pdf More
Spreadsheet Objective Questions and Answers More
Vocabulary Words with Meaning, Synonyms and Antonyms Pdf More
Top 100+ Object Oriented Programming Quiz Questions & Answers More
1999+ TNPSC Group 2 Previous Year Question Papers 2023-2024 Pdf More
UPSC, SSC, IAS, IPS, TNPSC Prelims Mains Questions on Panchayati Raj More