a2zinterviews

13.	How can you grant privileges on AQ to other users?
	You cannot grant privileges on AQ by using grant statement similar to other Oracle objects. grant_system_privilege – Grants AQ system privileges revoke_ system_privilege – Revokes AQ system privileges grant_queue_privilege – Grants privileges on AQ revoke_queue_privilege – Revokes privileges on AQ.
	Discuss Your Name Your Email-ID Your Answer

14.	How can you enable flashback feature?
	Oracle provides the dbms_flashback package to use flashback feature. The package has the following procedures to facilitate this feature: Enable_at_time Enable_at_system_change_number Get_system_change_number Disable
	Discuss Your Name Your Email-ID Your Answer

15.	How does Oracle facilitate communication between different sessions?
	You can use the dbms_pipe package to communicate between different sessions. The information send through pipe is stored in SGA and is lost when instance is shut down.
	Discuss Your Name Your Email-ID Your Answer

16.	How can you record information about current session?
	Oracle provides a package called dbms_application_info. This package can be used to set information about current session.
	Discuss Your Name Your Email-ID Your Answer