OCA Exam Quiz: Oracle Database Administration!

9 Questions | Total Attempts: 1849

SettingsSettingsSettings
OCA Exam Quizzes & Trivia

This online OCA Oracle database administration quiz is aimed to test your knowledge of 11g administration and help you prepare for OCA certification. This is a free online quiz to broaden your knowledge of database administration concerning 11g.


Questions and Answers
  • 1. 
    What statements regarding instance memory and session memory are correct?
    • A. 

      SGA memory is private memory segements: PGA memory is shared memory segments.

    • B. 

      Session can write to the PGA, not the SGA.

    • C. 

      The SGA is written to by all sessions: a PGA is written by one session.

    • D. 

      The PGA is allocated at instance startup.

    • E. 

      The SGA is allocated at instance startup.

  • 2. 
    What memory structures are a required part of the SGA?
    • A. 

      The database buffer cache

    • B. 

      The Java Pool

    • C. 

      The large pool

    • D. 

      The log buffer

    • E. 

      The program global area

  • 3. 
    How many sessions communicate with the database?
    • A. 

      Server processes use Oracle Net to connect to the instance.

    • B. 

      Background processes use Oracle Net to connect to the database.

    • C. 

      User processes read from the databae and write to the database.

    • D. 

      Server processes execute SQL received from user processes.

  • 4. 
    When a session changes data, where does the change get written? 
    • A. 

      To the data block in the cache, and the redo log buffer.

    • B. 

      To the data block on disk, and the current online redo log file.

    • C. 

      The session writes to the database buffer cache, and the log writer to the current online redo log file.

    • D. 

      Nothing the written until the change is committed.

  • 5. 
    Which of these background processes is optional?
    • A. 

      ARCn, the archive process

    • B. 

      CKPT, the checkpoint process

    • C. 

      DBWn, the database writer

    • D. 

      LGWR, the log writer

    • E. 

      MMON, the manageability monitor

  • 6. 
    What happens when a user issues a COMMITT? 
    • A. 

      The CKPT process signals a checkpoint

    • B. 

      The DBNw process writes the transaction's changed buffers to the datafiles.

    • C. 

      The LGWR flushes the log buffer to the online redo log.

    • D. 

      The ARCn process writes the change vectors to the archive redo log.

  • 7. 
    An Oracle instance can have only one of some processes, but several of others. Which of these processes can occur several times? 
    • A. 

      The archive process

    • B. 

      The checkpoint process

    • C. 

      The database writer process

    • D. 

      The log writer process

    • E. 

      The session server process

  • 8. 
    Which statement is correct regarding the online redo log? 
    • A. 

      There must be at least one log file group, with at least one memeber

    • B. 

      There must be at least one log file group, with at least two memebers

    • C. 

      There must be at least two log file group, with at least one memebers each

    • D. 

      There must be at least two log file group, with at least two memebers eacg

  • 9. 
    Where is the current redo byte address, also known as the incremental checkpoint positions, recorded? 
    • A. 

      In the controlfile

    • B. 

      In the current online log file group

    • C. 

      In the header of each datafile

    • D. 

      In the system global area

Related Topics
Back to Top Back to top