a2zinterviews

21.	How can you find out if a table can be redefined?
	You can use the dbms_redefinition.can_redef_table procedure to determine if a table can be redefined.
	Discuss Your Name Your Email-ID Your Answer

22.	How can a session indicate its interest in receiving alerts?
	A session can register itself for a specific type of alert or a alerts by using the register procedure. Such sessions are called waiting session.
	Discuss Your Name Your Email-ID Your Answer

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

24.	What procedures can you use to register with an AQ?
	The user of an AQ is called a subscriber, which can be added through the add_subscriber procedure. It can be altered using the alter_subscriber procedure and removed using the drop_subscriber procedure of the dbms_aqadm package. Oracle also provides procedures to schedule propagation of message in an AQ. This procedure is called schedule_propagation. It can be unscheduled using the unscheduled_propagation procedure.
	Discuss Your Name Your Email-ID Your Answer