Advanced Queuing   «Prev  Next»

Advanced Queuing - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which of the following built-in PL/SQL packages contains the procedures needed to implement Advanced Queuing?
Please select all the correct answers.
  A. DBMS_QUEUES
  B. DBMS_ENQUEUE
  C. DBMS_AQ
  D. DBMS_AQADM

2. Which of the following procedure calls are found in the DBMS_AQ built-in package?
Please select all the correct answers.
  A. CREATE_QUEUE
  B. ENQUEUE
  C. SCHEDULE_PROPAGATION
  D. DEQUEUE

3. Which of the following data dictionary views can you use to get dynamic statistical information about queues?
Please select the best answer.
  A. ALL_QUEUES
  B. QUEUE_SCHEDULES
  C. QUEUE_PRIVILEGES
  D. V$ AQ