OCA Exam Quiz: Oracle Database Administration!

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Danial98
D
Danial98
Community Contributor
Quizzes Created: 2 | Total Attempts: 8,521
Questions: 9 | Attempts: 2,280

SettingsSettingsSettings
OCA Exam Quiz: Oracle Database Administration! - Quiz

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.

    Correct Answer(s)
    C. The SGA is written to by all sessions: a PGA is written by one session.
    E. The SGA is allocated at instance startup.
    Explanation
    C and E. The SGA is shared memory updated by all sessions; PGAs are private to each session. The SGA is allocated at startup time (but it can be modified later).
    A is wrong because it reverses the situation: it is the SGA that exists in shared memory, not the PGA. B is wrong because sessions write to both their own PGA and to the SGA. D is wrong because (unlike the SGA) the PGA is only allocated on demand.

    Rate this question:

  • 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

    Correct Answer(s)
    A. The database buffer cache
    D. The log buffer
    E. The program global area
    Explanation
    D. This is the client-server split: user processes generate SQL; server process execute SQL.
    A and B are wrong because they get the use of Oracle Net wrong. Oracle Net is the protocol between a user process and server process. C is wrong because it describes what server process do, not what user processes do.

    Rate this question:

  • 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.

    Correct Answer
    D. Server processes execute SQL received from user processes.
    Explanation
    A, D and F. Every instance must have a database buffer cache, a log buffer, and a shared pool. B, C are wong because Jave Pool, the large pool and the strema pool are only needed for certain option.

    Rate this question:

  • 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.

    Correct Answer
    A. To the data block in the cache, and the redo log buffer.
    Explanation
    A. The session updates the copy of the block in memory and writes out the change vector to the log buffer.
    B is wrong, because while this will happen, it does not happen when the change is made. C is wrong because it confuses the session making changes in memory with LGWR propagating changes to disk. D is wrong because all changes to data occur in memory as they are made - the COMMITT is not relevant.

    Rate this question:

  • 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

    Correct Answer
    A. ARCn, the archive process
    Explanation
    A. Archiving is not compulsory (though it is usually a good idea).
    B, C, D, E CKPT, DBWn, LGWR and MMON are all necessary processes.

    Rate this question:

  • 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.

    Correct Answer
    C. The LGWR flushes the log buffer to the online redo log.
    Explanation
    C. On COMMITT, the log writer flushes the log buffer to disk. No other background processes need do anything..
    A is wrong because checkpoiont only occur on request, or on orderly shutdown. B is wrong because the algorithm DBWn uses to select buffers to write to the datafiles is not related to COMMIT processing, but to how busy the buffer is. D is wrong because ARCn only copies filled online redo logs; it doesn't copy change vectors in real time.

    Rate this question:

  • 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

    Correct Answer(s)
    A. The archive process
    C. The database writer process
    E. The session server process
    Explanation
    A, C, and E. A and C are correct because the DBA can choose to configure multiple archive and database writer process. E is correct because one server process will be launched for every concurrent session. B & D are wong because an instance can have only one log writer process and only one checkpoint process.

    Rate this question:

  • 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

    Correct Answer
    C. There must be at least two log file group, with at least one memebers each
    Explanation
    C. Two groups of one memeber is the minimum required for the database to function. A & B are wrong because at least two groups are always required. D is wrong because while it is certainly advisable to multiplex the members, it is not technical requirement.

    Rate this question:

  • 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

    Correct Answer
    A. In the controlfile
    Explanation
    A. The checkpoint process writes the RBA to the controlfile.
    B,C, and D. The online logs, the datafiles, and SGA have no knowledge of where the current RBA is.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Aug 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 28, 2009
    Quiz Created by
    Danial98
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.