Oracle Packages Interview Question and Answers

37. How can you create an Advanced Queuing (AQ)?
  Oracle provides the dbms_aqadm package to create an advanced queue. This package can be used to create, alter, and drop AQ. The procedure that provides these functions are given as follows:
  • Create_queue_table
  • Alter_queue_table
  • Drop_queue_table
  • Create_queue
  • Alter_queue
  • Drop_queue
  • Start_queue
  • Stop_queue
 
Your Name Your Email-ID
Your Answer
34. Suppose you want to audit specific activities on sensitive data. How can you achieve that?
  You can use the fine grained auditing features of Oracle.
 
Your Name Your Email-ID
Your Answer
39. How can you verify an existing current backup of OCR?
  The following command can be used to verify an existing backup of OCR: Ocrconfig – showbackup.
 
Your Name Your Email-ID
Your Answer
40. How do you resize a datafile?
  You can resize a datafile by using the ALTER DATABASE DATAFILE <file_name> RESIZE; statement.
 
Your Name Your Email-ID
Your Answer
12345678910 Page 10 of 10