D192 - Data Systems Administration
exam questions and complete detailed
correct answers
A specific number of bytes on disk - answer ✔✔-To what does a data block correspond
physically?
No - answer ✔✔-Can a datafile span across more than one tablespace?
One for each partition - answer ✔✔-How many data segments are contained in a partitioned
table?
Nonclustered, non-index-organized tables - answer ✔✔-Which type of tables contains only one
data segment?
One - answer ✔✔-What is the minimum number of extents required for a segment?
Tablespaces, segments, extents, and data blocks - answer ✔✔-Which four components
comprise the logical structure of the database?
Yes - answer ✔✔-Can a segment span multiple data files?
,No - answer ✔✔-Can a segment span more than one tablespace?
Above - answer ✔✔-In the logical database structure hierarchy, is an extent above or below an
Oracle block?
PMON - Process Monitor - answer ✔✔-Which Oracle background process performs cleanup
after a failed user process?
The database buffer cache - answer ✔✔-Which component of the Shared Global Area (SGA)
contains the recently accessed data blocks that have been retrieved from the datafiles by user
processes?
The library cache - answer ✔✔-Which component of the Shared Global Area (SGA) contains
parsed SQL statements?
RMAN - Recovery Manager - answer ✔✔-Which Oracle tool is used to back up, restore, and
recover Oracle databases and datafiles?
SMON - System Monitor - answer ✔✔-After you issue the SHUTDOWN ABORT command, which
background process is activated on the next startup?
Control files - answer ✔✔-What contains the locations of other physical files, database name,
database block size, database character set, and recovery information? These files are required
to open the database.
Data files - answer ✔✔-What are the physical files that actually store the data that has been
inserted into each table in the database?
Database buffer cache - answer ✔✔-An area in SGA that caches the database data, holding
blocks from the data files that have been accessed recently.
, Log writer - answer ✔✔-Writes the blocks in the redo log buffer of the SGA to the online redo
log files.
Redo log buffer - answer ✔✔-A circular buffer in the SGA that holds information about the
changes made to the database data.
Oracle instance - answer ✔✔-Consists of Oracle's main memory structure called the system
global area (SGA, also known as the shared global area) and several Oracle background
processes.
Version Management - answer ✔✔-Version management maintains the integrity of your
database as well as control schemas. It provides an interface to manage, safeguard, and
replicate revisions of units of work.
Element mapping structure - answer ✔✔-An element mapping structure is the abstract
mapping structure that describes a storage component within the I/O stack.
Operator - answer ✔✔-Which of the following ODI Studio navigators manages and monitors
data integration processes in production?
SQL*Plus - answer ✔✔-Question 3 :Which of the following tools enables you to create, manage,
and monitor CDBs and PDBs?
Elements - answer ✔✔-Which of the following primary structures is known as the abstract
mapping structure?
Version Management - answer ✔✔-Which of the following provides an interface to manage,
safeguard, and replicate revisions of units of work?
exam questions and complete detailed
correct answers
A specific number of bytes on disk - answer ✔✔-To what does a data block correspond
physically?
No - answer ✔✔-Can a datafile span across more than one tablespace?
One for each partition - answer ✔✔-How many data segments are contained in a partitioned
table?
Nonclustered, non-index-organized tables - answer ✔✔-Which type of tables contains only one
data segment?
One - answer ✔✔-What is the minimum number of extents required for a segment?
Tablespaces, segments, extents, and data blocks - answer ✔✔-Which four components
comprise the logical structure of the database?
Yes - answer ✔✔-Can a segment span multiple data files?
,No - answer ✔✔-Can a segment span more than one tablespace?
Above - answer ✔✔-In the logical database structure hierarchy, is an extent above or below an
Oracle block?
PMON - Process Monitor - answer ✔✔-Which Oracle background process performs cleanup
after a failed user process?
The database buffer cache - answer ✔✔-Which component of the Shared Global Area (SGA)
contains the recently accessed data blocks that have been retrieved from the datafiles by user
processes?
The library cache - answer ✔✔-Which component of the Shared Global Area (SGA) contains
parsed SQL statements?
RMAN - Recovery Manager - answer ✔✔-Which Oracle tool is used to back up, restore, and
recover Oracle databases and datafiles?
SMON - System Monitor - answer ✔✔-After you issue the SHUTDOWN ABORT command, which
background process is activated on the next startup?
Control files - answer ✔✔-What contains the locations of other physical files, database name,
database block size, database character set, and recovery information? These files are required
to open the database.
Data files - answer ✔✔-What are the physical files that actually store the data that has been
inserted into each table in the database?
Database buffer cache - answer ✔✔-An area in SGA that caches the database data, holding
blocks from the data files that have been accessed recently.
, Log writer - answer ✔✔-Writes the blocks in the redo log buffer of the SGA to the online redo
log files.
Redo log buffer - answer ✔✔-A circular buffer in the SGA that holds information about the
changes made to the database data.
Oracle instance - answer ✔✔-Consists of Oracle's main memory structure called the system
global area (SGA, also known as the shared global area) and several Oracle background
processes.
Version Management - answer ✔✔-Version management maintains the integrity of your
database as well as control schemas. It provides an interface to manage, safeguard, and
replicate revisions of units of work.
Element mapping structure - answer ✔✔-An element mapping structure is the abstract
mapping structure that describes a storage component within the I/O stack.
Operator - answer ✔✔-Which of the following ODI Studio navigators manages and monitors
data integration processes in production?
SQL*Plus - answer ✔✔-Question 3 :Which of the following tools enables you to create, manage,
and monitor CDBs and PDBs?
Elements - answer ✔✔-Which of the following primary structures is known as the abstract
mapping structure?
Version Management - answer ✔✔-Which of the following provides an interface to manage,
safeguard, and replicate revisions of units of work?
