WGU D192 questions with verified answers
-silent Ans✓✓✓-A command-line option used to invoke DBUA in silent mode. In
silent mode, no user input is obtained.
Archived redo log file Ans✓✓✓-A copy of a redo log file before it is overwritten
by new redo information.
ARCn Ans✓✓✓-is the archiver process that copies the content of redo logs to
archive redo log files. The archiver process can have multiple processes, which
allow the archiver to write to various destinations such as D: drive, E drive or
other storage.
ASH (Active Session History) Ans✓✓✓-Refers to the data that is sampled at
specified intervals from the current state of all active sessions.
ASM (Automatic Storage Management) storage Ans✓✓✓-Designed to relieve the
burden of disk and storage management and relies on Oracle to maintain the
database storage.
catctl.pl Ans✓✓✓-A script that performs the upgrade in parallel, making use of
the CPU resources available.
CKPT Ans✓✓✓-is the checkpoint process. In Oracle, data that is on disk is called
block and the data which in memory is called buffer. When a block is written to
the buffer and changed, the buffer becomes dirty, and it needs to be written
down to the disk. This process updates the control and data file headers with
checkpoint information and signals writing of dirty buffers to disk. Note that
Oracle 12c allows both full and incremental checkpoints.
, Consumer groups Ans✓✓✓-Used to group user sessions together so that the
different groups can be assigned different processing requirements.
Control files Ans✓✓✓-Contain 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 Block Ans✓✓✓-corresponds to a number of bytes on the disk. Oracle stores
data in these. These are also referred to as logical blocks, Oracle blocks or pages.
Data dictionary views Ans✓✓✓-Provide information about the database and its
objects.
Data files Ans✓✓✓-Physical files that actually store the data that has been
inserted into each table in the database.
Data Pump Ans✓✓✓-A high-speed mechanism for transferring data or metadata
from one database to another or from operating-system files.
Database buffer cache Ans✓✓✓-An area in SGA that caches the database data,
holding blocks from the data files that have been accessed recently.
DBA Ans✓✓✓-The most powerful role in the database. This role has all the
system privileges and several administrative privileges.
-silent Ans✓✓✓-A command-line option used to invoke DBUA in silent mode. In
silent mode, no user input is obtained.
Archived redo log file Ans✓✓✓-A copy of a redo log file before it is overwritten
by new redo information.
ARCn Ans✓✓✓-is the archiver process that copies the content of redo logs to
archive redo log files. The archiver process can have multiple processes, which
allow the archiver to write to various destinations such as D: drive, E drive or
other storage.
ASH (Active Session History) Ans✓✓✓-Refers to the data that is sampled at
specified intervals from the current state of all active sessions.
ASM (Automatic Storage Management) storage Ans✓✓✓-Designed to relieve the
burden of disk and storage management and relies on Oracle to maintain the
database storage.
catctl.pl Ans✓✓✓-A script that performs the upgrade in parallel, making use of
the CPU resources available.
CKPT Ans✓✓✓-is the checkpoint process. In Oracle, data that is on disk is called
block and the data which in memory is called buffer. When a block is written to
the buffer and changed, the buffer becomes dirty, and it needs to be written
down to the disk. This process updates the control and data file headers with
checkpoint information and signals writing of dirty buffers to disk. Note that
Oracle 12c allows both full and incremental checkpoints.
, Consumer groups Ans✓✓✓-Used to group user sessions together so that the
different groups can be assigned different processing requirements.
Control files Ans✓✓✓-Contain 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 Block Ans✓✓✓-corresponds to a number of bytes on the disk. Oracle stores
data in these. These are also referred to as logical blocks, Oracle blocks or pages.
Data dictionary views Ans✓✓✓-Provide information about the database and its
objects.
Data files Ans✓✓✓-Physical files that actually store the data that has been
inserted into each table in the database.
Data Pump Ans✓✓✓-A high-speed mechanism for transferring data or metadata
from one database to another or from operating-system files.
Database buffer cache Ans✓✓✓-An area in SGA that caches the database data,
holding blocks from the data files that have been accessed recently.
DBA Ans✓✓✓-The most powerful role in the database. This role has all the
system privileges and several administrative privileges.
