Quiz
OCA-8-Introducing Oracle Database 12c Components and Architecture
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do 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
Informações
- Descrição
- OCA-8-Introducing Oracle Database 12c Components and Architecture
- Autor
- Jamonero Blanco
- Idioma
- Español
- Visualizações
- 598
- Etiquetas
- Avaliação
- 5,0 de 5 · 2 avaliações Avalie este quiz