a2zinterviews

5.	How can you create a user defined lock?
	The dbms_lock package can be used to create user defined locks.
	Discuss Your Name Your Email-ID Your Answer

6.	Does Oracle support asynchronous notification?
	Oracle supports asynchronous notification using the dbms_alert package.
	Discuss Your Name Your Email-ID Your Answer

7.	How can you get actual data change values from previous transactions in Oracle?
	Oracle provides a feature called log minner, which can be used to view data changes from previous transactions.
	Discuss Your Name Your Email-ID Your Answer

8.	Explain the major functions provided by the dbms_stats procedure.
	The dbms_stats procedure performs the following general functions: Set or get statistics using the set_xxx and get_xxx subprograms. Transfer statistics using the export_xxx and import_xxx subprograms. Gather optimizer statistics using the gather_xxx subprograms.
	Discuss Your Name Your Email-ID Your Answer