Oracle Packages Interview Question and Answers

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.
 
Your Name Your Email-ID
Your Answer
10. What is a user defined lock?
 
  • Oracle manages database resources through locking mechanism.
  • These locks are usually managed by the system and are released on commit or rollback of a transaction.
  • However, Oracle has provided this functionality to the users so that they can create user defined locks.
  • These locks are similar to system created locks in functionality but are not released automatically when transaction commits or rollbacks. Therefore, a user has to be extremely careful while using user defined locks.
 
Your Name Your Email-ID
Your Answer
11. What functionality does Oracle provide to secure sensitive information?
 
  • You can use the dbms_obfuscation_toolkit package to encrypt sensitive information.
  • The Data Encryption Standard (DES) or triples DES algorithm can be used to encrypt the data.
 
Your Name Your Email-ID
Your Answer
12. List some of the procedures provided by the dbms_aq package?
  Some of the procedures provided by the dbms_aq package are enqueue, dequeue, register and unregister.
 
Your Name Your Email-ID
Your Answer
12345678910 Page 3 of 10