Instance Architecture   «Prev  Next»

Other Oracle Processes- Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. In an Oracle RAC environment, what is the role of the LCK0 background process?
Please select the best answer.
  A. Writing redo entries to online redo log files.
  B. Encrypting private session data.
  C. Handling global enqueue requests and cross-instance broadcasts for resources other than data blocks.
  D. Detecting unauthorized login attempts.

2. Which background process executes a scheduled PL/SQL database job assigned by the job queue coordinator?
Please select the best answer.
  A. CJQ0
  B. LREG
  C. J000
  D. SMON

3. Which background process coordinates the primary processes used by Oracle Advanced Queuing?
Please select the best answer.
  A. LGWR
  B. CJQ0
  C. AQPC
  D. PMON

4. Which background process dynamically registers instance and service information with Oracle Net listeners?
Please select the best answer.
  A. LREG
  B. PMON
  C. DBW0
  D. ARC0

5. Which background process automatically resolves in-doubt distributed transactions when communication with the participating databases becomes available?
Please select the best answer.
  A. CKPT
  B. RECO
  C. LGWR
  D. AQPC