a2zinterviews

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.
	Discuss 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.
	Discuss 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.
	Discuss 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.
	Discuss Your Name Your Email-ID Your Answer