Quiz
OCA-8-Introducing Oracle Database 12c Components and Architecture
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (20)
11.Choose two SGA structures that are required in every Oracle instance.
- AA. Large pool
- BB. Shared pool
- CC. Buffer cache
- DD. Java pool
22. Which statement is true
- AA. A database can have only one control file.
- BB. A database must have at least two control files.
- CC. A database may have zero or more control files.
- DD. A database must have at least one control file.
33. Which component is configured at database startup and cannot be dynamically
managed?- AA. Redo log buffer.
- BB. Streams pool
- CC. Java pool
- DD. Shared pool
- EE. None of the above
44. Which component is not part of an Oracle instance?
- AA. System global area.
- BB. Process monitor
- CC. Control file
- DD. Shared pool
- EE. None
55. Which background process guarantees that committed data is saved even when the
changes have not been recorded in data files?- AA. DBWn
- BB. PMON
- CC. LGWR
- DD. CKPT
- EE. ARCn
66. User John has updated several rows in a table and issued a commit. What does the
DBWn (database writer) process do at this time in response to the commit event?- AA. Writes the changed blocks to data files.
- BB. Writes the changed blocks to redo log files.
- CC. Triggers checkpoint and thus LGWR writes the changes to redo log files.
- DD. Does nothing.
77. Which of the following best describes a RAC configuration?
- AA. One database, multiple instances
- BB. One instance, multiple databases
- CC. Multiple databases plugged in from multiple servers
- DD. Multiple databases, multiple instances
88. Which component of the SGA contains the parsed SQL code?
- AA. Database buffer cache
- BB. Dictionary cache
- CC. Library cache
- DD. Parse cache
99. Which tasks are accomplished by the SMON process? (Choose all that apply.)
- AA. Performs recovery at instance startup
- BB. Performs cleanup after a user session is terminated
- CC. Starts any server process that stopped running
- DD. Coalesces contiguous free space in dictionary-managed tablespaces
1010. Choose the best statement from the options related to segments.
- AA. A contiguous set of blocks constitutes a segment.
- BB. A nonpartitioned table can have only one segment.
- CC. A segment can belong to more than one tablespace.
- DD. All of the above are true.
1111. From the following list, choose two processes that are optional in an Oracle Database
12c database.- AA. MMON
- BB. MMNL
- CC. ARCn
- DD. MMAN
1212. Which SGA component will you increase or configure so that RMAN tape backups do
not use memory from the shared pool?- AA. Java pool
- BB. Streams pool
- CC. Recovery pool
- DD. Large pool
1313. When a user session is terminated, which processes are responsible for cleaning up and
releasing locks? (Choose all that apply.)- AA. DBWn
- BB. LGWR
- CC. MMON
- DD. PMON
- EE. SMON
1414. The LRU algorithm is used to manage what part of the Oracle architecture?
- AA. Users who log on to the database infrequently and may be candidates for being dropped
- BB. The data file that stores the least amount of information and will need the least frequent backup
- CC. The tables that users rarely access so that they can be moved to a less active tablespace
- DD. The shared pool and database buffer cache portions of the SGA
1515. Two structures make up an Oracle server: an instance and a database. Which of the
following best describes the difference between an Oracle instance and a database?- AA. An instance consists of memory structures and processes, whereas a database is
composed of physical files. - BB. An instance is used only during database creation; after that, the database is all
that is needed. - CC. An instance is started whenever the demands on the database are high, but the
database is used all the time. - DD. An instance is configured using a pfile, whereas a database is configured using
a spfile.
- AA. An instance consists of memory structures and processes, whereas a database is
1616. Which of the following is the proper order of Oracle’s storage hierarchy, from smallest
to largest?- AA. Operating-system block, database block, segment, extent
- BB. Operating-system block, database block, extent, segment
- CC. Segment, extent, database block, operating-system block
- DD. Segment, database block, extent, operating-system block
1717. The DBA unknowingly terminated the process ID belonging to the PMON process
of Oracle Database 12c database using the kill -9 command on Unix. Choose the
best answer:- AA. Oracle spawns another PMON process automatically.
- BB. The database hangs, and the DBA must manually start a PMON process.
- CC. If the database is in ARCHIVELOG mode, Oracle automatically starts another
PMON process and recovers from the database hang. - DD. The instance crashes and needs to be restarted.
1818. When an incremental checkpoint happens in a database, which file(s) are updated with
the checkpoint position? Choose all options that are correct.- AA. Data files
- BB. Control files
- CC. Initialization Parameter Files
- DD. Redo log files
- EE. Archive log files
1919. User Isabella updates a table and commits the change after a few seconds. Which of the
following actions are happening in the database? Order them in the correct sequence
and ignore the actions that are not relevant.- AA. Oracle reads the blocks from data file to buffer cache and updates the blocks.
- BB. Changed blocks from the buffer cache are written to data files.
- CC. The user commits the change.
- DD. LGWR writes the changed blocks to the redo log buffer.
- EE. The server process writes the change vectors to the redo log buffer.
- FF. LGWR flushes the redo log buffer to redo log files.
- GG. A checkpoint occurs.
2020. Querying the V$LOG file shows the following information. Which redo group files are
required for instance crash recovery?
SQL> select GROUP#, ARCHIVED, STATUS from V$LOG;
GROUP# ARC STATUS
---------- --- ----------------
1 NO CURRENT
2 NO INACTIVE
3 NO INACTIVE
4 NO ACTIVE- AA. Group 1 and 4
- BB. Group 2 and 3
- CC. Groups 1 through 4
- DD. Group 1
- EE. Group 4
Information
- Description
- OCA-8-Introducing Oracle Database 12c Components and Architecture
- Author
- Jamonero Blanco
- Language
- Español
- Views
- 598
- Tags
- Rating
- 5.0 out of 5 · 2 ratings Rate this quiz