OCA Exam Quiz: Oracle Database Administration!
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.
- 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 areaExplanation
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 processExplanation
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 processExplanation
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 eachExplanation
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 controlfileExplanation
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, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 28, 2009Quiz Created by
Danial98
- Accreditation Quizzes
- Advanced Placement Quizzes
- AED Exam Quizzes
- Art Exam Quizzes
- Banking Exam Quizzes
- BISC Exam Quizzes
- CADET Exam Quizzes
- CAE Listening Quizzes
- CHS Exam Quizzes
- Computer Operator Exam Quizzes
- Cosmetology State Board Quizzes
- CSAT Quizzes
- CVS Exam Quizzes
- EHR Exam Quizzes
- Engineering Exam Quizzes
- English Exam Quizzes
- Entrance Exam Quizzes
- FSHN Exam Quizzes
- GATE Quizzes
- IGCSE Quizzes
- IT Certification Quizzes
- JEE Exam Quizzes
- Management Exam Quizzes
- Ministerial Exam Quizzes
- Online Test Quizzes
- Physical Exam Quizzes
- Police Exam Quizzes
- Practice Exam Quizzes
- Prelim Exam Quizzes
- Professional Certification Quizzes
- SNAP Quizzes
- SSC Quizzes
- SSC CGL Quizzes
- UGC NET Exam Quizzes
- UPSC Quizzes
Back to top