Copy and Edit

OCA-8-Introducing Oracle Database 12c Components and Architecture

Description

OCA-8-Introducing Oracle Database 12c Components and Architecture
Jamonero Blanco
Quiz by Jamonero Blanco, updated more than 1 year ago
Jamonero Blanco
Created by Jamonero Blanco about 7 years ago
554
3
0

Resource summary

Question 1

Question
1.Choose two SGA structures that are required in every Oracle instance.
Answer
  • A. Large pool
  • B. Shared pool
  • C. Buffer cache
  • D. Java pool

Question 2

Question
2. Which statement is true
Answer
  • A. A database can have only one control file.
  • B. A database must have at least two control files.
  • C. A database may have zero or more control files.
  • D. A database must have at least one control file.

Question 3

Question
3. Which component is configured at database startup and cannot be dynamically managed?
Answer
  • A. Redo log buffer.
  • B. Streams pool
  • C. Java pool
  • D. Shared pool
  • E. None of the above

Question 4

Question
4. Which component is not part of an Oracle instance?
Answer
  • A. System global area.
  • B. Process monitor
  • C. Control file
  • D. Shared pool
  • E. None

Question 5

Question
5. Which background process guarantees that committed data is saved even when the changes have not been recorded in data files?
Answer
  • A. DBWn
  • B. PMON
  • C. LGWR
  • D. CKPT
  • E. ARCn

Question 6

Question
6. 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?
Answer
  • A. Writes the changed blocks to data files.
  • B. Writes the changed blocks to redo log files.
  • C. Triggers checkpoint and thus LGWR writes the changes to redo log files.
  • D. Does nothing.

Question 7

Question
7. Which of the following best describes a RAC configuration?
Answer
  • A. One database, multiple instances
  • B. One instance, multiple databases
  • C. Multiple databases plugged in from multiple servers
  • D. Multiple databases, multiple instances

Question 8

Question
8. Which component of the SGA contains the parsed SQL code?
Answer
  • A. Database buffer cache
  • B. Dictionary cache
  • C. Library cache
  • D. Parse cache

Question 9

Question
9. Which tasks are accomplished by the SMON process? (Choose all that apply.)
Answer
  • A. Performs recovery at instance startup
  • B. Performs cleanup after a user session is terminated
  • C. Starts any server process that stopped running
  • D. Coalesces contiguous free space in dictionary-managed tablespaces

Question 10

Question
10. Choose the best statement from the options related to segments.
Answer
  • A. A contiguous set of blocks constitutes a segment.
  • B. A nonpartitioned table can have only one segment.
  • C. A segment can belong to more than one tablespace.
  • D. All of the above are true.

Question 11

Question
11. From the following list, choose two processes that are optional in an Oracle Database 12c database.
Answer
  • A. MMON
  • B. MMNL
  • C. ARCn
  • D. MMAN

Question 12

Question
12. Which SGA component will you increase or configure so that RMAN tape backups do not use memory from the shared pool?
Answer
  • A. Java pool
  • B. Streams pool
  • C. Recovery pool
  • D. Large pool

Question 13

Question
13. When a user session is terminated, which processes are responsible for cleaning up and releasing locks? (Choose all that apply.)
Answer
  • A. DBWn
  • B. LGWR
  • C. MMON
  • D. PMON
  • E. SMON

Question 14

Question
14. The LRU algorithm is used to manage what part of the Oracle architecture?
Answer
  • A. Users who log on to the database infrequently and may be candidates for being dropped
  • B. The data file that stores the least amount of information and will need the least frequent backup
  • C. The tables that users rarely access so that they can be moved to a less active tablespace
  • D. The shared pool and database buffer cache portions of the SGA

Question 15

Question
15. 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?
Answer
  • A. An instance consists of memory structures and processes, whereas a database is composed of physical files.
  • B. An instance is used only during database creation; after that, the database is all that is needed.
  • C. An instance is started whenever the demands on the database are high, but the database is used all the time.
  • D. An instance is configured using a pfile, whereas a database is configured using a spfile.

Question 16

Question
16. Which of the following is the proper order of Oracle’s storage hierarchy, from smallest to largest?
Answer
  • A. Operating-system block, database block, segment, extent
  • B. Operating-system block, database block, extent, segment
  • C. Segment, extent, database block, operating-system block
  • D. Segment, database block, extent, operating-system block

Question 17

Question
17. 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:
Answer
  • A. Oracle spawns another PMON process automatically.
  • B. The database hangs, and the DBA must manually start a PMON process.
  • C. If the database is in ARCHIVELOG mode, Oracle automatically starts another PMON process and recovers from the database hang.
  • D. The instance crashes and needs to be restarted.

Question 18

Question
18. When an incremental checkpoint happens in a database, which file(s) are updated with the checkpoint position? Choose all options that are correct.
Answer
  • A. Data files
  • B. Control files
  • C. Initialization Parameter Files
  • D. Redo log files
  • E. Archive log files

Question 19

Question
19. 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.
Answer
  • A. Oracle reads the blocks from data file to buffer cache and updates the blocks.
  • B. Changed blocks from the buffer cache are written to data files.
  • C. The user commits the change.
  • D. LGWR writes the changed blocks to the redo log buffer.
  • E. The server process writes the change vectors to the redo log buffer.
  • F. LGWR flushes the redo log buffer to redo log files.
  • G. A checkpoint occurs.

Question 20

Question
20. 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
Answer
  • A. Group 1 and 4
  • B. Group 2 and 3
  • C. Groups 1 through 4
  • D. Group 1
  • E. Group 4
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Ciencia Abierta en la UNC
Mario Pizzi
ROUND & TRUNC [DATES]
Adrian Mora
Social Psychology, Milgram (1963)
Robyn Chamberlain
Waves
kate.siena
Principles of basic electrical circuits
Vito Martino
Geography: Population
ameliaalice
Introduction to the Atom
Sarah Egan
1_PSBD New Edition
Ps Test
Legislative Branch
Mr. Vakhovsky
General Pathoanatomy Final MCQs (401-519)- 3rd Year- PMU
Med Student
Mapa Mental para Resumir y Conectar Ideas
Ricardo Padilla Alcantara
Browse Library